Dynadot Aftermarket: discover domain gems worth investing in. Visit our aftermarket.

SSH Help

Namecheap AuctionsNamecheap Auctions
NamecheapNamecheap
Namecheap AuctionsNamecheap Auctions
Watch

combs84

Established Member
Impact
23
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!
 
0
Close
The views expressed on this page by users and staff are their own, not those of NamePros.
GoDaddyGoDaddy
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.
 
0
Close
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?
 
0
Close
combs84 said:
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
 
0
Close
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.
 
0
Close
Appraise.net

We're social

Escrow.com
Spaceship
Domain Recover
CryptoExchange.com

NamePros updates

A browser tab with a favicon next to the page title
Search members
You can now search for members by name, company, location and more. Open the search at the top of any page and choose Members. You will...
AIVikings
Catchy
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back