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
|
You cannot comment on this entry | Content Overview: MySQL
|
|
|