Since you're not too familiar with shell, logon to your server via FTP, create a folder somewhere called backup, set the permission on that folder to 777
Use putty to login to your server, go to the new folder, use the command lines below, change all the variables to suit you.
Then, download mysqldump.zip and delete the mysqldump.sql
Use putty to login to your server, go to the new folder, use the command lines below, change all the variables to suit you.
Code:
mysqldump --opt -Q -h databa_seserver.com -u user_name -p'password' database_name > mysqldump.sql zip mysqldump.zip mysqldump.sql
Comment