---
last_review: "2025-01-01"
last_reviewer: "-"
documented_code: [ ]
---

```{tags} how-to, administrator
```

# Upgrading SQL Backups #

Some LinkAhead releases which upgrade the SQL backend may introduce incompatibilities with stored
SQL dump backup files. For these cases, the backend repository provides upgrade scripts which must
be called on the SQL dump before restoring data from the dump.

For detailed information, please read the file `dump_updates/README.md` in the
[SQL backend repository](https://gitlab.com/linkahead/linkahead-mariadbbackend).

## Known upgrade problems and solutions ##

These are the known problems and their solutions for specific LinkAhead releases:

- **0.15.0**: This release updates the backend to MariaDB 10.11 which introduces a new keyword. To
  fix your SQL dumps run  
  `2024-10-02.dump_fix_mariadb_10_6.sh < yourdump.sql > yourdump.fixed.sql`