How to import SQL to database?

Some scripts ship .sql files, for example sql/items_esx.sql in aps_cityhall. Run them on the same database your server uses.

Your server’s database is the one named in mysql_connection_string in your server.cfg. Import into that database, not a different one.

HeidiSQL
phpMyAdmin
Command line

Open HeidiSQL and connect to your database server.
Click your server’s database in the left panel.
Click File → Run SQL file… and select the .sql file.
Confirm, and wait until the query finishes.
Press F5 to refresh and check that the new tables or rows are there.

Open phpMyAdmin and log in.
Click your server’s database in the left panel.
Open the Import tab.
Click Choose File and select the .sql file.
Click Import (or Go) at the bottom of the page.

mysql -u <user> -p <database> < path/to/file.sql

Replace <user> and <database> with the values from your connection string. You are asked for the password.

You can also open a new query window, paste the contents of the .sql file and run it. This works in HeidiSQL, phpMyAdmin (SQL tab) and the txAdmin database tab.

Make a backup of your database before you import, especially when a file changes or drops existing tables.

Restart the script (or the server) after the import.

Home

Helpful

Assets

How to import SQL to database?