Jobs Sqlite to MySQL

[siOnzee]

27887
Dobrý den, mohu nějak převést Jobs z sqlite na mysql ?

[Machete]

máš to v general.config:

Spoiler: zobrazit

Kód: Vybrat vše

#   The general configuration for the jobs plugin mostly includes how often the plugin
# saves user data (when the user is in the game), the storage method, whether
# to broadcast a message to the server when a user goes up a skill level.
#   It also allows admins to set the maximum number of jobs a player can have at
# any one time.

# storage method, can be MySQL, sqlite, h2
storage-method: MySQL
# Requires Mysql.
mysql-username: gs_37344_1
mysql-password: tvoje heslo
mysql-url: jdbc:mysql://localhost:3306/gs_37344_1
mysql-table-prefix: ''
# How often in minutes you want it to save, 0 disables periodic saving and
# the system will only save on logout
save-period: 10
# Do all players get a message when somone goes up a skill level?
broadcast-on-skill-up: false
# Do all players get a message when somone goes up a level?
broadcast-on-level-up: false
# Maximum number of jobs a player can join.
# Use 0 for no maximum
max-jobs: 3
# option to allow payment to be made when killing mobs from a spawner
enable-pay-near-spawner: false
# option to allow payment to be made in creative mode
enable-pay-creative: false
# Modifys chat to add chat titles.  If you're using a chat manager, you may add the tag {jobs} to your chat format and disable this.
modify-chat: true
# Changes how how many players are paid per payment batch.  Setting this too low or too high may cause tick lag.
economy-batch-size: 10
# Changes how often, in seconds, players are paid out.  Default is 5 seconds.
# Setting this too low may cause tick lag.  Increase this to improve economy performance (at the cost of delays in payment)
economy-batch-delay: 5

samozrejme doplň svoje údaje a máš prepojené jobs s MySQL.

[siOnzee]

Ještě jednou, měl jsem to na sqlite, teď tam mam soubor .sqlite Kde jsou všechny práce.
a ja ty jejich levely a práce chci dostat do MySQL.

[Mysteria]

Tak to si budeš muset stáhnout nějakej program, co dokáže .sq3 soubor otevřít (je to normální databáze) a pak ty data z toho pomocí Insertů vložit do MySQL.