> 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

Reply via email to