MantisBT - opensim
View Issue Details
0008312opensim[GRID] Other Servicepublic2018-04-10 23:042018-04-14 12:09
thomax 
 
normalminoralways
newopen 
tinkerboarddebian
master (dev code) 
 
96aecf80ef933273bc75e1d77d9b5137fb05505a
Standalone (1 Region) , Standalone (Multiple Regions) , Grid (1 Region per Sim) , Grid (Multiple Regions per Sim)
BasicPhysics, ODE, BulletSim, ubODE, Other
Unknown, Mono / Linux32, Mono / Linux64, Mono / Windows, Mono / OSX, .NET / Windows32, .NET / Windows64
None
0008312: differences between sqlite and mysql tables
there are fields in tables, which exists in sqlite but not in mysql and vice versa. the order of fields and the naming might also mismatch. i attached a spreadsheet with some of the differences. i reordered some table fields to get a better overview of mismatches. i also attach a little perl script, which helped me to migrate from sqlite to mysql.
dump the database schemata and have a look on the differences.
migrate from sqlite to mysql might disorder scripts in linked objects, because sqlite didn't keep the link number.
No tags attached.
? opensim sqlite vs mysql.ods (26,541) 2018-04-10 23:04
http://opensimulator.org/mantis/file_download.php?file_id=4723&type=bug
? MIGRATE.pl (3,414) 2018-04-10 23:09
http://opensimulator.org/mantis/file_download.php?file_id=4724&type=bug
Issue History
2018-04-10 23:04thomaxNew Issue
2018-04-10 23:04thomaxFile Added: opensim sqlite vs mysql.ods
2018-04-10 23:09thomaxFile Added: MIGRATE.pl
2018-04-13 12:12aiaustinNote Added: 0032639

Notes
(0032639)
aiaustin   
2018-04-13 12:12   
If this can get checked... it would be worth making this consistent also to PostgresSQL and MSSQL to.