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

SAR (system activity monitor)

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

Delete shell history

Delete the .bash_history file: # rm -rf ~/.bash_history Clear the current history stored in...

Dangerous Linux Binaries

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

CSF firewall installation

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