copy all the MySQL database

hi,

Would it possible to transfer all the MySQL databases from one server MySQL server to another server?

Kailash

 

With PHPMyAdmin yeah it's really simple, just export the database from the old server then import it on the new server. If it's a larger database then you could use a mysql dump script.

 

Hello,
Do you have a large database?

 

I want to copy all the databases from exsting MySQL server to new MySQL server.

Kailash

 

Depending on the size of the database you should be able to use PHPMyAdmin, if the databases are of the larger variety then it might be worth using a mysql dump as I have suggested

 

I think he wants to do a "bunch of databases" all in one easy step.
Can the mysql dump script do this?

 

Not any of the free ones that I have used in the past, a premium script might do though...

 

backup whole database

mysqldump --all-databases | gzip >dbbackup.sql.gz

Code (markup):

then just wget it to your new server. and import..

 

Thanks MartynD,

I will try it.

Kailash

 

for UTF-8 tables:
mysqldump your_db_name --opt --host=localhost -u db_username -p --default-character-set=utf8 > dumpfile.dump