Shell access - uploading mysql databases

Hello

I have a MySQL database that is like 8.5~ MB and I want to upload to phpmyadmin. The limit is like 7.6MB though. How can I do this?

I read I need shell access... but how do I get it?

Please help, urgently. :)
Sam

Is the database file compressed? If not, compress it first.

You can set your user to have shell access from within Panel.

Users > Manage Users




How To Install PHP.INI / ionCube on DreamHost

An easy way is to split it in two or more parts using a texteditor, and then upload each part using phpmyadmin.

I did this, with the textpad.

It now uploading but I get this annoying MySQL error... why would it do this?

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES('1','1','1247489999','Changed member\'s display name \'Admin\' to \'Sco' at line 1

Sounds like you split the file in the middle of a statement. The MySQL server gets annoyed when that happe

ns. (Unless you want to mess with the SQL at a pretty low level, you should only split the file after semicolons.)