huge PHP Newb ( prolly stupid question )

BenG1

I am currently wondering how to transfer a SQL Database to another server. Right now I have a database on ( we will call it ) Server "A". This week I am transfering servers, Server "B". I want to be able to transfer mySQL DB over to the new server. Do I do this in the phpMyAdmin. Or is there a script that I can use to upload to my new server and just have everything transfered over?

Told you it was probably a huge newbie question!

tomhath

It's generally done by backing up the old database and restoring into the new one.

Backing up and archiving are something you should do on a regular basis anyway (and occasionally restoring into an offline database to be sure your recovery process works).

http://dev.mysql.com/doc/mysql/en/Backup.html

nemonoman

if you have shell access, life is easy:

use mysqldump to download database A

(you'll probably want to use --opt options -- see mysqldump --help)

Then logging into the B server, log into mysql, use the B database and use the source command to load the dump into db B.

See mysql --help

You can also write php exec commands to do the above.

BenG1

GEEZE why didn't I think of that? That's so easy! :queasy: Ok no really. I have no idea what you guys are talking about with the sqldump and stuff.. I guess I should read the help files and stuff and learn what you guys are talking about.

I just thought that maybe there was some already made script by mySQl to do this easily!

Roger_Ramjet

It is easy, as tomhath says 'just do a backup and restore to the new location'. Of course, if you are moving a hosted db from one service provider to another they may be the problem. Basically though, your new provider should load the db for you. Just take a backup they can use and tell them to get on with it, that's part of what you pay for.

tomhath

You might have to ask your current hosting service to make a backup for you. They might have some administrative tool you can use, but often they prefer to do it themselves.