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

[Erick Mechler <emechler () techometer net>]

:: I use a shell script and an sql script to clean our mysql database in 
:: Solaris.  This also cleans the acid tables.  The script will prompt you for 
:: the password.

This is a minor note, but for MySQL, "delete from [tablename]" will work
just fine, however "truncate table [tablename]" is much quicker as it
doesn't do a row-by-row delete.  If you have small tables this won't matter
much, but some people may notice a substantial speed increase by using
truncate.

Cheers - Erick


-------------------------------------------------------
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