1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Rep Power
    Please could someone let me know how I can backup a complete MySQL database, and restore it afterwards. We are running on Linux. Thanks...

    Check out Nottingham's Only Alternative at http://urn.nott.ac.uk
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Rep Power

    i think you should use the mysqldump program for a full backup of your database:

    shell> mysqldump --tab=/path/to/some/dir --opt --full

    see the mysql-manual for the database back up details.

    SR -

Similar Threads

  1. Importing, exporting and backing up database
    By mousa in forum MySQL Help
    Replies: 1
    Last Post: January 10th, 2004, 08:19 PM
  2. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 05:27 PM
  3. problems backing up database
    By lnong in forum MySQL Help
    Replies: 1
    Last Post: July 17th, 2003, 08:41 PM
  4. Can't select database
    By rfigley in forum MySQL Help
    Replies: 9
    Last Post: December 17th, 2002, 10:05 AM
  5. Benefit to XML vs. database?
    By CyberN8 in forum PHP Development
    Replies: 4
    Last Post: August 1st, 2001, 01:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo