[Snort-users] Does any one know how to archive Mysql database?

mono toy mono at ...7050...
Wed Jan 29 07:25:05 EST 2003


> 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





More information about the Snort-users mailing list