mysql problem

Brian Tafoya plug-discuss@lists.plug.phoenix.az.us
15 Jan 2003 15:56:05 -0700


--=-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 &gt; 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 &lt;<A HREF="mailto:btafoya@briantafoya.com">btafoya@briantafoya.com</A>&gt;<BR>
brian tafoya dot com
</TD>
</TR>
</TABLE>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>

--=-hSFVT9zxhzSfBmZb8Xf5--