How I get one SQL archive
- Thread starter Garek
- Start date
You can follow this tutorial how to setup MySQL.
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/
For SQLite.
https://otland.net/threads/sqlite-accessing-and-modifying-the-database.189738/
You can also use SQLite Manager (Firefox add-ons).
If you're looking for the sql files for your server, they should be there where you downloaded the server.
If you use older server versions, the .s3bd file is for SQLite.
The .sql file if for MySQL, in TFS 0.3/0.4 it's called mysql.sql and it's in the folder schemas.
TFS 1.x servers only use MySQL, the file you need to import is called schema.sql.
If you didn't find any sql files for your server, you can always use one from a similar server version.
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/
For SQLite.
https://otland.net/threads/sqlite-accessing-and-modifying-the-database.189738/
You can also use SQLite Manager (Firefox add-ons).
If you're looking for the sql files for your server, they should be there where you downloaded the server.
If you use older server versions, the .s3bd file is for SQLite.
The .sql file if for MySQL, in TFS 0.3/0.4 it's called mysql.sql and it's in the folder schemas.
TFS 1.x servers only use MySQL, the file you need to import is called schema.sql.
If you didn't find any sql files for your server, you can always use one from a similar server version.
Last edited:
You can use SQLite with a website, but not all website AAC makers support this, so it would be more easy to use MySQL then.
For the website you can use XAMPP or Uniform Server (like in the tutorial). SQLite or MySQL is just for the server database.
For the website you can use XAMPP or Uniform Server (like in the tutorial). SQLite or MySQL is just for the server database.
