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 Linux Binaries

It's recommended to chmod the following linux binaries to 750 to prevent non-privileged users...

softaculous installation

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

CSF firewall installation

CSF is great firewall for all linux based servers. For non-cpanel servers you'll need to install...

SAR (system activity monitor)

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

cPanel Installation

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