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... -
If you have a Roku 2 media streamer and use a wireless network scanning tool such as Acrylic Wi-Fi Home, you might see a hidden wi-fi networ...
No comments:
Post a Comment