SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Moving a mySQL database??
-
May 26, 2001, 20:40 #1
Moving a mySQL database??
Ok here is the deal. I have a site and most of the content is called in with PHP scripts and I have everything stored in mySQL. I'm going to switch to a different host soon... does this mean I will have to write my database all over again from scratch?? Or can I transfer it some how?
Thanks!
-
May 27, 2001, 00:46 #2
- Join Date
- Apr 2000
- Posts
- 1,483
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
If you have telnet access to both hosts, log into telnet and type this on the old host:
Code:mysqldump -uyourusername -p yourdatabase > /path/to/file.sql
Code:mysql -uyourusername -p yourdatabase < /path/to/file.sql
-
May 27, 2001, 03:50 #3
No need to log into both hosts..
just FTP into your new host from the Telnet window of the old one, then just send the file that way
very quick, using their connectionDCE
If everything seems to be going well, you have obviously overlooked
something.
-
May 27, 2001, 06:05 #4
YES!
I'm glad it will be an easy move!
Thanks for your help.
Bookmarks