Site Fuse! programming, design, hosting, promotion and advertising tips for webmasters

Backup your database using ssh

Home  \  Forums  \  Programming & Development Forums  \  MySQL & Databases Forums  \  Backup your database using ssh
Share   

user photo

MrPhear   1 years, 7 months ago

Login through ssh or telnet to your server and type;

mysqldump -u username -ppassword --opt databasename > /usr/local/path/to/database.sql


username: your MySQL username
password: your MySQL password
databasename: name of the database you want to backup
path: path to directory where you want your backup file created
user photo

SF   1 years, 7 months ago

After I backed up my database it shows "0" for the size of it. Any Suggestion?
user photo

MrPhear   1 years, 7 months ago

Could be your HDD full?
user photo
Guest