2

Previously answered correctly here: https://serverfault.com/a/435443 The answer: Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query results operations” Click “Export” link from the above and you will get the page to export all the results of the queries to desired format. That’s it. Note: The ...


1

Before importing, removing the text /*!50100 TABLESPACE `my_database` */ wherever it appears in the exported MySQL file solves the problem.


1

The warning explains it all. None of the columns you are trying to join are unique which means there is a possible ambiguity in the statement. i.e. JOIN notice_insolvency_practitioners ni ON ni.notice_id = n.id Because the columns aren't unique, there can be more than one identical value for n.id or ni.notice.id (or maybe others, it is impossible ...


1

Have you used the export function? Click the format drop down and select csv [UPDATE] OK, I see what you are after. I have just tested this other way of doing it and it works. Same sort of thing, but at the bottom of your list, select all records and then click export then choose the format. You can test it by first viewing the output as text before ...


Only top voted, non community-wiki answers of a minimum length are eligible