Now you'll see the MySQL Destination form. Enter your MySQL database connection information:
- Server host name / IP address where MySQL is running
- Port number — usually 3306
- Character set of the target database
- Username and password
Since MySQL is running on our local machine, we'll choose the default "localhost" as the server hostname and the default port. After entering the required information, click Connect — you'll get a "Connected Successfully" message:
If you have trouble connecting to MySQL, see the common connection problems and how to resolve them. Still having issues? Feel free to contact us — we're happy to help.
Now select the target database from the dropdown list. Since we already created the target database "NorthWind" earlier, we'll choose the same.
Data Loader also lets you load data using the Bulk Loading method in MySQL, which loads millions of rows in just a few minutes — check "Use MySQL Bulk Loader" to enable it.
You can also disable foreign key checking, useful for avoiding "Parent Value doesn't exist" errors when child table rows get populated before parent table rows are loaded. When you check "Disable Foreign Key Checking", Data Loader turns off foreign key checking just before loading starts and turns it back on after loading finishes.
Click Next to continue.