Where is the MySql database?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
bironeb
Forum Commoner
Posts: 59
Joined: Thu Nov 20, 2003 12:02 pm

Where is the MySql database?

Post 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
User avatar
bironeb
Forum Commoner
Posts: 59
Joined: Thu Nov 20, 2003 12:02 pm

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Task Scheduler.. it's built into the OS..
qads
DevNet Resident
Posts: 1199
Joined: Tue Apr 23, 2002 10:02 am
Location: Brisbane

Post 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.
Post Reply