Backup MariaDB database to .sql file

Dump a single database to a timestamped .sql file. Use --single-transaction for InnoDB consistency.

Dumps a single database to a .sql file using mysqldump. Combine with gzip for compression. Schedule via cron for automated daily backups.

When you need this: Before any major migration, upgrade, or on a regular automated schedule.

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
                    
                                                                
                        Restore MariaDB database from .sql file
                    
                                    

    





        

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