Could anyone advise on the best way to copy an existing InfiniDB database from one Windows machine to another?
I copied the "mysqldb" and "data1" directories from my existing InfiniDB instance to the InfiniDB install directory on my second machine, as per the (Linux-oriented) backup instructions in the Admin guide. (Actually that's slightly inaccurate - I copied the contents of the "mysqldb" directory (calpontsys, mysql and folders, but not the .err and .pid files).
I didn't suspend DB writes (but I didn't perform any writes during the above copy either. There may well have been queries running.). Is it possible to suspend writes on the Community Edition? If so, how do I achieve this on Windows?
When I restarted InfiniDB on my second machine, it successfully runs DESC on a table, but when I run e.g. a simple SELECT COUNT(*) it displays "ERROR 138 (HY000): pColStep: BRM error!".
At the moment I am running a script to do a SELECT TO OUTFILE on the original DB with a view to running cpimport on those outfiles on my "new" copy. As I only have 5 tables, that's fairly simple, but I wonder if there is a better way or why my original "backup" didn't seem to work.
Any advice please?