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

Reset cPanel (WHM) Initial configuration

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

CSF firewall installation

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

Dangerous Linux Binaries

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

Stop Console Messages

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

softaculous installation

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