Thursday, October 10, 2013

HOW TO BACKUP YOUR FILE WITH THE USE OF COMMAND PROMPT


You must first select what database you want to backup. With the use of command use samplelibrary;.

The samplelibrary is the database name that I used as an example for this tutorial.



After that you can check if the database has tables in it.


Then type EXIT and then ENTER.


After that type the mysqldump –u root –p samplelibrary>itbackup.sql  the samplelibrary is the database name that you want to have a backup while itbackup.sql is the filename that is use for that samplelibrary.Then press ENTER.


Go to HOME button and then go to your COMPUTER or locate where did you extract your xampp . As for
 me my xammp is located at the Local disc C. Then choose the XAMPP folder then CLICK.


And then find the mysql folder and then press ENTER.


After that find the bin folder then press ENTER.


As you can see the file name itbackup.sql is there.



No comments:

Post a Comment