In MySQL, what are the practices to backup databases?

Question

I am using mysql

How often do you back up your database?

How do you normally backup your database?

Export all data into sql or cvs format and keep it in a folder??

Answer 1

How Often - Depends on the activity and traffic you have on your Database.

I use phpMyAdmin and then click on the export tab and export the database as .sql

you can reach phpmyadmin by either localhost/phpmyadmin if you are running xampp/wamp/lamp etc or you can click on the 'phpmyadmin' link in your webhost's cPanel if you are hosting your webstie online.

Answer 2

I backup databases daily, using 'mysqldump [options] db_name [tables]', and export all data into sql. Of course, this depend on the size of your databases.

Answer 3

I use mysqldump:

mysqldump -uroot -p database_name > ~/backups/database_name-$(date +%s).sql

Answer 4

1.If you want the easiest way to back-up the database then you can opt for phpMyadmin.

2.If you prefer command line then follow this way.

You would simply modify the path and filename to reflect the specifics of your new backup file, like so: C:\ mysql -uroot -p [DatabaseName] < C:/backups/[backUpDatabaseName.sql]

3.Mysql dump. C:\ mysqldump [myDatabaseName] > [ExportDatabaseName]

Answer 5

Setting up a cronjob to run a script that does a mysqldump and stores the dump on a separate disk from the database itself (or a remote server) is a quite easy and efficient way to backup a database in my opinion. You could even have it dump every database with the --all-databases switch

If you have more than one MySQL server, you could also use replication

Frequency of backups depends on how much data you are willing to lose in case of a failure.

Answer 6

You can also look hotbackup