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... -
This is what I have found to be the quickest way to wipe a hard drive under Linux (you can use an Ubuntu Live CD to do this). sudo shred -...
No comments:
Post a Comment