Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

Preconditions HeidiSQL version: 12.8.0.6913 Database type and version: MariaDB 10.11.7 OS: Windows 10 Pro Describe the bug I tried to import from SQL file but it stops importing after 100-200 lines ...

When exporting databases as SQL files, HeidiSQL inserts the following line at the beginning of the SQL file which causes MySQL to issue warnings. /*!40101 SET NAMES utf8 */; The warning that is issued ...