Results 1 to 9 of 9
  1. #1

    Tips on moving mySQL database from old host to new host?

    Tips on moving mySQL database from old host to new host?

  2. #2
    Join Date
    May 2001
    Posts
    1,593
    You can use phpmyadmin to export the datebase and then re-import it back at the new host.

    Or if you have command line access, you can use mysql commands to export SQL statements that describe your database, transfer the file to the new server, then re-execute those statements to import your database.

    Peter

  3. #3
    Join Date
    Jul 2002
    Posts
    3,729
    If it is a large database (bigger than a couple megabytes) you'll probably have to do it via the command line. If your host doesn't offer shell access, ask them to do a dump of it for you.

  4. #4
    Join Date
    Mar 2002
    Location
    San Jose, CA
    Posts
    34
    ranchoweb.com
    reliable linux hosting with all the trimmings
    http://www.ranchoweb.com/webhost/

  5. #5
    Join Date
    Sep 2002
    Posts
    77
    Dump and restore --- Its fairly simple from the command line or using phpMyAdmin as suggested above.
    Fuel Guru
    High Octane Web Hosting!
    http://www.fuelhosting.com

  6. #6
    Join Date
    Apr 2002
    Location
    Hasselt, BE
    Posts
    45
    Or, if you have access to the server by using a program like MySQLFront you can 'download' the dump to your local system first and upload it thereafter.
    iworx - creative multivolution
    www.iworx.be

  7. #7
    Pen and paper.


  8. #8
    Join Date
    Sep 2002
    Location
    Berkeley, CA
    Posts
    6
    well...you could always dd over the partitions over ssh and clone the box = P

  9. #9
    Join Date
    May 2001
    Posts
    1,593
    Guys, let's not fantasize too much.

    Peter

Posting Permissions

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