Trasfering mysql database (20 MB size)

[rrts]

Hi,

I am trying to move my database from cpanel to DA server.

I read the threads here. Most of them said to export in phpmyadmin on cpanel server. What options I need to check in phpmyadmin during exporting, if I want every piece of data need to be moved?

thanks.

 

[sky]

Hello
You can use a simple method by saving you database in a file, then, you upload it with ftp to your new server.

When that is done, connect with ssh under root and import the data into MySQL direct.

Help on this page for the ssh commands : http://support.netfirms.com/article.php?id=691

Sky

 

[rrts]

Sky,

I am not familiar with SSH command much.

But I will try those command with a test database first before trying with a 20 MB database.

Thank you.

Any other suggestions please?

 

[floyd]

If you have ssh access on the cpanel server then using ssh is a lot easier than using phpmyadmin. phpmyadmin may time out on a 20 MB database depending on the php settings.

Mysql Backup
mysqldump -q -uusername -ppassword databasename > backup.sql

Mysql Import
mysql –uusername –ppassword databasename < backup.sql

You have to create the database first before you can import it.

 

[agnivo007]

20MB isn't much that you can't import/export using phpmyadmin. I've seen people with GB's of SQL size using the ssh sql dump/restore.