To backup all MySQL databases on a machine, use the following command: -
mysqldump -u root -psecret --all-databases > backup.sql
To restore all databases, use the following command: -
mysql -u root -psecret < backup.sql
To restore a single database (from a cpanel backup etc), use the following command: -
mysql -u user -psecret dbname < dbbackup.sql
Subscribe to:
Post Comments (Atom)
-
VirtualBox 3.2.10 gives me the following error message when booting Ubuntu 10.10:- piix4_smbus 0000.00.07.0: SMBus base address uninitializ... -
PSPad is a great editor for programmers. Instead of using a dedicated Python IDE, PSPad can be tweaked to compile and run scripts directl... -
I've recently bought a Linksys WRT54GL Router. This is a great little unit that allows you to upload custom firmware. After playing arou...
No comments:
Post a Comment