| Subject: | Unable to run on mysql databases |
| Date: | Mon, 28 Nov 2011 18:47:18 +1000 |
| To: | bug-MySQL-Diff [...] rt.cpan.org |
| From: | Paul Whipp <paul.whipp [...] gmail.com> |
mysqldiff looks like just what I need to compare some db structures but...
...
Installing /usr/local/man/man3/MySQL::Diff::Utils.3pm
Show quoted text
> Installing /usr/local/bin/mysqldiff
> Writing /usr/local/lib/perl/5.10.1/auto/MySQL/Diff/.packlist
> ASPIERS/MySQL-Diff-0.43.tar.gz
> ./Build install -- OK
Tried it on two existing (one production, one clean from Magento) databases:
Show quoted text> mysqldiff animalhe_ahs magento
>
> *Use of uninitialized value $name in concatenation (.) or string at
Tried it on dumps:
Show quoted text>> /usr/local/share/perl/5.10.1/MySQL/Diff/Table.pm line 212.*
>
> *definition for field 'CONSTRAINT' duplicated in table ''*
>
> * at /usr/local/share/perl/5.10.1/MySQL/Diff/Database.pm line 269*
>
>
>
> /tmp $ mysqldump animalhe_ahs > animalhe_ahs.sql
> /tmp $ mysqldump magento > magento.sql
> /tmp $ mysqldiff animalhe_ahs.sql magento.sql
> *animalhe_ahs.sql contains dangerous command 'Use'; aborting.*
Tried without the data in the way:
Show quoted text> /tmp $ mysqldump --compact -d animalhe_ahs > animalhe_ahs.sql
> /tmp $ mysqldump --compact -d magento > magento.sql
> /tmp $ mysqldiff animalhe_ahs.sql magento.sql
> *ERROR 1005 (HY000) at line 153: Can't create table
> 'test_mysqldiff-temp-1322469643_7084_0.api_session' (errno: 150)*
Gave up. MySQL info (its a development workstation):
Show quoted text> /tmp $ mysqlreport
> *MySQL 5.1.41*-3ubuntu12. uptime 2 6:16:2 Mon Nov 28 18:42:46 2011
If I've missed something, let me know. If it was python I'd have looked
deeper to fix it :)
Regards,
Paul Whipp
Office: 07 3103 2894
Mobile: 0410 545 357
Do more business with your website! <http://www.paulwhippconsulting.com.au>
Joomla, Python, PHP and MySQL web application
developer<http://www.paulwhippconsulting.com.au/>