Backup & Restore MySQL Database from Shell

- Backup a database

mysqldump -u Username -p dbname > anyname.sql

- Restore a database

mysql -u username database -p < databasefile.sql

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

cPanel Installation

cPanel installatin is very easy, all you need is a new minimal installation of a supported linux...

Reset cPanel (WHM) Initial configuration

Have you configured dedicated server with cPanel (WHM) for a client but would like to reset WHM...

Dangerous PHP Functions

The following PHP functions are considered dangrous and should be disabled on any web server,...

SAR (system activity monitor)

SAR (system activity monitor) produces system utilization reports based on the data collected...

Securing /dev/shm

To secure /dev/shm look for the mount line for /dev/shm in /etc/fstab and change it to the...