XF 2.2 Exporting and Importing DB

[Gleedo]

Hi all, welcome to yet another export/import thread!

I am trying to migrate to a new host and I have backed up my live database using phpMyAdmin > Export > Quick export method and then renamed the SQL dump to mydb.sql.zip.

In phpMyAdmin on the new host, I have created the database, selected it, and then in Import, I have selected my .sql.zip file and then clicked 'GO'. On that import page, I changed no other options.

Now, after import, I have gone and compared the xf_post table from both databases. The current live one seems to report that the last post id is 70466 but on the new database, the last post id is 75244.

How can that be?

Any thoughts appreciated

 

[M@rc]

How can that be?

Is phpMyAdmin your only method of importing/exporting?
Did you compare the database size when backing it up to what's on the actual server?

Sounds like phpMyAdmin could be the issue.