Convert SQLite database to MySQL [OUTDATED]

Jjustmee22 · Apr 1st 2016

okay its loading and get this mesage (sorry)

LOAD WORLDPART FILE: wp-3_5.db
java.sql.SQLException: path to '/Worlds/New World/worldParts/wp-3_5.db': '/Worlds' does not exist
at org.sqlite.Conn.open(Conn.java:103)
at org.sqlite.Conn.<init>(Conn.java:57)
at org.sqlite.JDBC.createConnection(JDBC.java:77)
at org.sqlite.JDBC.connect(JDBC.java:64)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at risingworld.worldconverter.database.SQLiteConnection.connect(SQLiteConnection.java:33)
at risingworld.worldconverter.SQLitetoMySQL$11.convert(SQLitetoMySQL.java:1345)
at risingworld.worldconverter.SQLitetoMySQL.convertToMySQL(SQLitetoMySQL.java:77)
at risingworld.worldconverter.RisingWorldWorldConverter.main(RisingWorldWorldConverter.java:12)
FATAL ERROR OCCURRED!
java.lang.NullPointerException
at risingworld.worldconverter.database.SQLiteConnection.openStatement(SQLiteConnection.java:59)
at risingworld.worldconverter.SQLitetoMySQL$11.convert(SQLitetoMySQL.java:1346)
at risingworld.worldconverter.SQLitetoMySQL.convertToMySQL(SQLitetoMySQL.java:77)
at risingworld.worldconverter.RisingWorldWorldConverter.main(RisingWorldWorldConverter.java:12)

red51 · Apr 1st 2016

Quote from Jjustmee22

okay its loading and get this mesage (sorry)

That's strange I've uploaded another converter version (link), please try that one. If it still does not work, make sure that the converter has full access to the "Worlds" folder.

Jjustmee22 · Apr 1st 2016

normal its full acses i wil try it

Jjustmee22 · Apr 1st 2016

okey now i got this i think its work what is the next stap ?

LOAD WORLDPART FILE: wp2_-4.db
LOAD WORLDPART FILE: wp-5_0.db
LOAD WORLDPART FILE: wp-2_0.db
LOAD WORLDPART FILE: wp977_85.db
LOAD WORLDPART FILE: wp-5_-3.db
LOAD WORLDPART FILE: wp1_4.db
LOAD WORLDPART FILE: wp3_2.db
LOAD WORLDPART FILE: wp-3_-2.db
LOAD WORLDPART FILE: wp5_88.db
LOAD WORLDPART FILE: wp-4_-2.db
LOAD WORLDPART FILE: wp0_7.db
LOAD WORLDPART FILE: wp0_5.db
LOAD WORLDPART FILE: wp2_4.db
LOAD WORLDPART FILE: wp4_-1.db
Copied 189206 data points from SQLite to MySQL in 26 seconds

red51 · Apr 1st 2016

Quote from Jjustmee22

Copied 189206 data points from SQLite to MySQL in 26 seconds

The process is complete, this line indicates that the data points have been successfully copied to MySQL Now you can start the server, but remember to adapt the "server.properties" file first: Change database_type to "mysql", insert the database name into database_mysql_database, and enter the username (database_mysql_user), password (database_mysql_password), server ip (if running on the same machine, enter 127.0.0.1) and port (default mysql port is 3306).

Jjustmee22 · Apr 1st 2016

Okey thanks i go try

Jjustmee22 · Aug 16th 2016

hello is there an version 30

Jjustmee22 · Oct 12th 2016

hello all i need converter for version 30 please :p

Hun73rdk · Jan 30th 2017

No converter for version 32

Jon_miner · Mar 19th 2017

Looking for converter for version 32 as well.

ViralGamer · Apr 8th 2017

Seems this file needs another update. I get the error "not compatible with version 32"

red51 · Jun 18th 2017

Sorry for losing sight of the world converter It took way too long, but now a new version of the converter is available (compatible for version <=36): https://download.rising-world.net/tools/converter.zip
Please keep in mind that you can't go back to SQLite after converting the world to MySQL.

