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

If your database backup is on your home computer, you will first have to upload it via FTP to your website.

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 directoties to wherever the backup is 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 restored.

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

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

How To Create Mysql Database.

Creating Mysql Database.Mysql Database: MySQL databases allow you to store a large amount of...