How to backup and restore MySQL Database

How to backup and restore MySQL Database

Backup MySQL Databaase Syntax:
mysqldump -u root -h localhost -p [database name] > [script file name].sql
after entering this command, MySQL will ask for root password. Simply supply password and press enter.
To Restore MySQL Database to your newly created database:
Make sure that the name of your new database is the same with the name of your old database.
mysql -u root -h localhost -p [dataabase name] < [script file name].sql
after entering this command, MySQL will ask for root password. Simply supply password and press enter.

Comments

Philippines : Fare to be lessen by 5 centimos

Good news pilipinas, specially for the commuters out there...together with the continuous dropping of the gasoline price is dropping of our fare in public utility vehicles...yahoo!starting on monday, every transport groups will drop our fare by P0.0 centimos...hehehe...yahoo!

Surabaya hits my mistress

If this is your problem , i'm sure you are hit by a surabaya virus . My 1st pc that i treat as my mistress attacked by this virus when my brother connect it to a psp and these is what happens to my mistress: All folders and files including windows OS folder disappears. Only few folder files with fixed size of 40K appears to user. , When you try to change the options for show hidden files, it doesn’t show the previous data. , You will not able to run many anti virus & software programmes. Installation also get blocked. , There are files like thumb.exe , System becomes unresponsive. After login it takes lot of time to user to operate it. ...Can someone help me here!!!

What is oDesk?

If you are willing to work @ home online, try oDesk. Click this link

Just Sharing

Search This Blog