Export local database
Last updated
Was this helpful?
Last updated
Was this helpful?
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
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)
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
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
