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

    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

    Cheers

    Andy

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    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:

    Code:
    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 http://www.dbforums.com/t1199569.html

    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
  •