In this new window (Figure E), click the Browse button and then locate the .sql backup file you downloaded from the export. Figure E. Restoring a MySQL database using the phpMyAdmin import tool.

Import and export¶. In addition to the standard Import and Export tab, you can also import an SQL file directly by dragging and dropping it from your local file manager to the phpMyAdmin interface in ...

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.