MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: Archival backup
Posted by: Bill Karwin
Date: April 15, 2006 01:30PM

mysqldump is a tool that comes with MySQL, which outputs a SQL script which can reproduce the database. Mostly it consists of CREATE TABLE and INSERT statements. This is the primary backup method for MySQL.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

If you want an audit log of all statements sent to the server, you should look into the various logging features.

http://dev.mysql.com/doc/refman/5.0/en/log-files.html

Regards,
Bill K.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Archival backup
3504
Natalia Portillo
April 15, 2006 01:19PM
Re: Archival backup
2228
Bill Karwin
April 15, 2006 01:30PM


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.