dbareis
New member
I may be doing something wrong but I am using "MyPhpAdmin" to dump a table (in this case) with "show create table `sale`;". I'm wanting to backup important definitions. Is there a better way to easily and quickly back up the definitions excluding table data?
I then use "Copy to clipboard" and the output includes xA0 (no breaking space) characters in some places where there are multiple spaces (such as but not restricted to indents). I've attached an example. You won't see them in notepad (Windows), but notepad++ shows them.
The characters cause the SQL to fail and generate all sorts of random unexpected errors. If it was going to generate them, you'd think it would be smart enough to handle them in the SQL queries.
I then use "Copy to clipboard" and the output includes xA0 (no breaking space) characters in some places where there are multiple spaces (such as but not restricted to indents). I've attached an example. You won't see them in notepad (Windows), but notepad++ shows them.
The characters cause the SQL to fail and generate all sorts of random unexpected errors. If it was going to generate them, you'd think it would be smart enough to handle them in the SQL queries.
