use a php file to optimize a database

[homer09001]

is it possible to write a php file that will optimize all tables within a specific database on a regular basis by using a cron job?

[Weedpacket]

Yes.

[homer09001]

how exxactly my php knowledge is limited?

[rincewind456]

 $sql = 'OPTIMIZE TABLE `Your_table_name`, `Your_next_table_name`. `etc`';
mysql_query($sql) or die('Query failed. ' . mysql_error()); 

[homer09001]

thanx rince is there an easier way to optimize all tables ? as there are at least 40 tables in teh database

[Installer]

Maybe like this:

$result = mysql_query('SHOW TABLES FROM my_db');
while ($row = mysql_fetch_array($result)) {
    $opt_res = mysql_query('OPTIMIZE TABLE ' . $row[0]);
}

[stevesweetland]

theres no 'optimise database' query, if thats what you mean.

one way you could achieve it easily tho, would be to return all the tables in a given database to an array, and run that statement for each of the array elements (tables).

EDIT

just like installers already done... lol