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 Server and > run a SQL > explain command on the database but i get different EXPLAIN result. I > think because > i copied it from one source shouldn't it show the same EXPLAIN result > cause i didn't > change any of the index, keys or records Not if that's what has changed between versions. Check the change log for details of what was altered, to see if it's relevant. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
