Database Transfer

I want to transfer a 27mb sql file from one phpBB to another phpBB forum.

I was wondering how long would it take to import the database fully.

Also, are there any faster ways of importing the database because I can't wait much longer.

Thank you for your help.

 

Export:
mysqldump -u DBUSER -p DBNAME > DBNAME.sql

Import:
mysql -p -h DBUSER DBNAME < dbname.sql

27 m is pretty small, so shouldn't take long at all

 

How would I run these commands and when I do run these commands where do I upload the sql file?

 

The commands given by Agent_dweeb will probably require shell access to your account.

If you donot have shell access, you can export the database using phpmyadmin.
Unzip and upload it to your website. Download a small script "bigdump" and upload it also to your server. Use this script to import it.

 

Well, you would need shell access for those commands.
If not, then phpmyadmin will do