Wednesday, December 3, 2008

DB backup of IDTOMIS

How to BackUp your Database

How to BackUp your Local Database

Step 1:
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: