# Remove leading # to turn on a very important data integrity option: logging
To enable the binary logs, edit the "/etc/my.cnf" file, uncommenting the "log_bin" entry. Unless you have a read-only system, it is likely you will need to enable the binary logs. The binary logs allow you to wind forward from that point by applying all the changes that were written to the binary logs. Without the binary logs, you can only recover the database to the point in time of a specific backup. # service mysqld start Binary Logs : Point In Time Recovery (PITR)īinary logs record all changes to the databases, which are important if you need to do a Point In Time Recovery (PITR). To recover the database from a cold backup, stop MySQL, restore the backup files and start MySQL again. # service mysqld start Recovery from Cold Backup
#Mysql backup database zip#
You can use whichever method you want to copy the files (cp, scp, tar, zip etc.). The basic process of a cold backup involves stopping MySQL, copying the files, the restarting MySQL. Cold BackupsĬold backups are a type of physical backup as you copy the database files while the database is offline.
#Mysql backup database full#
The full syntax of the MySQL command line tool can be found here. $ mysql -user=root -password=mypassword -database=mydatabase < mydatabase_backup.sql $ mysql -user=root -password=mypassword < all_backup.sql The logical backup created using the mysqldump command can be applied to the database using the MySQL command line tool, as shown below. The full syntax of the command can be found here. $ mysqldump -user=root -password=mypassword mydatabase mytable1 mytable2 mytable3 > mydatabase_mytables_backup.sql $ mysqldump -user=root -password=mypassword mydatabase mytable > mydatabase_mytable_backup.sql $ mysqldump -user=root -password=mypassword mydatabase -force > mydatabase_backup.sql $ # Individual DB (or comma separated list for multiple DBs) $ mysqldump -user=root -password=mypassword -all-databases -force > all_backup.sql Logical Backups Logical Backup (mysqldump)Īmongst other things, the mysqldump command allows you to do logical backups of your database by producing the SQL statements necessary to rebuild all the schema objects. Binary Logs : Point In Time Recovery (PITR).The article only describes those methods available without needing additional licensing. This article provides a quick guide to performing backup and recovery of MySQL databases. Home » Articles » Mysql » Here MySQL : Backup and Recovery
0 kommentar(er)
