Moving with phpMyAdmin...

[sammy182]

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.

[BC]

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