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 the same time. It works on MyISAM and in some cases on BDB tables. (The above is a copy of the output of mysqlcheck --help.) Note that you cannot use that program for InnoDB tables. To check all tables in a database mydb, you would issue: mysqlcheck --optimize --databases mydb Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
