setting up database backup

Discussion in 'Programming/Scripts' started by cruz, Oct 29, 2007.

  1. cruz

    cruz New Member

    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
     
  2. cruz

    cruz New Member

    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?
     
  3. falko

    falko Super Moderator ISPConfig Developer

    The tutorial works for Debian Etch as well.
     
  4. cruz

    cruz New Member

    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.
     
    Last edited: Oct 30, 2007
  5. falko

    falko Super Moderator ISPConfig Developer

    Yes.

    Yes.
    How do you mean that?
     
  6. cruz

    cruz New Member

    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
     
  7. falko

    falko Super Moderator ISPConfig Developer

    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
     
  8. cruz

    cruz New Member

    Thanks once again. It is working great and I will follow your instructions.
     

Share This Page