Site Panel Help User Panel Help Panel Demo's Search Help

Categories

· Show all categories

New Customer FAQs
E-Mail
FTP - File Transfers
Domains
SSH and Telnet
Scripting Languages
Password Protection
MySQL
Stats
Power Tools

· FAQ Home

· EchoEcho+ Support

MySQL: How do I restore a backup of a database?
You can restore a backup of a database created with mysqldump *.

1: Create the database with the site owner panel
- The ONLY way you can create databases is from the site owner panel, so you must create the database first.
- If it already exists, delete it, and create it again to make sure it's empty before the restore.
2: Log in to the server via SSH .
3: Write a command like this (directly at the SSH prompt):

mysql -u username -h localhost -p databasename < textfile

- username is the username for your hosting plan, for example: testuser.
- databasename is the name of your database, for example: testuser_mybase.
- textfile is the name of the backup file, for example: backup_mybase.

4: You will be asked for your password. Enter the mysql password for the database.

That's it - mysql will now read the backup file and create and restore your database tables!



* The backup procedure is explained here: How do I create a backup of a database?

Last update: 12.07.2009, 21:19
Author: EchoEcho Support

printer-friendly version Send to a friend
Show this as PDF file export as XML-File

Average rating: 0 from 5 (0 Votes )

Please rate this entry:
completely
useless

1

2

3

4

5
most
valuable
You cannot comment on this entry | Content Overview: MySQL
Copyright © EchoEchoPlus Hosting