Command Line - Help

[tank]

As a new user here at Jaguar I'm working on transfering my existing database over. The problem is that my sql export files are too big for phpmyadmin to import. I get a 300 second timeout. So my next step is to learn to shell into the server and import the files that way (which is something I wanted to learn anyway).

The problem is that I have no idea where to start. I've read through the mysql documentation on command line instructions and it is kind of clear. But I don't even know how to shell into the server or where to put my .sql files. If someone could give me some examples or a website to research I'd really appreciate it.

[Connie]

Can't answer your questions about SQL, but you will need to open a ticket to support to have shell access enabled for your account.

[jason]

Open a support ticket and ask to have SSH enable, as Connie suggested. Then go and download an SSH client (PuTTY seems to be the most popular here) and use that to log in (Host Name= your doamin name, Protocol=SSH). When prompted user your CP usename and password. Once you get in you'll get a command prmpt. You can then use the command line tools described in the MySQL docs that you mentioned.

You'll want to upload your MySQL dump file to your site with FTP before trying any of the command line stuff, BTW.

To download PuTTY, go to http://www.chiark.greenend.org.uk/~sgtatham/putty/

You may also want to check out WinSCP. SCP stands for Secure CoPy and works a lot like FTP but is done over SSH so that everything transferred is encrypted for security. To get WinSCP go to http://winscp.sourceforge.net/eng/

Good luck.

--Jason

[tank]

Thank you both very much. The Ticket is open and it is all coming together and making sense.

[JPC-Masood]

Here is how you can import your database via ssh.

First you will have to create the database and user credentials from the control panel.

1. Login to your control panel at

http://yourdomain/cpanel
or
http://yourserverip/cpanel

(replace yourdomain with your actual domain if it is already pointing to the server, or use your server IP in the above URL)

2. Once logged in, click on "MySQL Databases" under Manage Site.

On the next screen, you have to

i. Create MySQL database (we'll call it MYSQLDB)
ii. Create MySQL user (we'll call it MYSQLUSER)
iii. Grant permissions on a MySQL database to a MySQL user

Once that is done, you have the database, mysql db user and its password.

3. Once logged into the server via SSH, issue this command to import the sql dump:

mysql -uMYSQLUSER -p MYSQLDB < mysqldump.sql

It will ask for the password that was setup in 2-ii step above. "mysqldump.sql" is the dump from your old place that you must have uploaded via ftp.

Any problems, you can open a support ticket.

[tank]

Thanks again! Once I figured out that the sql file needed to be in the actual root it worked like a champ.