Pages
-
Recent Posts
- Results of a dog bite
- Fort george
- Droid Wordpress App Really Works
- Droid Wordpress App Works Great!
- Back Up Windows From Linux, Free and Simple
- Terry’s Favorite Mushroom Frittata
- Frozen Tamales with Sauteed Mushrooms
- Tiny Taco Salads
- Handbrake 0.9.3 for Ubuntu 9.10 Karmic Koala
- Old Version of Handbrake for Ripping DVD to Xvid
- Exclude a Category from the Front Page in Wordpress
- Dell Inspiron 2500 With Intel 82815 Graphics xorg.conf for 1024×768
- Setting Permissions Properly in Wordpress
- Backing up MYSQL databases using mysqldump – HahA! – Easier than it looked.
- ASPI Layer for Windows XP – Use ForceASPI 1.7
-
Recent Comments
Backing up MYSQL databases using mysqldump – HahA! – Easier than it looked.
This worked for me:
Back up:
mysqldump -u USERNAME DATABASE > BACKUP-FILENAME -pThen you have to type the mysql user’s password, and voila a dump file is created. I named my file something.sql .
Now to import that file, I will test the following:
mysql -u USERNAME -p DATABASE < BACKUP-FILENAMEYes, it works. My database appeared to be completely restored in a test.