Re: Migrate data from sqllite to mysql

[fab admin]

Hello Martin,

Thanks for your help.

I downloaded the new script and launch it. It works!

Data have been migrated. I change the method in server.xml to MySQL and it works fine ;)

Thanks again for you're help Martin.

Kind regards,
Fabien

2014-11-12 16:25 GMT+01:00 Martin Pala <address@hidden>:

Hello,

there was bug in the migrate script, the users table has to be migrated first, as the eventfilter and eventnotice tables have foreign key to it. You can get the fixed script here: http://mmonit.com/tmp/migrate_db.sh

Regards,
Martin



> On 11 Nov 2014, at 17:38, fab admin <address@hidden> wrote:
>
>
> Hello all,
>
> This is my first post on the mailling list so welcome!
>
> We use Monit to manage few host (with MMonit as dashboard) and we would like to migrate from sqllite3 to MySQL.
>
> We create a new database, and a new user with all rights on this database.
>
> CREATE DATABASE mmonit;
> GRANT ALL ON mmonit.* to address@hidden identified by 'password';
> FLUSH PRIVILEGES;
>
> We go to the specific folder:
> cd /usr/local/mmonit/mmonit-3.3/db
>
> Do this:
> mysql -u mmonit mmonit -p < mmonit-schema.MySQL
>
> All tables have been created.
> So now, we try to migrate all existed data from sqlite3 to MySQL with the script.
>
> ./migrate_db.sh -t mysql | mysql -u mmonit -p mmonit
>
> It start. But 1min later, I've this error:
> ERROR 1452 (23000) at line 79410: Cannot add or update a child row: a foreign key constraint fails (`mmonit`.`eventfilter`, CONSTRAINT `eventfilter_uname_fk` FOREIGN KEY (`uname`) REFERENCES `users` (`uname`) ON DELETE CASCADE)
>
> Did this problem append tom somebody before? I don't how I can solve this problem of foreign key here...
> Do you know how I can solve it?
>
>
> Thanks a lot for your help.
>
> Regards,
> Fabien
>
>
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general


--
To unsubscribe:
https://lists.nongnu.org/mailman/listinfo/monit-general