I'm quite new to the process of importing/exporting databases. I'm using Maria DB, and HeidiSQL to run queries, etc.
I exported an entire database from our dev server, and loaded it into our live server. The script ran without a hitch. No errors, everything appeared to go as planned.
However, when I open two instances of HeidiSQL and compare the details of the tables side by side there are some weird looking discrepancies.
For example, in some cases tables on the newly migrated version say they have more data than the database they were exported from. How is this possible? does HeidiSQL just 'estimate' the amount of rows?
For example, according to HeidiSQL table 1 on the dev server contains 177 rows of data, with a total size of 64.0 KiB.
Where as the same table 1 on the live database contains 219 rows of data, with a total size of 64.0 KiB.
Even more weird, table 2 contains 2,254,576 rows of data, with a total of 232.9 MiB, while the same table on the live database contains 2,334,922 with a total of 224.0 MiB. There are also tables showing less data on the live database version than on the dev database version.
Why is this?
The SQL file creates the copy of the database from scratch on the live database server, it didn't delete or overwrite an older version or anything, and there were no errors on completion.
If I run
SELECT COUNT(*) FROM table_2 both databases return 2,326,087 rows.
So it appears to be an issue with displaying the correct count in HeidiSQL.