mySQL Database copy?

Conor

New Member
Messages
3,570
Reaction score
0
Points
0
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

Active Member
Messages
1,765
Reaction score
0
Points
36
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

New Member
Messages
3,570
Reaction score
0
Points
0
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

New Member
Messages
1,429
Reaction score
0
Points
0
You probably will, unless they store paths and all in the database, in which case you may need to modify them manually.
 
Top