OK thanks for the quick reply.
What about my third question?
Should I change the extension
on the command to .txt instead
Also a quick overview of what I am
trying to accomplish.
My client's site has several forms,
which are all saved to a SQL database.
My client has developed a CRM, which is
also SQL based.
The original plan was for the data that was
entered into the site SQL database, can be
imported into the CRM database, and have
tasks and triggers assigned to them there.
As I mentioned earlier, the SQL dumps were
working fine, but the person developing the CRM
had a problem with the SQL format.
Here is his email to me:
Hence, my request to have the data exported to a CSV format.
But according to andrew, the resulting .txt file cannot be restored into a MySQL database
Once I get clarity on the .sql vs. .txt extension in the command, I will do a test run and see
if --fields-terminated-by is the solution we are looking for.
Thanks again for the speedy reply. Much appreciated!