uploading a db file that is 400,000kb - can someone help?

[[R]DeVore]

Hello,

phpmyadmin in cpanel only allows you to upload a 50,000kb file. mine is 400,000+kb. anyone know how to get this uploaded?

Thanks

 

[joe]

split it up, and then upload each chunk.

 

[[R]DeVore]

would it matter where i split them at, or what i named the files?

 

[bluebobbo]

Not really, just make sure you're not cutting off any query lines.

 

[[R]DeVore]

ok. thanks

 

[xspark]

try this - when I have trouble importing a huge db, bigdump usually solves it!
BigDump

 

[Someone]

If you have shell access, do this:

1. Upload file through FTP
2. Login to shell
3. Run: mysql -u DB_USERNAME -p DB_NAME < FILENAME_UPLOADED

Replace the DB_USERNAME, DB_NAME, and FILENAME_UPLOADED with the correct values.

You'll be prompted for the database user's password. It'll take a long time to import a 400 mb file. This is, however, the fastest way to do it.

Alternatively, if you don't have shell access, you could still upload the file and create a PHP script that exec()'s the command above.

 

[illusion]

I just do what joe does, just cut it up and input it in the query line, works a charm for me. Just make sure you don't cut it up through the creation of tables

 

[wickedDUDE]

big dump...lol