Results 1 to 4 of 4

Thread: MySQL Backup and Reanimation

  1. #1

    MySQL Backup and Reanimation

    Whats the best way to backup a MySQL database and whats the best way to recover the data onto a diffrent MySQL instalaltion?

  2. #2

    Re: MySQL Backup and Reanimation

    This fell down the list to fast. *bump*

  3. #3

    Re: MySQL Backup and Reanimation


    Whats the best way to backup a MySQL database and whats the best way to recover the data onto a diffrent MySQL instalaltion?
    Mysql has a dump feature, so you can dump all your databases or just specific ones to .sql files. You can then insert them into another database server, or your own later.

    Or, like I do, just tarup the /var/lib/mysql directory, so that you can just re-write it, and all your data is intact.

  4. #4
    hai,

    u can get back up method from this site

    http://www.debianhelp.co.uk/mysqlscript.htm

    it will back up to local and also will email your back up n log file.

Similar Threads

  1. Automatic MySQL Backup Script
    By peter in forum Tutorials
    Replies: 1
    Last Post: 09-22-2009, 09:13 AM
  2. mysql backup
    By svar in forum Linux - General Topics
    Replies: 2
    Last Post: 01-01-2009, 07:16 AM
  3. Automatic MySQL Backup Script
    By canela in forum Programming
    Replies: 2
    Last Post: 12-20-2006, 04:59 AM
  4. MySQl backup script
    By girlygeek in forum Programming
    Replies: 5
    Last Post: 11-11-2006, 11:23 PM
  5. mysql backup
    By elovkoff in forum Linux - Hardware, Networking & Security
    Replies: 28
    Last Post: 08-13-2004, 02:15 PM

Bookmarks

Posting Permissions

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