Page 1 of 1

Where is the MySql database?

Posted: Tue Jun 15, 2004 1:35 pm
by bironeb
Is the MySql database in the C:\mysql\data folder by default? I need to backup my database and I needs some Ideas. Thanks

Posted: Tue Jun 15, 2004 2:12 pm
by bironeb
Well I found some scripts that will perform a backup,

shell> mysqldump --tab=/path/to/some/dir --opt db_name

Or:

shell> mysqlhotcopy db_name /path/to/some/dir

but I am more interested in using a progam I have that I tell it the directory on my computer and it does a daily back up of that directory to my network server.


Anyone have an Ideas?

Posted: Tue Jun 15, 2004 3:10 pm
by feyd
Task Scheduler.. it's built into the OS..

Posted: Tue Jun 15, 2004 8:33 pm
by qads
i use second copy 2000, makes backup of my dev server root and mysql data folder every few hours to another drive on the network :D.