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

Dangerous PHP Functions

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

Stop Console Messages

2 ways to stop messages output on linux server console #mesg n or #vi /etc/sysctl.conf...

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...

softaculous installation

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