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

SAR (system activity monitor)

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

Clean apache Semaphore

#ipcs | awk '/^0x000000/ && /nobody/ {print $2}' | xargs -n1 ipcrm -s

cPanel Installation

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

Dangerous PHP Functions

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

softaculous installation

#cd /usr/local/cpanel/whostmgr/docroot/cgi #wget -N...