Here's commands for Telnet or Local backup and restores, you must use a user that has the proper permissions of course.
Backup:
/Path to Mysql/mysqldump -uusername -ppassword database_name > /path to/blablabla.sql
Restore:
/Path to Mysql/mysql -uusername -ppassword database_name < /path to/blablabla.sql
Be sure to use the Less Than (<) symbol...
Thats all there is to it ...
Peace...
|