[Bug Report] - problem with exporting database with view included

karel.horsky's profile image karel.horsky posted 8 years ago in General Permalink

HeidiSQL portable v9.3.0.5049 (32bit)

I tried to export one database from production server (MySQL 5.5.44) to my machine (MySQL 5.5.22). Simply by clicking right mouse button on selected database and export it directly to another connection. I've chosen to create the database on target machine.

Database was successfully exported, but when tried to open it in heidi on my machine, strange thing happen - I could see the database (its name), but no tables in it. Database size: 0.

I've tryied another tool (adminer), and I could see the all the tables. More, I could connect to database from my script and work with it.

When I tryied it more times, I found out, that I have defined a view in database. When I exclude it from export, everything works fine.

Finally I found a message in the message window, that could be related.

I'm not sure what kind of information could I provide to help solving this bug. Feel free to ask for more, I'll try to help...

1 attachment(s):
ansgar's profile image ansgar posted 8 years ago Permalink

You could post a screenshot of the export dialog with all relevant settings you used to create your database export.

karel.horsky's profile image karel.horsky posted 8 years ago Permalink

Here you go.

1 attachment(s):
  • bug-heidi-2
karel.horsky's profile image karel.horsky posted 8 years ago Permalink

I also tried to create new test database with one table and one view. This was exported without errors.

Strange...

ansgar's profile image ansgar posted 8 years ago Permalink

And which tables were checked? You did not include the left tree in your screenie.

karel.horsky's profile image karel.horsky posted 8 years ago Permalink

All tables, all views from selected database.

karel.horsky's profile image karel.horsky posted 8 years ago Permalink

I'm still trying to figure out, what's the minimal needed setup to get this error. Now I have:

  • two tables
  • view, that combines data from these two tables

When I try to export these three objects, I'm in trouble. I've found another lead. When I export the objects, click on the database on target machine and hit refresh, I get an error:

/ SQL error (1143): SELECT command denied to user ''@'%' for column 'nomination_id' in table 'nomination' /

"nomination" is one of the tables, "nomination_id" one of its fields.

Please login to leave a reply, or register at first.