Yes — you can use Data Loader to easily load data from any database into a MySQL database hosted on shared web hosting. To do this, first log on to CPanel and click Remote MySQL in the Databases section.
Enter your IP address in the Host box and click Add Host, as shown below:
In older CPanel versions you'll see a screen similar to this:
To find your IP address, visit whatismyip.com. Once your IP is added, start Data Loader, type your domain name (e.g. dbload.com), your user account and password, then click Connect.
Yes — you can run saved sessions by issuing an operating system command. Call the Data Loader runtime with the following arguments:
DLRUN.exe <session_id> [showoutput]
Where session_id is the ID of the session you want to execute, and showoutput is optional — if specified, Data Loader will show an output window.
For example, if you saved a session with ID 15, run it with:
C:\Program Files\Data Loader Standard Edition\DLRun.exe 15 showoutput
Replace C:\Program Files\Data Loader Standard Edition with the directory where you installed Data Loader.
Yes — you can load data from Oracle or MySQL running on another OS. You must have the proper client software installed on the machine running Data Loader.
Yes — you can use Data Loader to convert delimited text files to another delimited text file or fixed-length format. You can even filter columns and specify WHERE conditions while converting.
Yes — you can use Data Loader to load data from one Oracle version to another Oracle version.
No — Data Loader can load millions of rows, and many of our existing customers do exactly that. The trial version is limited to 50 rows. Purchasing a registered version removes this restriction.
Yes — you can filter rows while loading from MySQL, Oracle, MS Access, MS SQL Server, or FoxPro to any other target database or text file.
You should have Microsoft Data Access Components (MDAC) version 2.0 or later installed. From Windows 2000 onward this is installed automatically. If you're running Windows 98 or 95, please install MDAC before running Data Loader — you can download it from the Microsoft website.
Go to Control Panel → Administrative Tools. If you see the ODBC Manager, MDAC is installed; otherwise it is not.
This restriction applies to the Trial Version of Data Loader. To remove it, please purchase a registered version.
Yes — from version 2.0 onward, Data Loader includes its own scheduler. Create a session, specify the schedule time, and Data Loader will execute the conversion job automatically at the specified times.
Data Loader currently supports loading to and from MS SQL Server, MySQL, Oracle, MS Access, FoxPro, and text formats.
Yes, by using views. For example, if you want to load columns from multiple joined tables into another database, first create a joined view in your Oracle or MS SQL Server database, then start Data Loader, select this view as the source, and load it into any supported database.
Yes — from Data Loader version 2.5 onward, you can load from multiple text files simultaneously. Even if you have different delimited files in one folder, you can select these files and load them into any supported database.
Yes — from Data Loader version 2.5 onward, you can specify a WHERE condition to filter rows while loading from delimited text files to any other supported database.
This usually happens because of a firewall. If you have firewall software installed, it may prevent Data Loader from connecting to your MySQL server. Please allow Data Loader access by adjusting your firewall settings.
This happens if you select a worksheet or range containing more than 255 columns — the Microsoft Excel driver supports only 255 columns. Even if the worksheet appears to have fewer than 255 columns, make sure columns that seem empty aren't filled with spaces or non-printable characters.
This occurs if the Excel worksheet doesn't contain proper ranges, or the MS Excel driver can't correctly interpret the rows and columns. This can be avoided by defining named ranges in the worksheet:
To define a named range in Microsoft Excel:
- In your Excel worksheet, select the rows and columns containing the data you want to import.
- On the Insert menu, point to Name, then click Define.
- In the Names In Workbook box, type a name (no spaces, and not the same as a column header) for the range, then click Add.
- Click OK, then on the File menu click Save.
- Save and close the workbook.
This happens when an Excel column contains mixed data — numeric values mixed with text in the same column. Both the Jet and ODBC providers return data of the majority type and NULL for the minority type. This is a known limitation of the Microsoft Excel ODBC driver and OLE DB provider. See Microsoft KB 257819 for details.
There is a simple fix:
- On the Start menu, click Run. Type
regeditand click OK. - In the Registry Editor, expand:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel - Select TypeGuessRows and on the Edit menu click Modify.
- In the Edit DWORD Value dialog, click Decimal under Base. Type a value between 0 and 16 for Value data, then click OK and close the Registry Editor.
When this value is set to zero, Excel scans all records in your table to determine each column's data type. After setting the registry value, transfer the data again.
All Windows platforms are supported, including Windows 7 and Windows Vista.
Please make sure the target table has a primary key index on the matching column. If no index exists, processing becomes slow because Data Loader has to compare every record for existence.
Yes — Data Loader runs on 64-bit Windows and can connect to 64-bit databases, but you'll need to install the 32-bit OLE DB provider or 32-bit ODBC driver to access them.
This error is usually caused by a permissions issue or a missing Data Loader repository database (DLRepo.sdf).
It commonly happens if you uninstall the Trial Edition after installing the Full Version — if this is the case, please uninstall and reinstall the full version.
If you haven't uninstalled the Trial Edition, make sure DLRepo.sdf is located in the %localappdata%\Interface Computers folder (type %localappdata% in Windows Explorer to get there). If the file isn't there, reinstall Data Loader.
If the file is present, check that you have sufficient read/write permission on the folder. If the problem persists, try reinstalling Data Loader again as a user with admin privileges after uninstalling the previous version.
This error occurs when the Bulk Loading feature is disabled on your MySQL server. To avoid it, do one of the following:
1. Uncheck Bulk Loading in the MySQL Destination screen in Data Loader, as shown below:
OR
2. If you want to use the Bulk Load method, enable Bulk Loading on your MySQL server by setting local-infile=1 in the [mysql] and [mysqld] sections of your my.cnf file, then restart the MySQL server.