SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
Thread: Moving with phpMyAdmin...
-
Jan 21, 2001, 16:51 #1
- Join Date
- Oct 2000
- Posts
- 146
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Hello,
I am moving off my temp free server to a paid one. I am using phpMyAdmin with both and I was wondering what was the easiest way to move the SQL database to the new host.
thanks.
-
Jan 21, 2001, 17:14 #2
- Join Date
- Jul 2000
- Location
- 80,000 feet below the surface
- Posts
- 1,442
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I'll have an article on WebmasterBase.com out soon about moving and backing up your databases fairly shortly.
In the meantime, the ideal situation is : if you have Telnet/SSH access, access your server then do a 'mysqldump' e.g. :
mysqldump --opt –full your_database_name > thisismybackupfile.sql
then once you get on to the new host, use phpMyAdmin to create a new DB and upload the 'text file' (your .sql file) to re-populate the database.
If you don't have Telnet/SSH access and want to use phpMyAdmin, then follow these instructions from PHPWizard.net : http://www.phpwizard.net/phorum/read...&i=1157&t=1157
Bookmarks