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

Are my databases backed up?

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

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

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