0

I am using MySQL 5.6.44 within phpMyAdmin on Go Daddy shared hosting and experimenting with some duplicate table data.

I am trying to figure out, when I export my table from phpMyAdmin the exported sql file structure when opened does not match the schema seen in the admin panel. By that I mean the row sequence in the sql file are jumbled up.

I don't have any foreign key constraints set up or any other operations on the table.

Any steering and knowledge as to why this might be the case would be appreciated.

enter image description here

stack rookie
  • 99
  • 2

1 Answers1

-1

The issue disappeared when I changed the engine from MyISAM to InnoDB. I understand that InnoDB has row locking.

stack rookie
  • 99
  • 2