Please help me for import MySQL database

[ninewee]

Dear support team,

I am a new customer bluehost. I would like to tranfer my site to bluehost but I have a problem with MySQL database. My database is a large size (155.87MB). Can you help me to import. and Now I will try to upload my database to blue host by FTP. If you can help me I will send any information about may account to your team.
Thank you.

[siguie]

This isn't the BH Support Team and 155Mb is not that big. It would be helpful to know what application you use with the database ... some applications like phpBB2 have built in upload scripts. Otherwise you could use phpMyAdmin or my preferred shell command line method.

You may also want to just go to the Blue Host Help Center (http://www.bluehost.com/help_center.html) or just call ...



Questions

BlueHost specializes in customer
satisfaction - Call us with your
questions Toll Free 24/7!

(888) 401-HOST
(888) 401-4678

[rylord]

I would split up the .sql file. Dump and create the tables in one .sql

Then insert all the data into the tables by splitting up the data into smaller .sql files.

I've had problems with large .sql files and I believe there is a limit to the import size of the .sql file according to phpmyadmin. It states the maximum import size of the .sql file is 50mb

[adddfico]

phpMyAdmin states that it won't import databases larger than 50MB. I'm not sure about you, but with that limit I couldn't import a single database with it :)

My preferred method is command-line through SSH as it has no limit on size (it does follow the 'script time limit' rule, though so no 4GB databases :P
Just type this in:

mysql -uUsername -pPassword database < /path/to/db_backup.sql

I've found that through the shell you are able to use your unix username and password on your account (It has admin rights to all databases. It's how phpMyAdmin accesses them). You could also use the user/pass that you have assigned to your database if you want, as well.