MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:June 19 2003 5:19pm
Subject:Re: Odd thing
View as plain text  

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


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