MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Dave Christensen Date:June 19 2003 7:15pm
Subject:RE: Odd thing
View as plain text  
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:gerald_clark@stripped] 
Sent: Thursday, June 19, 2003 12:19 PM
To: Christensen, Dave
Cc: 'mysql@stripped'
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:DChristensen@stripped]
>Sent: Thursday, June 19, 2003 11:34 AM
>To: 'Jay Blanchard'; Dickey, Dallas; 'mysql@stripped'
>Subject: RE: Odd thing
>Importance: High
>
>
>When I run this script file, I receive errors like this:
>
>[root@bintls3 work]# ./BackupByTable.bat
>mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't 
>exist when doing LOCK TABLES
>
>
>
>-----Original Message-----
>From: Christensen, Dave [mailto:DChristensen@stripped]
>Sent: Thursday, June 19, 2003 10:58 AM
>To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave;
>'mysql@stripped'
>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/mysql?unsub=1
Thread
Odd thingDave Christensen19 Jun
  • Re: Odd thingDon Read19 Jun
RE: Odd thingJay Blanchard19 Jun
RE: Odd thingDave Christensen19 Jun
  • RE: Odd thingMatthew Smith19 Jun
RE: Odd thingJay Blanchard19 Jun
RE: Odd thingDallas Dickey19 Jun
  • selecting PRIMARY KEY when there is no unique valueMojtaba Faridzad19 Jun
    • Re: selecting PRIMARY KEY when there is no unique valueBruce Feist19 Jun
    • Re: selecting PRIMARY KEY when there is no unique valuePaul DuBois19 Jun
    • Re: selecting PRIMARY KEY when there is no unique valueDon Read19 Jun
  • Re: selecting PRIMARY KEY when there is no unique valuePeterWR19 Jun
  • Re: selecting PRIMARY KEY when there is no unique valueMichael Conlen19 Jun
  • Re: selecting PRIMARY KEY when there is no unique valueMojtaba Faridzad19 Jun
  • Re: selecting PRIMARY KEY when there is no unique valueKen Menzel19 Jun
  • how to limit COUNT(*)Mojtaba Faridzad22 Jul
  • Re: how to limit COUNT(*)gerald_clark22 Jul
  • Re: how to limit COUNT(*)Jerry22 Jul
  • Re: how to limit COUNT(*)Mojtaba Faridzad22 Jul
    • Re: how to limit COUNT(*)Fred van Engen22 Jul
  • Re: how to limit COUNT(*)Viorel Dragomir22 Jul
  • Re: how to limit COUNT(*)Mojtaba Faridzad22 Jul
  • Re: how to limit COUNT(*)Yves Goergen22 Jul
    • RE: how to limit COUNT(*)Mike Brum22 Jul
      • Re: how to limit COUNT(*)Mojtaba Faridzad22 Jul
  • Re: how to limit COUNT(*)gerald_clark22 Jul
    • Re: how to limit COUNT(*)Keith C. Ivey22 Jul
  • Re: how to limit COUNT(*)Mojtaba Faridzad22 Jul
    • Re: how to limit COUNT(*)Fred van Engen22 Jul
RE: Odd thingDallas Dickey19 Jun
RE: Odd thingJay Blanchard19 Jun
RE: Odd thingDave Christensen19 Jun
RE: selecting PRIMARY KEY when there is no unique valueMike Hillyer19 Jun
RE: Odd thingDave Christensen19 Jun
RE: Odd thingDave Christensen19 Jun
RE: Odd thingDave Christensen19 Jun
  • Re: Odd thinggerald_clark19 Jun
RE: Odd thingDave Christensen19 Jun