Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

exporting db as SQL

swedev's profile image swedev posted 4 years ago in HeidiSQL portable Permalink

HeidiSQL Portable: 9.4.0.5125

Trying to export a db, but its showing me that the selected object size is 0B. Even though I have complete access to the data and is able manipulate in any way I want.

Screenshot attached.

Has anyone else stumbled upon this issue?

Thank you

1 attachment(s):
  • sql
swedev's profile image swedev posted 4 years ago Permalink

Also, I forget to mention, when I go ahead and export it, there is no data in the SQL file. Only queries to build the tables if they don't exist.

gacuxz's profile image gacuxz posted 4 years ago Permalink

May it be because your database is empty - I see 0B also in right panel where the database list is...

swedev's profile image swedev posted 4 years ago Permalink

May it be because your database is empty - I see 0B also in right panel where the database list is...

Yes I saw that as well! No it's absolutely not empty I have almost 2 million entries there. And I can see them through Heidi in the data tab!

kalvaro's profile image kalvaro posted 4 years ago Permalink

SQL Server support is in general rather incomplete. I'd only rely on HeidiSQL for simple stuff such as inspecting table data and running SQL code. In any case, you can enable all log events in Tools/ Preferences/ Logging and try to figure out what HeidiSQL is trying to do. Perhaps there's a very specific column type that it can handle correctly.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.