Re: Odd thing

[gerald_clark]

Christensen, Dave wrote:

Oops!  Sorry.  Deleted that 'temp' table and didn't remove it from my script
file.
-----Original Message-----
From: Christensen, Dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 19, 2003 11:34 AM
To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]'
Subject: RE: Odd thing
Importance: High

When I run this script file, I receive errors like this:

[EMAIL PROTECTED] work]# ./BackupByTable.bat
mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist
when doing LOCK TABLES


-----Original Message-----
From: Christensen, Dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 19, 2003 10:58 AM
To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave;
'[EMAIL PROTECTED]'
Subject: RE: Odd thing

I've also tried creating the script manually (script follows) and all that's
being created is a text header with nothing else in the file.  At least in
these instances we can use the text files..... Just be nice if they were
valid... :-)
----------------------->  Here's the script

mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
MissedPages  -uroot -ppano4577 >  MissedPages.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_APP_INFO -uroot -ppano4577 >  UCS_APP_INFO.sql   
 

You have options after the tables.
All options should precede the database and tables.
mysqldump --add-drop-table --compatible-mysql323 --disable-keys -uroot 
-ppano4577 AgentAdminDB MissedPages > MissedPages.sql



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]