I started to setup HTML: How To Back Up MySQL Databases Without Interrupting MySQL I got past the first part. HTML: How To Set Up Database Replication In MySQL Then I realised it would not work with the install I have. I have HTML: The Perfect Setup - Debian Etch (Debian 4.0) I was reading you were creating a totorial for mysql 5.0. can I get a link If in fact it is finished. Thank you
Will this work for the backup of my server. I have two servers setup on debian etch perfect setup right now. Will this also work for the databases as well?
Will it work with 5.0 mysql? I was thinking it was for an earlyer version of mysql. Also can I backup more than one database with this? If so, do I just enter then with a space between them in the howto? I have more than one site.
This entry here Like were it tells you to enter the database. HTML: binlog-do-db=exampledb Just add more than one? Like binlog-do-db=exampledb mikesdb franksdb. Also this, do I add each database to be backed up with a space between databases to backup? HTML: mysqldump -u root -p<password> --opt exampledb > exampledb.sql like mysqldump -u root -p<password> --opt exampledb franaksdb mikesdb > exampledb.sql franksdb.sql mikesdb.sql
No, you must use multiple binlog-do-db lines, like Code: binlog-do-db=exampledb binlog-do-db=mikesdb binlog-do-db=franksdb No, you must back up each database separately, like Code: mysqldump -u root -p<password> --opt exampledb > exampledb.sql mysqldump -u root -p<password> --opt mikesdb > mikesdb.sql mysqldump -u root -p<password> --opt franksdb > franksdb.sql
