Reply To: Crystal Reports Query Hi all, Anyone familiar with Crystal Reports? Basically my proposed setup is as follows:- Windows 2022 server 64 bit mysql server 8.0.27 64 bit Windows 10 64bit client running crystal…

[kev2021]

Hi all,

So did a test tonight and in summary yes, ODBC 32 bit will talk to the MySQL 64 bit database server.  The crystal reports 11 (32 bit) wont see the ODBC 64 bit driver to connect to the server with so hence using 32 bit works ok.

One downside is, previously I used to copy the data folder which contains all my DB files over to the new server (stopping MySQl service first and then starting once copied over).  It seems this doesn’t work with MySQL 8.0.  If i copy 1 folder from MySQl 5.6.x to MySQL 8.0 and restart the service it fails to start, move the folder out and it starts fine.

So potentially a issue with the 32bit db files being copied into a 64bit installation?

I have overcome this by simply registering the new Db server in my MySQL client I use and then copying the database over to the new server via that – bit cumbersome doing each Db at a time but I only did 1 as I have setup a test server just to verify what works/doesn’t work.

I noticed then that when checking the actual files, the files on MySQL 8.0 doesn’t have a .frm on some of them like on 5.6.x so I’m wondering if that has something to do with it.

At present, my backup system is to simply stop MySQL, copy the data folder to my nas and then start the service as this has always worked ok but i’m now not sure it will work on MySQL 8.0 so may need to find a new plan.  Some of my DBs are ok as I work on them locally then copy up to hosting site but others are local use only so no other copy, hence my easy solution of copying the data folder so will need to look into this more as maybe once they are all in the MySQl 8.0 format, i can simply copy the data folder again and all will be will, could simply be a difference from 32 bit to 64bit but not familiar with that at the moment.

Thanks

Kev

Share the knowledge

You need to login in order to vote