Thread: database backup

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

    Join Date
    Jul 2000
    Posts
    1
    Rep Power
    0
    i have a database that i want to transfer to a new server. How do i do this please help
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Use mysqldump. You will need to read about the options in the documentation, but basically, you can run mysqldump and pipe the output to a text file, which you can use as the complete set of SQL queries and inserts to create the database at the other end.

    # mysqldump -u username -h hostname -p databasename > mydatabase.txt

Similar Threads

  1. Database backup
    By dsm56 in forum PHP Development
    Replies: 1
    Last Post: December 10th, 2002, 04:17 PM
  2. Replies: 1
    Last Post: September 23rd, 2001, 05:12 PM
  3. phpMyAdmin backup corrupting database contents
    By mano1 in forum MySQL Help
    Replies: 5
    Last Post: September 17th, 2001, 04:26 PM
  4. Database backup
    By micklloyd in forum MySQL Help
    Replies: 4
    Last Post: June 13th, 2001, 06:09 AM
  5. Backup of Database ?
    By Gerhard in forum MySQL Help
    Replies: 7
    Last Post: February 10th, 2001, 06:38 AM

IMN logo majestic logo threadwatch logo seochat tools logo