Module B5 · Data that survives a restart

HeidiSQL, hands on

You already wrote SQL in sql-from-zero and queried from Lua in oxmysql-crud. Those lessons talked to the database through code. This one opens the same database with your own eyes. HeidiSQL is the free GUI that lets you connect to MariaDB, create databases, run a resource's schema file, and stare straight at the rows a script saved. By the end you will open a session, create a fivem database, run a .sql, and watch a players table fill up with the exact data your server wrote.

You'll build: A real fivem database in HeidiSQL, then run a script's .sql and SEE the rows that script wrote in the Data tab.
Time: ~18 minutes
You need: MariaDB or MySQL running and listening on 127.0.0.1:3306 (XAMPP or a standalone MariaDB service started), HeidiSQL installed, and the root password you set during install.
You'll learn: The HeidiSQL panel layout -> opening a local session -> creating a database -> running a .sql two ways -> browsing a table's Data tab to confirm what a script actually saved

BEFORE YOU START

┌──────────────────────────────────────────────────────────────┐ │ File Edit Search Tools Go to Help [menu bar] │ │ [▶ run] [stop] [new query] ... [icon toolbar] │ ├───────────────────┬──────────────────────────────────────────┤ │ LEFT TREE │ CENTER · tabbed workspace │ │ │ ┌───────┬────────┬───────┬───────────┐ │ │ ▼ 127.0.0.1 (root)│ │ Host │Database│ Query │ Data │ │ │ ▼ fivem │ └───────┴────────┴───────┴───────────┘ │ │ ▦ players │ ┌──────────────────────────────────────┐│ │ ▦ vehicles │ │ SQL editor (Query tab) ││ │ ▦ bans │ │ SELECT * FROM players; ││ │ ▶ information_ │ ├──────────────────────────────────────┤│ │ schema │ │ result grid (rows show here) ││ │ │ └──────────────────────────────────────┘│ ├───────────────────┴──────────────────────────────────────────┤ │ SQL log + status bar (last query, row count, timing) │ └──────────────────────────────────────────────────────────────┘

HeidiSQL, hands on

The panel layout

Keep reading the full lesson