Need to Enable mysqldump

[Guest]

I made a support inquiry about enabling mysqldump. I was told we would need to be given shell access and then do it through shell.sonic.net. We were told that within a couple hours we could access that, but whenever I try to load it, nothing happens. The browser screen is blank.

Can you please provide more specific directions for achieving what we need?

Thanks

[cdkeen]

If you have shell access enabled on your account the steps you take are as follows:
1) Using a terminal client login to shell.sonic.net via ssh
# ssh [email protected]
2)Then once you are logged in run this command (substituting the user specific information HOSTNAME, USER, PWD)
# mysqldump -h YOUR_DB.db.sonic.net -u USER -p DATABASE > YOUR_SQL_DUMP.sql
Your SQL database information will be in the file that is newly created (YOUR_SQL_DUMP.sql)
If you have difficulty with this process please contact support for further assistance. Thanks for choosing Sonic.net!

[Guest]

Hello,

Thanks for the information, but I don't know how to do any of that stuff. I've never heard of a terminal client. I'm not terribly advanced with the server side of things and I don't understand why Sonic can't just enable this for us. I've never worked with a host that made clients jump through hoops like this before.

How do I get a terminal client? Can I use an FTP program for this?

[cdkeen]

Putty ( http://www.chiark.greenend.org.uk/~sgta ... nload.html ) is a popular freely available terminal client for windows. If you are using Mac OS there is a built in application named terminal that can be used. Once you follow the 2 steps I previously detailed you can use your ftp client to download the .sql file you have created to your computer.