how to upload sql database?

[nirtober]

i've downloaded a backup of my website sql database.
now i want to upload it back to bluehost, but i can't find anything in admin tools to upload an sql database.

[bobdog]

Control panel > phpMyAdmin > select database > import

[nirtober]

keeps timing-out. is there another way??

[Havx]

It sounds you may have to upload the sql file to your account and import it via the command line.

Bluehost has instructions in their knowledge base about how to do this: http://helpdesk.bluehost.com/kb/inde...od_id=2&id=184

[bobdog]

keeps timing-out. is there another way??

Seen that one before. Try importing a few tables at a time.

[April]

Hmm, I followed the instructions...how long should it take to import a 200meg database? It looks like my screen has hanged but maybe it takes more than ten minutes (??)

[felgall]

For 200M you should expect it to take a lot longer than 10 minutes.

[April]

Okay, thanks for the info. I shall be more patient.

Just to be clear, it's not via php: I've uploaded and unzipped the SQL database to a directory on the server, and I've used the SQL command in the helpfile linked above.

[felgall]

I have seen it take several minutes to run all the commands in an SQL file that is under 1M in size.

[April]

Right then, I'll stick the kettle on...!