Re: [PHP-DB] mysql different server different EXPLAIN result

2007-07-24 Thread Chris
Chenri wrote: Dear All I'm running 3 servers with mysql database - Local : 5.0.18-log, MySQL Community Edition (GPL) - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard (GPL) - Backup Server : 4.1.20, Source Distribution Not sure why you're surprised why they are differen

Re: [PHP-DB] mysql different server different EXPLAIN result

2007-07-24 Thread Niel
Hi > I'm running 3 servers with mysql database > - Local : 5.0.18-log, MySQL Community Edition (GPL) > - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard > (GPL) > - Backup Server : 4.1.20, Source Distribution > > I copied a database from the Main Server to Local and Backup