mySQL Database copy?

[Conor]

Hey guys, long time no post

Anyways, I have 2 different websites on 2 different servers. I want to copy a mySQL database and all its info from one server and import it onto the other server..how can I do this? I'm guessing it's through phpMyAdmin but I don't know where to go/which files to upload.

Thanks in advance,

Conor

[Synkc]

You could export/backup the database structure to a file via either phpMyAdmin or an external MySQl GUI Client, such as SQLyog.

In phpMyAdmin, after connecting to your database, click the 'Export' link. From here you may select the desired database tables to backup/remove, the type of file to be exported (commonly you would use a .sql file) and what information will be included in the backup, such as 'drop if exists' queries.

[Conor]

SO say there's a CMS that is installed with that database, will I get that CMS? That's the reason I need to copy it pretty much.

[Slothie]

You probably will, unless they store paths and all in the database, in which case you may need to modify them manually.