MySQL Forums
Forum List  »  Replication

sql replication ... different question
Posted by: ryan foley
Date: January 07, 2005 07:12AM

Hay All,

New to the mysql area..

I Was wondering if I could do this..

I have a mysql running. Would like to create a query that creates another database on the same server as a backup.

E.g. Once a night have the machine run a query that locks the database then copies it to another file on the same server as another database. Wondering if this is possible i am not too worried about loosing data but I would like to have some means of recovering my database if it gets corrupted. And a once a day backup is all i need . Not much data changes a day. But just incase.

e.g.. database1 - main database
database2 - backup database?

Thanks in advance.


Options: ReplyQuote

Written By
sql replication ... different question
January 07, 2005 07:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.