Results 1 to 9 of 9
-
09-22-2002, 05:23 PM #1Newbie
- Join Date
- Aug 2002
- Posts
- 22
Tips on moving mySQL database from old host to new host?
Tips on moving mySQL database from old host to new host?
-
09-22-2002, 06:34 PM #2Web Hosting Master
- 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
-
09-22-2002, 06:42 PM #3Web Hosting Master
- Join Date
- Jul 2002
- Posts
- 3,734
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.
-
09-23-2002, 01:58 AM #4Junior Guru Wannabe
- Join Date
- Mar 2002
- Location
- San Jose, CA
- Posts
- 34
ranchoweb.com
reliable linux hosting with all the trimmings
http://www.ranchoweb.com/webhost/
-
09-23-2002, 02:01 AM #5Junior Guru Wannabe
- 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
-
09-23-2002, 09:11 AM #6Junior Guru Wannabe
- 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
-
09-23-2002, 11:37 PM #7WHT Addict
- Join Date
- Sep 2002
- Posts
- 136
Pen and paper.
-
09-24-2002, 01:54 AM #8Newbie
- Join Date
- Sep 2002
- Location
- Berkeley, CA
- Posts
- 6
well...you could always dd over the partitions over ssh and clone the box = P
-
09-24-2002, 01:58 AM #9Web Hosting Master
- Join Date
- May 2001
- Posts
- 1,593
Guys, let's not fantasize too much.
Peter