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