|
if you can run PHP and I'm pretty sure you can install phpMyAdmin.... once setup, just select the database you want, select all tables in the database and select table structure and data and you can download it to your comp as a .sql file.
that's the easiest way....
Backing up mySQL from the command line:
Log into telnet. Then move to the directory where you want the backup to be. then type:
mysqldump -u mysqlusername -p mysqldatabase > dumpfile.sql;
(Note: the ";" at the end is important to have it recognised as a mysql command)
Then you'll be asked for your mysql password. Just enter it without any ";" at the end.
Then ftp in and go to the dir. Download the .sql file and there you go.
Restoring the data to the database (same or different) is easy. Just log in into telnet again, change to the appropriate directory where you have your .sql stored and enter following:
mysqldump -u mysqlusername -p mysqldatabase < dumpfile.sql;
Then you'll be asked again for your password.
I don't really know if this works on your box....
Contact me if you have problems!
|