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.

Export function to databasesql is error due to large table amount. Is there a solution?

wetgw@yopmail.com's profile image wetgw@yopmail.com posted 2 months ago in General Permalink
  • Export function to databasesql is error due to large table amount. Is there a solution?
ansgar's profile image ansgar posted 2 months ago Permalink

What error do you get? There should not be any limitation due the number of tables.

wetgw@yopmail.com's profile image wetgw@yopmail.com posted 2 months ago Permalink

What error do you get? There should not be any limitation due the number of tables.

=>thank you very much .

Sql was opened when exporting data in line 2,392,094 and when exporting grid row 2,392,094 are displayed on screen, even if you wait for 30 minutes, or an error called sql was opened occurs when exporting. Do you have a solution?

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.
wetgw@yopmail.com's profile image wetgw@yopmail.com posted 2 months ago Permalink

SQL Error(0) Object Already Open

ansgar's profile image ansgar posted 2 months ago Permalink

Please post a screenshot. I am not able to understand what you were exactly doing when that happened.

wetgw@yopmail.com's profile image wetgw@yopmail.com posted 2 months ago Permalink

Please check the screen shot.

1 attachment(s):
  • 20200220_103423
wetgw@yopmail.com's profile image wetgw@yopmail.com posted 2 months ago Permalink

SQL Error(0) Object Already Open

ansgar's profile image ansgar posted 2 months ago Permalink

Ok, so you're using the SQL export dialog to export structure and data, and you while doing that, the first table returns that error.

What's the server version here?

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