Db is too big to upload


#1

Hello

I tried to contact the support about this issue, but for almost 20 h. I have not received any reply. So I decided to post here, any help would be highly appreciated.

I need to upload a db to my dreamhost database, but the problem is that the file is too big to upload via phpmyadmin.
Could you please help me to do that? The dump is situated in /dumps directory of my account. The name is traumausru_mi.dumps.10Sep13.tar.gz

I also tried to do that via ssh, but access is denied. Here is what I get at terminal:

iMac-Vladislav:mi vladislavmavrin$ ssh -l login ben-hill.dreamhost.com
login@ben-hill.dreamhost.com’s password:


| |__ ___ _ __ | |__ () | |
| ’
\ / _ \ '_ \ | ’ | | | |
| |_) | / | | |
| | | | | | |
|_.
/ __|| || || ||||_|

Welcome to ben-hill.dreamhost.com

Any malicious and/or unauthorized activity is strictly forbidden.
All activity may be logged by DreamHost Web Hosting.

Last login: Fri Sep 13 12:31:26 2013 from 84.77.72.234
[ben-hill]$ mysql -u mylogin -pmypassword -h mysql.mortal-instruments.ru mydb
ERROR 1045 (28000): Access denied for user 'mylogin’@‘ben-hill.dreamhost.com’ (using password: YES)

*data in italic is hidden for safety reasons

Could somebody help me to correct my ssh command? Or if there are people from support, could you please import the file to db.

Thanx


#2

Make sure you’re using the DB owner user:pass credentials, not your SSH user:pass

mysql -u [db_user] -p[db_pass] -h [db_host] [db_name] < [dumpfile.sql]


#3

Ok, thank you so much for the help!