Gerald, That may be a preference, but the scripts typically run on the LINUX command line just fine in the form that we've entered. We've been entering them in that manner for months with no operational issues.
Thanks for the input though. Have a great day! Dave -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:19 PM To: Christensen, Dave Cc: '[EMAIL PROTECTED]' Subject: Re: Odd thing 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
