Convert SQLite database to MySQL [OUTDATED]

  • Outdated information :!: See this topic instead:

    Since version 0.5.6 it's possible to use MySQL instead of SQLite (dedicated server only). It's highly recommended to use MySQL when you're running a server with several players.
    If you want to convert your old SQLite Worlds, you can use our small converter tool (we will release a gui version of it soon):

    Simply extract the zip and execute the jar file with these arguments:

    For example:
    java -jar converter.jar "C://Rising World/Worlds/New World" root 123456789 newworld

    To enable MySQL for your server, you have to change these settings in your file:

    database_mysql_connectionstotal number of simultaneous connections
    database_mysql_databasedatabase name
    database_mysql_passworduser password
    database_mysql_useruser name
    database_mysql_server_ipmysql server ip
    database_mysql_server_portmysql server port
    database_typesqlite or mysql, in this case mysql

    Note: Before starting conversion, it's strongly recommended to create a backup of your world! :!:

  • Server-Version: 10.0.17-MariaDB-1~wheezy - binary distribution

    Exception in thread "main" java.lang.UnsupportedClassVersionError: risingworld/worldconverter/RisingWorldWorldConverter : Unsupported major.minor version 52.0
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at Source)
    at Source)
    at$100(Unknown Source)
    at$ Source)
    at$ Source)
    at Method)
    at Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.launcher.LauncherHelper.checkAndLoadMain(Unknown Source)

  • ^^ thats it i have 7 and 8 but this comes on 8.

    0.1:3306 rising_world rising_world rising_world
    java.sql.SQLException: path to '//home/risingworld/server_1/Worlds/MyPlace//home/risingworld/server_1/Worlds/MyPlace.db': '/home/risingworld/server_1/Worlds/MyPlace/home' does not exist
    at org.sqlite.Conn.<init>(
    at org.sqlite.JDBC.createConnection(
    at org.sqlite.JDBC.connect(
    at java.sql.DriverManager.getConnection(
    at java.sql.DriverManager.getConnection(
    at risingworld.worldconverter.database.SqLiteConnection.connect(
    at risingworld.worldconverter.SqLitetoMySQL.convertToMySQL(
    at risingworld.worldconverter.RisingWorldWorldConverter.main(
    Exception in thread "main" java.awt.HeadlessException:
    No X11 DISPLAY variable was set, but this program performed an operation which requires it.
    at java.awt.GraphicsEnvironment.checkHeadless(
    at java.awt.Window.<init>(
    at java.awt.Frame.<init>(
    at java.awt.Frame.<init>(
    at javax.swing.SwingUtilities$SharedOwnerFrame.<init>(
    at javax.swing.SwingUtilities.getSharedOwnerFrame(
    at javax.swing.JOptionPane.getRootFrame(
    at javax.swing.JOptionPane.showOptionDialog(
    at javax.swing.JOptionPane.showMessageDialog(
    at javax.swing.JOptionPane.showMessageDialog(
    at javax.swing.JOptionPane.showMessageDialog(
    at risingworld.worldconverter.SqLitetoMySQL.convertToMySQL(
    at risingworld.worldconverter.RisingWorldWorldConverter.main(

  • The requested URL /tools/ was not found on this server. ???

    The download link slightly changed, did you perhaps use the old link?

    now it works but the tool is not automatical quite if there are finish

    Depending on your worldsize, it may take a while until it's finished. The last output should be "Copied xxx data points from SQLite to MySQL in xx seconds", then the program should quit.

  • ok guys for who may not know how to do this download the tool unzip it and in the folder make a file with notepad, save it under all types as run.bat, then edit it and copy and paste this line


    java -jar converter.jar "C://Rising World/Worlds/New World" root 123456789 newworld

    Next change the details on the line to yours and save. now its just a matter of clicking on the run.bat file and it should be sweet :-) if you dont have mtsql you can install wamp server its free and includes phpmyadmin witch you can use to make and edit the database


    :thumbsup: Rising Citys @ ip ServerName (Yahgiggles Rising Citys) :thumbsup:

    If at first your code does not work call it version 0.1 with the odd bug :S

    Edited 6 times, last by yahgiggle ().

Participate now!

Don’t have an account yet? Create a new account now and be part of our community!