"be consistent" | |
PerlMonks |
MySQL-Diff drops existing tables?by jbrugger (Parson) |
on Nov 10, 2005 at 05:33 UTC ( [id://507294]=perlquestion: print w/replies, xml ) | Need Help?? |
jbrugger has asked for the wisdom of the Perl Monks concerning the following question:
Hi great ones. Yet another question from me: I use MySQL 4.0.24 as a databse server, and MySQL-Diff 0.30 from Adam Spiers. (the perl MySQL::Diff module, that's why i ask it here) *update* ps: just installed version 0.33 from cpan, and still have the same problem When i try to compare 2 databases, i get the weird output like this: The thing is, both tables (reports and yetAnotherTable) exist with the same structure in both databases and both contain data. I don't know when the diff started to create these drop-table queries, but they are unwanted and the parameter --keep-old-tables is unwanted (and not working in this case. I tried more than one machine, and can't figure out what's wrong, when i compare db2 to db1 (the other way round), it goes like expected (but i need to compare the other way). Any ideas what might be wrong and are there others that experience the same problem? Thanks.
"We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise." - Larry Wall.
Back to
Seekers of Perl Wisdom
|
|