Recent Discussions
Transferring CoreProtect database.db to a MySQL database
Open in DiscordUnanswered
Phillapple posted this in #questions
47 messages
6 views
How would i go about doing that? Assume I have no programming knowledge. the host provides the database, I just need to transfer the data to the new format. I have python and visual studio installed on my home computer.
I also have WinSCP as my SFTP client if that is helpful
The database on the disk is 104 gb currently, so i can understand if some downtime is necessary, but I'd prefer a solution that requires minimal downtime (it's not a super busy server, but there are players on every day).
I say "assume i have no programming knowledge", not because I have none, but because it is very limited (some high school classes)
Coreportect
I'm cooked
fixed
Key West Quail-Dove
I'd try dumping it as sql and importing it into mysql and see if/where it errors out
@PM_ME_YOUR_REPO You using H2 or SQLite right now?
how would i find that out
the config is only telling me i'm not using mysql
I don't think it has been changed from the default
@Phillapple the config is only telling me i'm not using mysql
Does the config just say "using mysql: no" or something?
yea
lmao, paste that section and the lines around it here
uhhh
or screenshot or phone picture
whatever
OH RIGHT LOL
one sec
i can just paste the lines censored
yeah, that's fine
# MySQL is optional and not required.
# If you prefer to use MySQL, enable the following and fill out the fields.
use-mysql: false
table-prefix: co_
mysql-host: mysql.ethera.net
mysql-port: 3306
mysql-database: database
mysql-username: ***
mysql-password: ***nothing else in the config has to do with the format
damn, that's useless lmao. lemme figure out wtf its using
Loading...
Loading...