Solved Changing SQLite to MySql

Discussion in 'Bukkit Help' started by MrTomTomHD, Dec 23, 2013.

Thread Status:
Not open for further replies.
  1. Offline

    MrTomTomHD

    Well basically, on the plugin ScoreboardStats the sql.yml is setup for Sqlite and i was wondering how to change it to MySQL, i've seen people do it, i just need help D:

    sql.yml
    Code:
    SQL-Settings:
      Username: bukkit
      Password: walrus
      Isolation: SERIALIZABLE
      Driver: org.sqlite.JDBC
      Url: jdbc:sqlite:{DIR}{NAME}.db
      MinConnections: 2
      MaxConnections: 250
      Timeout: 1000
    
    I need to add in:
    Host
    Database Name
    Username
    Password

    Can anyone who has experience please help, it is urgent!
     
  2. if your server is hosted, you'll need to get this info from them, otherwise, you'll need to go about setting up a MySQL server. if its the latter, post back and ill give you a hand with it
     
  3. Offline

    MrTomTomHD


    I have the
    Host
    Database Name
    Username
    Password

    I just need to know where to put it on the sql.yml

    Because the information is setup for SQLite
     
  4. Offline

    seriosbrad

    Try this

    Code:
    SQL-Settings:
      Username: REPLACE_WITH_USERNAME
      Password: REPLACE_WITH_PASSWORD
      Isolation: SERIALIZABLE
      Driver: com.mysql.jdbc.Driver
      Url: jdbc:mysql://REPLACE_WITH_MYSQL_SERVER_IP:3306/REPLACE_WITH_DATABASE_NAME
      MinConnections: 2
      MaxConnections: 250
      Timeout: 100
     
  5. Offline

    MrTomTomHD


    Thankyou so much :)
     
    seriosbrad likes this.
Thread Status:
Not open for further replies.

Share This Page