Skip to content

How to export local database

Once connected in CLI on your server hosting your database, run the following commands:

mysqldump -u myuser -p myglpibase(1) > mydump.sql
tar -czf mondump.sql.tar.gz mondump.sql

  1. 🙋‍♀️Change the name of your database

Alternative method: graphical tool (HeidiSQL)

If you are not comfortable with command lines, you can use a graphical tool like HeidiSQL which we recommend here to build your dump.

Follow all the steps in this guide to make sure the dump is complete and well built!

  • Connect HediSQL to your database
  • Once connected to your database, right click on it.
  • Click on Export database to SQL (graphical tool)

Alt text

In the export tool, make sure that only your database is selected.

  • Check Create in Table(s)
  • Choose INSERT in Data
  • Choose .sql file compressed in ZIP in the Destination
  • Name your file
  • Click on Export

Alt text

  • Export via PHPMYADMIN : most of the time, dumps are incomplete, with syntax errors, change undesired variable, etc.
  • Maintenance menu of GLPI : Legacy feature, dumps export is incomplete
  • Powershell : most of the time, dumps is done with non-standard encoding

Last update: 21/03/2023