Backing Up The Database via SSH/Telnet
In order to back up your database via SSH you will require 2 things:
1) SSH or Telnet access to your site.
2) An SSH/Telnet Client, such as PuTTy.
Open your SSH/Telnet client and log into your website. At the command line:
Type in the following:
mysqldump -u dbusername -p databasename > /path/to/backupname.sql
You will be prompted for the database password. Enter it and the database will backup.
You can then, if you wish, download the backup to your home computer via ftp.
In order to back up your database via SSH you will require 2 things:
1) SSH or Telnet access to your site.
2) An SSH/Telnet Client, such as PuTTy.
Open your SSH/Telnet client and log into your website. At the command line:
Type in the following:
mysqldump -u dbusername -p databasename > /path/to/backupname.sql
You will be prompted for the database password. Enter it and the database will backup.
You can then, if you wish, download the backup to your home computer via ftp.