VDS Sphera Knowledge Base

Main / Browse Categories / MySQL / How can I dump a MySQL database from the command line?

Print article Print Article    Email article Email Article

How can I dump a MySQL database from the command line?
From the SSH command line:
mysqldump -h localhost DATABASE > DATABASE.sql
Replace DATABASE with the name of your database.

NOTE: Accounts created before July 7th, 2003 will want to use:

/usr/local/mysql/bin/mysqldump -h localhost DATABASE > DATABASE.sql

User Comments
How can I dump a MySQL database from the command line?  
There are no user comments for this topic.
 

Attachments
No attachments.

Related Articles
 How can I connect to MySQL using SSH?
 My Disk Quota is unusually high. What can I do?
 Where is MySQL located?
 Where is the MySQL log file?
 Where is the MySQL my.cnf file?

Why Choose Our Hosting?

Continue reading »

Featured Hosting Plan


Learn more about our VPS Extreme

What is Included?

  • PHP 5/MySQL 5
  • Plesk Control Panel
  • Unique IP Address
  • SAS Hardware Raid diskspace
  • CentOS 5 x86_64 bit
  • Multi-homed Tier 1 Bandwidth
  • Full Upgrade capabilities
Continue reading »