Shell access - uploading mysql databases


#1

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. :slight_smile:
Sam


#2

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

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

[color=#00CC00]Users > Manage Users[/color]

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#3

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


#4

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


#5

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


#6

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