I had to use PhpMyDiff at work today for this first time in a while and managed to fix up a few bugs. I’ve also implemented a new way of comparing databases if the tables use the MyISAM engine. Rather than having to grab every row from the table and compare row by row, mysql has a CHECKSUM function, which quickly returns the table checksum. If the checksums are different the original process (of grabbing the data) comes back in to play but for databases with only a few table changes, its a huge speed increase.
Given time I’d like to introduce a similar row by row checksum, which should be easy enough for tables with a primary key. PhpMyDiff is still a long way from complete, but it may slowly get there!
Oh, it should also be possible to compare any database type supported by Zend_Db now, although I haven’t had the chance to test this at all. I’m sure something will break, as a few of my queries are probably MySQL specific!!
Feedback would be great if anyone gets the time… check it out at http://code.google.com/p/phpmydiff/
5 Comments
I am trying to get the PhpMyDiff v.3 working but I get a “Object not found” error after I fill out the boxes and hit “Compare”
The url that shows is localhost/phpmydiff/compare/advanced
cache is writable
There does not seem to be a mydiff.ini file and I’m not sure what to edit in the application.ini or database.ini
can you please provide some clues ??
I can try to look in to this in more detail tomorrow, for now could you try grabbing some extra information on the error by turning on “development” mode.
In the .htaccess file, stick “setenv APPLICATION_ENV development” on a new line.
That should allow the server to spew out a stack trace of the error and help me pinpoint the problem.
Thanks for answering … the setenv did nothing .. I get no output.
FYI .. I’m working on PCLinuxOS 2010
I’ve got the same problem as Ron, it appears as if the .htaccess rewrite rules aren’t working, so when the initial form is submitted it tries to got to /compare/advanced which results in a 404 error.
I’ve tried editing htaccess, but havent figured out how to get it to send rewrites to index.php correctly.
I figured out my problem; I didn’t have the rewrite module enabled at all on my Ubuntu server.