Tag Archives: mysqldump

Advanced SSH usage on Godaddy Shared Hosting (mysql, mysqldump)

I have read in many places that using mysql command line tools over SSH with Godaddy shared hosting is impossible. As of December, 2011, that is incorrect. Below are a few examples of VERY helpful functions that can be done on a Godaddy shared hosting account with SSH access (I use Putty & WinSCP for Windows).

To access the mysql command line tool:

mysql -h DatabaseHost –user=DBName –password=DBPassword

example:
mysql -h mydatabase.db.4738635.hostedresource.com –user=mydatabase –password=yourpassword

Once connected, you will have a new prompt “>”
Type “show databases;” to show all databases. Which there should only be two.
Type “use mydatabase;” to select the database to use.
Type “show tables;” to show all the tables in the selected database

From here, the posibilities are endless. Just read up on how to use the mysql command line tool.

Continue reading Advanced SSH usage on Godaddy Shared Hosting (mysql, mysqldump)