RE: Does any one know how to archive Mysql database?

["mono toy" <mono () spurious biz>]

> Is there any way to backup the database ad then clear all its contents,
> without deleting all tables in database?

something like

/usr/local/bin/mysqldump dbname -u yourusername -pyourpassword >
/path/to/dbname_date.dump
/usr/local/bin/mysql dbname -u "user" -pyourpassword -e "DELETE FROM
table"

hth,

nico



-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users