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

Stop Console Messages

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

Dangerous PHP Functions

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

Delete shell history

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

Securing /dev/shm

To secure /dev/shm look for the mount line for /dev/shm in /etc/fstab and change it to the...