-
2026 staff recruitment is open! Check it out and consider applying!
Needing someone that knows the basic well.
- Thread starter Maladie
- Start date
Solution
You should post what you need help with in Support board and then members will try to help you, Helping through PMs isn't useful since it won't benefit other members or people who have same issues.
I still have same issue, making a new database, everything doesnt come out right. You've sent me "how to make a database tutorial" but im getting errors,
What I need right now is, either a new database, or a housewipe.
Im still using my 9.70 database which seem to work fine but i downgraded to 8.60, i left some 9.70 items in certain houses as reminders so now what i get are debugs due to that.
Post automatically merged:
Tried to make a new database, the final "folder" is .sql/mysql, shouldnt it be s3db?
Lessaire
Omniscient Hypervisor
If the server distro you are using is expecting a MySQL / MariaDB server to be present, then no, S3DB would have nothing to do with it.
You'd login direct to the MySQL via the command line as the database root user, create your service user and set password and permissions, create the database, and then kill the command line. That might look like:
Then you'd import the schema file with a command something like this:
mysql --user %serviceuser% -p%serviceuserpassword% db_name < script.sql >./database.log
You'd then wipe your shell history. After that you might think about getting the MySQL Workbench. You'd connect to your database from the workbench over SSH Turnnel. And you'd have SSH being authenticated using RSA keys and passwords would be disabled.
However, if you were born anally, like lawyers and politicians are, you'd probably do none of that and install something like phpMyAdmin.
You'd login direct to the MySQL via the command line as the database root user, create your service user and set password and permissions, create the database, and then kill the command line. That might look like:
SQL:
GRANT USAGE ON *.* TO forgottenserver@localhost IDENTIFIED BY 'super_secure_password';
GRANT ALL PRIVILEGES ON forgottenserver.* TO forgottenserver@localhost;
CREATE DATABASE forgottenserver;
QUIT;Then you'd import the schema file with a command something like this:
mysql --user %serviceuser% -p%serviceuserpassword% db_name < script.sql >./database.log
You'd then wipe your shell history. After that you might think about getting the MySQL Workbench. You'd connect to your database from the workbench over SSH Turnnel. And you'd have SSH being authenticated using RSA keys and passwords would be disabled.
However, if you were born anally, like lawyers and politicians are, you'd probably do none of that and install something like phpMyAdmin.
Last edited:
This is past my knowledge to be honest. Every distro i been trying had there database already inside, [s3db].
works fine with Sqlite studio.
Im using 0.3.7_SVN (Crying Damson), i was using Xammp as database maker. I Imported schema.sql -> Exported Test123.sql -> set config data to forgottenserver.s3db to Test123.sql, console error Use the lastest database.
works fine with Sqlite studio.
Im using 0.3.7_SVN (Crying Damson), i was using Xammp as database maker. I Imported schema.sql -> Exported Test123.sql -> set config data to forgottenserver.s3db to Test123.sql, console error Use the lastest database.
Lessaire
Omniscient Hypervisor
Websearch said:
You definitely have should have access to MySQL if you have XAMMP. Should be pretty simple.
Post automatically merged:
To be honest, the innate closeness of the shell that Unices have is something Windows can never hope to achieve. Powershell is a joke. You should see the amount of code it takes just to emulate ping.
However, cmder is a decent band-aid. I suggest you avail yourself of it, explicitly the full version with the Git tools.
Also, you can use Workbench with your XAMPP.
Last edited: