Export local database

Recommended method : via CLI

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

mysqldump -u myuser -p > mydump.sql tar -czf mondump.sql.tar.gz mondump.sql

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

Not recommended

• 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