mismatch between server schema content and exported sql rows

Question

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.

If you want an order on your data, you need to use an order by clause. An SQL database makes no guarantees about the order the data is stored or returned. — Colin 't Hart, Jan 17 '20 at 12:02
appreciate the notes but what resolved the issue as mentioned was changing the engine as I mentioned from MyISAM to InnoDB. — stack rookie, Jan 17 '20 at 18:15
Those rows are sorted as strings, not numbers. What process generated them? — Rick James, Jan 20 '20 at 05:14

stack rookie · Answer 1 · 2020-01-17T19:12:12.110

-1

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

edited Jan 17 '20 at 19:12

answered Jan 15 '20 at 21:50

stack rookie

99
2

What does the row order have to do with locking? – mustaccio Jan 17 '20 at 19:19
My solution works, appreciate the down vote. – stack rookie Jan 17 '20 at 20:11
You might find this Q&A useful. – mustaccio Jan 17 '20 at 20:18
I suspect it was coincidence that led to it "working". – Rick James Jan 20 '20 at 05:14

mismatch between server schema content and exported sql rows

1 Answers1