Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: Backup MYSQL Database remotely

    I have a couple of MySQL Databases that store forum data on a number of servers.....and recently had an issue where the serve crashed and i lost a load of data...i want to prevent this from happening in the future and limit the amount of data lost.......

    is there a way to backup or mirror the data in my mysql dtabases to a copy which i plan to store locally on my PC, purely for backup purposes?

    so at a periodic time the software would copy all the MySql database structures and Data to my PC's Database

    If so what is it and do you have any links please



  2. #2
    Join Date
    Apr 2005
    Baltimore, MD
    Dump the database(s) you want to backup. Then connect to the MySQL server on the destination machine and import it by using something like:

    shell> mysql -e "source /path-to-backup/backup-file.sql" db_name --host=myhost --user=myname --password=mypass
    I believe that should work. Check out

    As far as getting it to operate periodically, you should write a script to do so.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts