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

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

missing

missed on my Post

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.

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

So, how did you check that number of rows?

select count(*) from gh

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.

it is the same table

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

I make a Backup if a table