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.

Right-Mouse-Klick on Tabel 'Create new' - 'Table Copy' looses Rows

Manfred.P's profile image Manfred.P posted 2 weeks ago in General Permalink

Hi, saving a Table using "Table copy" shows less Data then available. It's very unpleasant when its used for Backup purposes.

Your's

Manfred

1 attachment(s):
  • 2019.11.05_09h30m33s_002_
Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

missing

Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

missed on my Post

1 attachment(s):
  • 2019.11.05_09h28m48s_001_
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.
ansgar's profile image ansgar posted 2 weeks ago Permalink

If that was an InnoDB table, then this is most likely due to the server sided row count estimation. The rows should all be there, please check that by running a more exact query like SELECT COUNT(*) FROM xyz_copy, rather than relying on that approximate value.

Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

I Know there is a differnce. I check the Number regularly. Former where ~20000 Roes more.

ansgar's profile image ansgar posted 2 weeks ago Permalink

So, how did you check that number of rows?

Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

select count(*) from gh

3 attachment(s):
  • 2019.11.06_08h37m53s_001_
  • 2019.11.06_08h38m36s_002_
  • 2019.11.06_08h40m12s_003_
ansgar's profile image ansgar posted 2 weeks ago Permalink

Again, your second and third screenshot both show the estimated row count, not the exact number of rows in your table. Don't compare these with the exact result of SELECT COUNT(*)....

You need to run that SELECT COUNT(*)... on both tables and compare the results.

Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

it is the same table

ansgar's profile image ansgar posted 2 weeks ago Permalink

You copied one table to the same table name? That's not possible with that dialog.

Manfred.P's profile image Manfred.P posted 2 weeks ago Permalink

I make a Backup if a table

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