How to import mysql's files into the online database?

[seanwu]

I have a large mysql file(MYD) about 1G .
How can I import it into my website's database?

:confused: :confused:

[Seb]

Seeing as it is 1 Gig you should use SSL to import it. Doing it through phpmyadmin will give you timeouts unless you break it into small pieces, you need to know what you're doing though if you're about to crop the .sql file.

You can search google for a tutorial on importing a database using SSL. And by the way, hostmonster needs to enable SSL for your account. You can read more about it in Hostmonster Knowledge Base over at www.hostmonster.com.

[McCoy]

Well, he is talking about a MYD file (mysql's binary format) so he won't be able to do it directly.

One option is to install a mysql server in your computer, copy the myd file to the appropiate directory, and dumpt the database to a (compressed) SQL text file. Then use that generated SQL file to put that data into hostmonster's mysql server via SSH.

You can't import MYD files directly into the server because you don't have access to the mysql directory where the binary files are stored.

[Seb]

Didn't see.

Anyways, I always learn something new from your posts McCoy! :)