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 create a backup of a database?
1: Log in to the server via SSH .
2: Write a command like this (directly at the Telnet prompt):

mysqldump -Q -u username -h localhost -p databasename > textfile

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

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

That's it!

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: 5 from 5 (1 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