#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    45
    Rep Power
    14
    Is this possible and how is it done? I'm changing servers and I want to keep the database that I already have created. Thanks in advance.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Aalborg, Denmark
    Posts
    9
    Rep Power
    0
    How about making dumps of the databases (using phpMyAdmin e.g.) ?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    32
    Rep Power
    14
    mysqldump --opt database > backup-file.sql
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    45
    Rep Power
    14
    Thanks for the ideas but I'm kinda looking for a way to do it on the MySQL command line. If that's not possible could you explain more about teh phpMyAdmin thing that you mentioned? Thanks for your qucik responses and help.
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    32
    Rep Power
    14
    mysqldump is command line
    (a separate program that's installed when you install mysql mind you)

    so instead of starting up mysql
    mysqldump -u username -p databasename >backup.sql
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    45
    Rep Power
    14
    That's exactly what I needed. Thanks a lot.
  12. #7
  13. No Profile Picture
    RyanP
    Guest
    Devshed Newbie (0 - 499 posts)
    If you have root access, I think that you can just move the database directory in mysql's data directory from one system to another. I tried this awhile ago and it seemed to work ok.
  14. #8
  15. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    That *usually* works. However, if there is any version difference between the mysql servers involved you might run into a problem.

Similar Threads

  1. Replies: 5
    Last Post: January 28th, 2004, 08:46 AM
  2. Replies: 0
    Last Post: November 26th, 2003, 04:49 PM
  3. mysql server on different machine than hosting
    By metro in forum MySQL Help
    Replies: 6
    Last Post: February 18th, 2003, 11:34 PM
  4. Changing password for MySQL server
    By vtaylor in forum MySQL Help
    Replies: 1
    Last Post: November 12th, 2001, 06:30 PM
  5. Remote connection to MySQL server using DBI
    By Benahimvp in forum MySQL Help
    Replies: 0
    Last Post: August 11th, 2001, 11:55 PM

IMN logo majestic logo threadwatch logo seochat tools logo