backing up MySQL via shell

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KyleC
    Senior Member
    • Mar 2004
    • 291

    backing up MySQL via shell

    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.
    -Kyle

Working...