How to connect and export MySQL database
Help Desk Migration allows connecting to a MySQL database and executing a query to retrieve information to create a data source. This article provides basic instructions on the requirements needed to migrate from a database.
How to export MySQL database
1. First, you need to create a read-only database user for this IP address: 18.198.164.195. Follow the steps in the guide to create a read-only user.
2. Go to Migration Wizard and begin the migration. Sign in to your account and click Start new migration. Choose Database from the list, then MySQL.
Note: You can export SQLite only with a Database file for SQLite.
3. To connect the database, enter the following parameters:
- The hostname of the server your helpdesk database is hosted on.
- The port number of your helpdesk database.
- The name of the database in which your helpdesk data is stored.
- The username used in your helpdesk install to log into the database server.
- The password to access the database server.
4. Click Continue and go on with the rest of the steps. If you have any questions, don't hesitate to contact customer support.