Backup a mysql database via SSH

In order to backup your database via SSH or Telnet you will require 2 things:

1. SSH or Telnet access to your site. You will need to contact support to have SSH access enabled for your account.

2. An SSH/Telnet Client, such as PuTTy (can be downloaded from the downloads section).

Open your SSH/Telnet client and log into to the server using your username and password.

You will be in the main folder for your account.

You can change directories to wherever you want the backup to be located and type in the following:

MySQL -u dbusername -p databasename > backupname.sql

You will be prompted for the database password. Enter it and the database backup will be backed up. You can then download the file as required.

If you need any help, please contact support.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Are my databases backed up?

Yes, all databases are backed up on a weekly basis. However, do not depend on our backups alone....

Can I remote connect to my databases?

Yes, you can. You must add the IP address you connecting from to the access host section of the...

How do I create a database?

To create a database:1. login to your account control panel2. click "Manage Mysql" in the...

How to assign MySQL Privileges:

In order to get the correct privileges added: Go to your MySQL Databases in cPanel. Add the...

I have a mysqldump of my database how do I upload it?

1. Greate a database in your control panel. 2. Go into myPHPadmin and select the database you...