---
title: "Import Script for MySQL Database"
lang: "en"
slug: "import-script-for-mysql-database"
date: "2019-04-26"
category: "work-done"
featured_image: "/assets/img/Mysql.jpg"
tech:
  - "MySQL"
---

[Østjyllands Brandvæsen](https://www.ostbv.dk/) maintains a MySQL database that they update on a regular basis. Allegro IT ApS built a standardised import script for this database so routine updates can be carried out without developer involvement every time.

The solution is delivered as a SQL file that is opened in MySQL Workbench and executed. That means a staff member with basic technical background can run the import themselves when new data comes in — without having to file a ticket with us, and without the risk that ad-hoc, manually written SQL statements break existing records.

It's a small but practical solution: no application to host, no dependencies to maintain, and nothing that can break at the next OS or browser update. Just a file that does its job and can be stored alongside the rest of the organisation's documentation.