How to BackUp your Database
Open the DOS Command or Command Prompt. how to open the dos command. Click Start then RUN then type the cmd then press ok button.
then type cd \ then enter
step 2:
your now in the main path of the local hard drive. c:/>
then type this command:
mysqldump -u root -p. -B idtomisprd>idtomisprd.sql then enter
the idtomisprd.sql is the local database. rename it if you want but be sure that extension name still .sql
mysqldump -u root -p. -B idtomisprd>GTS.sql "like this" then enter
then the database will be backup if you want to know if your database has been backup.
go to my computer then local disk c: then find the idtomisprd.sql
note:
database may be looklike a notepad, you can view it in the notepad but dont make a mistake and press the SAVE AS it will change its extension name into .txt by doing this you messed up your database.







No comments:
Post a Comment