Back up

[weronpc]

I am running php, mysql on window xp.

when user insert something to the database (mysql). where does the information stored?

I want to be able to make a back up copy of my data just incase I want to move from one pc to another...

thank you so much

weronpc:)

[Spookster]

You can do all of that with a decent mySQL GUI like phpMyAdmin.

[weronpc]

Cool, I got Phpmyadmin downloaded and got it running, but how do I make a back up?

thanx

[Spookster]

Click on the database name in the left column and then click on the Export menu option at the top towards the right hand side. From there it is pretty self explanatory. It gives you different options for exporting your tables.

[whackaxe]

if its your machine, look in the mySQL bin for a program called mysqldump.exe. run it from the command line and it'll tell you how to use it. otherwise look at the manual and youget info for all the differnt .exes in the bin