I am currently running my sims on sqlite storage, my prims and all settings being stored in opensim.db. I want to convert to mysql storage, and keep both of the sims I currently have with all their prims, terrain, and all the scripts on them (subdivisions and parcel settings can easily be remade if its the case).

I tried the apparently only option; save-xml and load-xml. Sadly, I already have a high number of prims which causes save-xml to fail and not save all of them. When load-xml-ing, only a part of my prims get loaded, causing incomplete buildings and the like. Can anyone please tell me how I can change my sims from sqlite to mysql without loosing all my prims, their scripts and terrain?

Hi Mercea.
Ok i know virtually nothing about all this but i have read on Nebaden that when you save xmls use the new xml2 extension, and additionally create neww uuid''s for the prim set to avoid clashing with duplicate uuid's.
I'll hunt around for a database/sql method i'm sure it is a common situation.
hope that helps

hi again Mercea
I found this :
SQLite ----> MySql

Download sqlite3.exe on http://www.sqlite.org
Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
Adapt the dump to get it compatible for MySQL
- Replace " (double-quotes) with ` (grave accent)
- Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
- Replace "autoincrement" with "auto_increment"
The dump is ready to get imported in a MySQL server
MySql ----> SQLite

Export the database in an ASCII compatible format. (functionnality available in phpMyAdmin 2.6.1)
Import to SQLite with command line : sqlite3 mySQLiteDataBase < dumpMySQL
on this website....
http://sqlite.phxsoftware.com/

mabby helpful

And finally,
this is a manager for sqlite
http://sourceforge.net/project/showfile ... _id=201528

Isn't it possible just to copy and paste all the data in the tables?

Or do that with an automated script, that is...

I was just about to paste a link, but realised zoon beat me to it.
Nice one.