--=-hSFVT9zxhzSfBmZb8Xf5
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
I use the Quote Field Names function to protect column names such as
'type'
mysqldump -c -Q -u username database > sql_dump.sql
-c is for complete inserts.
Works for me EVERY time!
> --
> Brian Tafoya <btafoya@briantafoya.com>
> brian tafoya dot com
--=-hSFVT9zxhzSfBmZb8Xf5
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.1.7">
</HEAD>
<BODY>
I use the Quote Field Names function to protect column names such as 'type'<BR>
<BR>
mysqldump -c -Q -u username database > sql_dump.sql<BR>
<BR>
-c is for complete inserts.<BR>
<BR>
Works for me EVERY time!
<BLOCKQUOTE TYPE=CITE>
<PRE><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
Brian Tafoya <<A HREF="
mailto:btafoya@briantafoya.com">
btafoya@briantafoya.com</A>><BR>
brian tafoya dot com
</TD>
</TR>
</TABLE>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>
--=-hSFVT9zxhzSfBmZb8Xf5--
(text/plain)