SSH Help

[combs84]

OK. I spent all day yesturday trying to figure out how to use this SHH thing. I downloaded a program called WinSCp3. If there is a better free one to download that you could explain to me easier..please link me and I will use it.

I made a database for where I want to export the DB. I uploaded the database to the server, although will have to upload a new one now with new posts on the forum.

I then ran a command with this:
myShell:~ > mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
Enter password:
mysql>

And it didn't work.

Is there a specific place i have to upload the file to? just the normal directory fine? What am i Doing wrong.

If somebody can help me, i'd really appreciate it. If it'd be easier to just do it..i'd be willing to pay somebody $10 to do it for me. AIM me today at Iamsuchasucker84 and I can give you info you'd need to do it. Thanks!

 

[Dan]

If you are trying to import the SQL:
If you have phpMyAdmin, click on SQL and you can upload the file.

If you are trying to export it:
Open phpMyAdmin and click export. You can choose what kind of file to save it as or just get the text.

 

[combs84]

It is a mysql my file is 112MB. The most it will allow me to upload with phpmyadmin says like 2000kb. When I called my host they said I had to use SSH because it was to big, unless there is a way around it?

 

[Kate]

I then ran a command with this:
myShell:~ > mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
Enter password:
mysql>

Actually you need to remove the space after -u and -p. It may sound odd but the parameters and values must stick together like this:
mysql -hdbxx.perfora.net -udboxxxxxxxx -pdbxxxxxxxx < dump_file.sql

For the host (-h) parameter I am not sure.

FYI there is an alternate syntax for passing user & password in command line:

mysql --user=user_name --password=your_password db_name

 

[combs84]

OK I finally at least got it to connect. It ran a whole bunch of information.

Shouldn't it have uploaded the file to the databases? I guess not?

What other commands would I enter to do it.