Begin by familiarizing yourself with the Freshsales API documentation. Identify the endpoints relevant to the data you want to transfer. Ensure you understand how Freshsales structures its data, including any entities, fields, and relationships.

Log into your Freshsales account and navigate to the API settings. Generate an API key, which will be used to authenticate your requests. Store this key securely, as it will be needed to access the data.

Install MySQL on your server or use an existing MySQL instance. Create a new database and tables that match the structure of the data you intend to import from Freshsales. Define the schema based on the Freshsales data model to ensure compatibility.

Develop a script using a programming language like Python, PHP, or Node.js. Use the Freshsales API to make HTTP GET requests to the relevant endpoints. Parse the JSON response to extract the required data fields. Ensure to handle pagination if the data size exceeds the API’s limit per request.

Transform the extracted data into a format that matches the MySQL table schema. This may involve data type conversion, formatting dates, or handling null values. Ensure the integrity and cleanliness of the data before loading it into MySQL.

Use a database connector library (such as `mysql-connector` for Python) to connect to your MySQL database. Develop a script to insert the transformed data into the corresponding tables. Use SQL `INSERT` statements, and if necessary, handle duplicate entries using `INSERT IGNORE` or `ON DUPLICATE KEY UPDATE`.

To keep your MySQL database updated, automate the data extraction and insertion process using a scheduler (like cron jobs on Linux or Task Scheduler on Windows). Ensure the script is robust, handles errors gracefully, and logs its operations for monitoring purposes.

By following these steps, you can efficiently move data from Freshsales to a MySQL database without relying on third-party connectors or integrations.