[Rebuild] setup SQLite on server

Helping Topics
Post Reply
User avatar
z0h1r-LK
Mod Developer
Mod Developer
Morocco
Posts: 520
Joined: 5 years ago
Location: The Red City ❤
Contact:

[Rebuild] setup SQLite on server

#1

Post by z0h1r-LK » 3 weeks ago

Setup SQLite 🪶

Step #1 - We need to enable sqlite on file modules.ini first :

  • Edit file addons/amxmodx/configs/modules.ini with text editor (ex: notepad).

  • Delete semi-colon ; to enable module.

  • Image


Step #2 - Assigning the name for the file .sq3 :

  • Edit file addons/amxmodx/configs/sql.cfg via text editor again.

  • Default settings that you will find in the file sql.cfg?

    1. amx_sql_host    "127.0.0.1"
    2. amx_sql_user    "root"
    3. amx_sql_pass    ""
    4. amx_sql_db      "amx"
    5. amx_sql_table   "admins"
    6. amx_sql_type    "mysql"
    7. amx_sql_timeout "60"
  • Change only this settings :

  • Image


Step #3 - Turn on server and save first data on sq3 file :

  • A directory named sqlite will appear and contains the file name dbname.sq3, for example: amx.sq3

  • Image

  • About dbname.sq3, You can make backup copies by downloading from your server to your computer. Easy 😀


NOTE : You can download a program to view, change, and delete data through a program DB Browser (SQLite)
WARNING : Don't open file dbname.sq3 in a real-time server where data is load or save.


Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Who is online

Users browsing this forum: No registered users and 1 guest