[Rebuild] setup SQLite on server

[z0h1r-LK]

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.

• 

---

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?

• Code: [Select all] [Expand/Collapse]

  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"

  GeSHi © Syntax Highlighter

• Change only this settings :

• Code: [Select all] [Expand/Collapse]

  1. amx_sql_type    "sqlite"

  GeSHi © Syntax Highlighter

• 

---

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

• 

• 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.