I am new to HeidiSQL. I have been satisfied with DBManager Pro, until I find out they have no fix for Win 10. I like what I see with HeidiSQL, I've read good reviews from current users.
I am playing around with the software and trying to setup a test database using a table from an existing DB. To setup the test db I created an SQL dump file of one of the small tables then changed the db name in the SQL script file to 'test db' which I created using HeidiSQL. I then went into the empty test db table clicked the SQL tab and loaded the SQL file. I made sure the SQL results pane was clear, then selected Run on the popup menu.
I got a message box saying that I had multiple errors (2,3 or 6) and the table never got created. I have both the create options chosen when I created the SQL export file.
Nowhere can I find a listing of the errors. If I could find a list I could probably troubleshoot this myself. I see no errors listed in the SQL pane.
I have attached the SQL file that was created.
Thanks for your help. So far I like what I have seen. This export/import technique is critical for how I do backups.