In MySQL it is very easy to export data. The command syntax is self-explanatory.
For the export one proceeds as follows:
mysqldump -u root -p DATEBASE_NAME > export.sql
- root – username, of course you can use another username like e.g. the database owner.
- DATEBASE_NAME – The database to export.
- export.sql – The name of the file into which the data is written can be freely chosen, also the extension sql is not obligatory.