Moving database to new server

[drifta]

could someone give me a quick tutorial on moving a sql database from one server to a new one?

both have cpanel and phpmyadmin
but i dont know anything about that!

 

[death001]

you should be able to go to phpmyadmin navigate to the database you want to move and click the export tab and click the ok button then it should* show an outputed sql code all you do is go to the database in phpmyadmin on your new server click sql paste the code in and click ok, this will add everything to the new database

*if its a rather large database you will proberly have to get your hosts to export and import it

 

[P10n33R]

Yeah, the new host will most likely move the database for you, a lot will. You can do it yourself if you would like following the steps above.

 

[Jim_]

I would use phpmyadmin to create an sql dump file, then import it into your new host's database. If its too big for phpmyadmin to import, give it to your host and they can import it.

 

[Flubber]

Ideally, make a fullbackup (Which includes the database, all files) via cpanel and then give it to your new host.

However, if its just a DB move, create a dump file as everybody has said above - and if its real big then your old host should be able to create one for you.

Flubb

 

[dongan]

1) Login to the existing server in SSH mode and use MySQLDump to take backup
2) Login to the new server in SSH mode
3) move the file from old to new
4) Restore the backup file using mysql restore command

For commands ...http://www.theprojects.org/tutorials/mysqldump.php

but, remember, you need root access for performing this ...

 

[drifta]

thanks all for the info
database has been moved now