[dmpinder]

Hey everyone,

I'm hoping someone can help me with this problem I have.

I've been asked by a client to move a MySQL database from one server to another (different provider). I know very little PHP, and have barely used PHPmyadmin before.

Can you give me some guidance? I've Googled as usual but everything seems to be very technical MySQL command line stuff, which means very little to me. I'm a quick study, so I just need to be pointed in the right direction.

Many thanks

Darren

[ElanMan]

If both servers are using phpMyAdmin, export the database as a .sql file leaving the default settings. Tick the checkbox 'save as file'. This will save it to your computer.
Go to the new server/phpMyAdmin and create a database with the same name as the original. Import the .sql file from your computer. The import and export links are at the top of the page in phpMyAdmin.
Any probs, give us a shout

[Faevilangel]

as elan said its easy as using export / import from phpmyadmin

if the servers don't have that then you could install phpminiadmin

[dmpinder]

ElanMan,

You're a life saver, that sounds so simple.

I'm assuming that when I FTP all the public HTML files from the old server and onto the new server, once I have the database in place (same name, as you point out), it should just instantly work like it did on the previous server? Is there any messing around with config files to make sure the PHP files link to the database properly?

Darren

[ElanMan]

Just make sure your connection script uses the same details i.e.

DEFINE ('DB_USER', 'username'); 
DEFINE ('DB_PASSWORD', 'password'); 
DEFINE ('DB_HOST', 'localhost'); 
DEFINE ('DB_NAME', 'database');

and you should be fine.