Restore MariaDB database from .sql file

Import a .sql dump into an existing (usually empty) database.

Imports a SQL dump back into a database. The database must exist first. If restoring a gzip file, pipe through gunzip first.

When you need this: After a migration failure, during disaster recovery, or when moving to a new server.

Variables

Command


        

    







    2 views
    0 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install MariaDB server
                    
                                                                
                        MariaDB secure installation
                    
                                                                
                        Create MariaDB database, user, and grants
                    
                                                                
                        Backup MariaDB database to .sql file
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account — save snippets into your own collections.