I normally use MySQL Administrator to backup my database. I want to enable all the backup options for the available backup types in MySQL. I noticed that Binary Logging is not running on my PC. How to enable it? I also want to know what all parameters to include in a command-line mysqldump command to take a perfect guaranteed backup.
How to Enable All Backup Options in MySQL – Comprehensive Guide
backupMySQLmysqldump
Related Question
- Options to Include with mysqldump for Hybrid Databases Backup
- Purpose of MySQL Command-Line Options -ANe
- MySQL backup of incremental changesets
- Mysql – How to take a full backup from MySQL without any System tables
- Mysql – thesqldump to a hostname which is proxy/router (not MySQL server)
- MySQL Workbench –enable-cleartext-plugin – Why MySQL Workbench Adds –enable-cleartext-plugin on mysqldump
Best Answer
Add the following to my.ini
Then, restart mysql
As for mysqldump, most of the options you need are defaulted already in --opt. Here are my choice parameters:
Here is an explanation for my choices (including default --opt)
You will need --master-data if you want to setup the dump to prepare replication slaves. The master log and position at the time of the dump will be recorded as a comment (using --master-data=2) or as a command (using --master-data=1) on line 22 of the dump file.
UPDATE 2011-07-26 15:20 EDT
If you would like to dump separate databases and separate tables, please follow the instructions at this URL.