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

What version of mySQL are you running?

Login to your control panel. On the left side under "Server Info" it tells the mysql version

Restoring a mysql database via SSH

In order to restore your database via SSH or Telnet you will require 2 things:1. SSH or Telnet...

MS SQL Server - Installation

MS SQL Server - InstallationSQL Server supports two types of installation    1. Standalone    2....

How to Backup & Restore a MySQL Database

How to backup Mysql Database.   First, log in to your cPanel using your username and password....

Insert data into your database

Once you have your MySQL database, you can use the phpMyAdmin and insert data into your...