Minotorious · Jun 19th 2017

@red51 I must be doing something wrong but I tried converting a SP world for testing purposes and I am getting an error.

So here is what I did:
1) open windows powershell
2) run java -jar ./converter.jar "D:\Program Files\Steam\steamapps\common\RisingWorld\Worlds\Editortest" 127.0.0.1:3306 root 123456789 Editortest
3) got error "No connection possible to SQLite database: D:\Program Files\Steam\steamapps\common\RisingWorld\Worlds\Editortest." (see screenshot for more info)

MarcosRC · Jun 19th 2017

I had the same error as @Minotorious, in Linux.

Code

marcos@Ceres:~/ssd/rising-world_server/Worlds$ java -jar ~/Temp/Converter/converter.jar Marcolandia3 localhost root mypasswordhere Marcolandia3
java.lang.ClassNotFoundException: org.sqlite.JDBC
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at risingworld.worldconverter.database.SQLiteConnection.<init>(SQLiteConnection.java:24)
        at risingworld.worldconverter.SQLitetoMySQL.convertToMySQL(SQLitetoMySQL.java:33)
        at risingworld.worldconverter.RisingWorldWorldConverter.main(RisingWorldWorldConverter.java:12)
java.sql.SQLException: No suitable driver found for jdbc:sqlite://ssdforhome/rising-world_server/Worlds/Marcolandia3/Marcolandia3.db
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:270)
        at risingworld.worldconverter.database.SQLiteConnection.connect(SQLiteConnection.java:33)
        at risingworld.worldconverter.SQLitetoMySQL.convertToMySQL(SQLitetoMySQL.java:34)
        at risingworld.worldconverter.RisingWorldWorldConverter.main(RisingWorldWorldConverter.java:12)
No connection possible to SQLite database: /ssdforhome/rising-world_server/Worlds/Marcolandia3

Display More

red51 · Jun 19th 2017

@Minotorious and @MarcosRC: Hmm... it looks like the lib files were missing Sorry about that, please redownload the converter, now it should contain all required libs. If it still does not work, make sure that the program has read and write permission for the Temp folder.

MarcosRC · Jun 19th 2017

Quote from red51

@Minotorious and @MarcosRC: Hmm... it looks like the lib files were missing Sorry about that, please redownload the converter, now it should contain all required libs. If it still does not work, make sure that the program has read and write permission for the Temp folder.

Perfect! Working now

Minotorious · Jun 19th 2017

Still not working for me, but a different error this time, probably related to permissions, though I did check and the converter has read/write permissions on all users (including administrators). I will try it later on my ubuntu VM but if you can help me in the meantime I would appreciate it

Edit: Exact same error on ubuntu too, even used sudo in front of the "java -jar etc." command to force admin mode execution.

red51 · Jun 20th 2017

@Minotorious: The error indicates that the converter wasn't able to connect to the MySQL server. Is there actually a MySQL server running on the same machine (127.0.0.1:3306)? Does it contain a database (in your case "Editortest")? The converter does not create a new database, so you have to create an empty database first.

Minotorious · Jun 20th 2017

Quote from red51

The converter does not create a new database, so you have to create an empty database first.

oh I see that explains a lot XD will give it another try now

Sneaky_Koala · Feb 2nd 2018

I'm getting a similar error to that encountered above by Minotorious:

java.sql.SQLException: Could not connect: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.Driver.connect(Driver.java:115)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at risingworld.worldconverter.database.MySQLConnection.connect(MySQLConnection.java:28)
at risingworld.worldconverter.SQLitetoMySQL.convertToMySQL(SQLitetoMySQL.java:56)
at risingworld.worldconverter.RisingWorldWorldConverter.main(RisingWorldWorldConverter.java:12)
Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:558)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:500)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:709)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:280)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
... 5 more
No connection to MySQL possible
--------------------------------

Version info:
mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

------------------------------

I've created a new mysql database

Edit to add: The client is also the latest version

Participate now!