Database import in Cpanel 11?

Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how should I act with my ready databases if I have Cpanel 11 installed? I don't wish to rewrite them again and just would like to move them from local host to hosting! Thanks a lot in advance!

 

http://www.siteground.com/tutorials/php-mysql10/mysql_export.htm

 

You can import your database from PHPMyAdmin.

Kailash

 

Is it possible if my Cpanel is provided with PHPMyAdmin 2.11.6 version? I have tried once but my attempt has failed!

 

Yes, you should be able to import your database. But it also depends on the database size. If it is higher then maximum limit provided in PHPMyAdmin then you will need to provide the dump of your database to hosting provider.Or if you have shell access then you can restore your MySQL database from SSH.

Kailash

 

If it's too big for PMA, either use BigDump or SSH (mysql -u <database_user> -p<database_password> <database_name> < <database_backup_filename>