optimize entire db

2003-06-04 Thread Mark Stringham
Hi - Can anyone give the command line syntax for optimizing the entire db? thanks in advance. MS

RE: optimize entire db

2003-06-04 Thread Dathan Vance Pattishall
PROTECTED] --Subject: optimize entire db -- --Hi - -- --Can anyone give the command line syntax for optimizing the entire db? --thanks in advance. -- --MS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: optimize entire db

2003-06-04 Thread colbey
I've used a simply shell script in the past.. run from cron to do it... I just see someone posted a perl solution.. I've used a php one aswell.. #!/bin/sh # DB OPTIMIZE SCRIPT - !! WARNING, DOES TABLE LOCKING DURING OPTIMIZES user=root pass=secret host=10.1.1.1 db=mydb [EMAIL PROTECTED]

Re: optimize entire db

2003-06-04 Thread Stefan Hinz
Mark, Can anyone give the command line syntax for optimizing the entire db? thanks in advance. mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...] This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a) or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be used at