JI 1.1.0 and MySQL 5.1.14?

[Henry]

Hello,

 

at the moment I use JI 1.1.0 with MySQL 5.0.27. I start to change all my MySQL DB to migrate to 5.1.14.

 

My Question now: can I use JI 1.1.0 with MySQL 5.1.14 or higher?

 

Henry

[anandharaj]

It shouldn't be a problem

[Henry]

Hello Anandharaj,

 

 

it works. :)

 

 

First I try to make a backup und restore with the administration gui. When I imported the data I got a messages 2006 that the server has gone away.

 

 

After this I try to make the export/import by hand. I got also some error messages during the import like "server has gone". I think the size some of the big PDF-Reports that stored in the jasper DB are a problem for some select statement.

 

 

I added the following option in the my.ini file for the 5.0 and 5.1 server and also in the import and export statement.

 

 

[mysqld]

max_allowed_packet=1G

 

 

D:/Programme/MySQL/Server_5.0/bin>mysqldump -u root -p -P 3308 --databases jservermeta --max_allowed_packet=1G > D:/JServerMeta.sql

 

 

D:/Programme/MySQL/Server_5.1/bin>mysql -u root -p -P 3318 jservermeta --max_allowed_packet=1G < D:/JServerMeta.sql

 

 

Now the JasperIntelligence Server is up and runs with MySQL 5.1.14. :)

 

 

Best regards, Henry

Post edited by: Henry, at: 2007/01/24 12:28