MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Dave Christensen Date:June 19 2003 4:46pm
Subject:RE: Odd thing
View as plain text  
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   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_AUDIT -uroot -ppano4577 >  UCS_AUDIT.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_COMPS -uroot -ppano4577 >  UCS_COMPS.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_FORMS -uroot -ppano4577 >  UCS_FORMS.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_HISTORY  -uroot -ppano4577 >  UCS_HISTORY.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_LOGIN_TRACE -uroot -ppano4577 >  UCS_LOGIN_TRACE.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_PACCESS  -uroot -ppano4577 >  UCS_PACCESS.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_PROFILES -uroot -ppano4577 >  UCS_PROFILES.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_UACCESS  -uroot -ppano4577 >  UCS_UACCESS.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_USERINFO -uroot -ppano4577 >  UCS_USERINFO.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
UCS_USERS -uroot -ppano4577 >  UCS_USERS.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
activitylookup  -uroot -ppano4577 >  activitylookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agencies  -uroot -ppano4577 >  agencies.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agentdocuments  -uroot -ppano4577 >  agentdocuments.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agentdownlink   -uroot -ppano4577 >  agentdownlink.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agentnotes   -uroot -ppano4577 >  agentnotes.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agentpages   -uroot -ppano4577 >  agentpages.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agents -uroot -ppano4577 >  agents.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
agentsdba -uroot -ppano4577 >  agentsdba.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
airlinelookup   -uroot -ppano4577 >  airlinelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
airportlookup   -uroot -ppano4577 >  airportlookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
appointments -uroot -ppano4577 >  appointments.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
appointmentstatuslookup  -uroot -ppano4577 >  appointmentstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
appointmenttypelookup -uroot -ppano4577 >  appointmenttypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
appointmentuplink  -uroot -ppano4577 >  appointmentuplink.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
appversioninfo  -uroot -ppano4577 >  appversioninfo.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
callstatuslookup   -uroot -ppano4577 >  callstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
carriercontacts -uroot -ppano4577 >  carriercontacts.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
carriernotes -uroot -ppano4577 >  carriernotes.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
carriers  -uroot -ppano4577 >  carriers.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
contactnotes -uroot -ppano4577 >  contactnotes.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
contacts  -uroot -ppano4577 >  contacts.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
diary  -uroot -ppano4577 >  diary.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
documenttypelookup -uroot -ppano4577 >  documenttypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
followupactionlookup  -uroot -ppano4577 >  followupactionlookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
followupprioritylookup   -uroot -ppano4577 >  followupprioritylookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
followups -uroot -ppano4577 >  followups.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
followupstatuslookup  -uroot -ppano4577 >  followupstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
hotellookup  -uroot -ppano4577 >  hotellookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
individualorcorplookup   -uroot -ppano4577 >  individualorcorplookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
insurancelinelookup   -uroot -ppano4577 >  insurancelinelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
levellookup  -uroot -ppano4577 >  levellookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
levelpctlookup  -uroot -ppano4577 >  levelpctlookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
licenses  -uroot -ppano4577 >  licenses.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
licensetypelookup  -uroot -ppano4577 >  licensetypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
logicallookup   -uroot -ppano4577 >  logicallookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
maritalstatuslookup   -uroot -ppano4577 >  maritalstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
marketinglevellookup  -uroot -ppano4577 >  marketinglevellookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
masterindex  -uroot -ppano4577 >  masterindex.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
mealchoicelookup   -uroot -ppano4577 >  mealchoicelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
openorderflaglookup   -uroot -ppano4577 >  openorderflaglookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
orderprioritylookup   -uroot -ppano4577 >  orderprioritylookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
orders -uroot -ppano4577 >  orders.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pending   -uroot -ppano4577 >  pending.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pendingbusinessnotes  -uroot -ppano4577 >  pendingbusinessnotes.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pendingdocuments   -uroot -ppano4577 >  pendingdocuments.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pendingdocumenttypelookup   -uroot -ppano4577 >
pendingdocumenttypelookup.sql
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pendingstatuslookup   -uroot -ppano4577 >  pendingstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
pendingtypelookup  -uroot -ppano4577 >  pendingtypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
production   -uroot -ppano4577 >  production.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
queries   -uroot -ppano4577 >  queries.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
querytypelookup -uroot -ppano4577 >  querytypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
returnaddress   -uroot -ppano4577 >  returnaddress.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
roomchoicelookup   -uroot -ppano4577 >  roomchoicelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
security  -uroot -ppano4577 >  security.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminaragenda   -uroot -ppano4577 >  seminaragenda.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminarattendees   -uroot -ppano4577 >  seminarattendees.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminarcontacts -uroot -ppano4577 >  seminarcontacts.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminars  -uroot -ppano4577 >  seminars.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminarstatuslookup   -uroot -ppano4577 >  seminarstatuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
seminartypelookup  -uroot -ppano4577 >  seminartypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
shippingtypelookup -uroot -ppano4577 >  shippingtypelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
stateidlookup   -uroot -ppano4577 >  stateidlookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
statuslookup -uroot -ppano4577 >  statuslookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
subactivitylookup  -uroot -ppano4577 >  subactivitylookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
timezonelookup  -uroot -ppano4577 >  timezonelookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
usergrouplookup -uroot -ppano4577 >  usergrouplookup.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
users  -uroot -ppano4577 >  users.sql   
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
usertypelookup  -uroot -ppano4577 >  usertypelookup.sql   

+

-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@stripped
<mailto:jay.blanchard@stripped> ] 
Sent: Thursday, June 19, 2003 10:10 AM
To: Dickey, Dallas; Christensen, Dave; mysql@stripped
Subject: RE: Odd thing


[snip]
mysqldump AgentAdminDB activitylookup -u UserName -pPassword >
//var/data/mysql/activitylookup.sql
mysqldump AgentAdminDB agencies -u UserName -pPassword >
//var/data/mysql/agencies.sql mysqldump AgentAdminDB agentdocuments -u
UserName -pPassword > //var/data/mysql/agentdocuments.sql
mysqldump AgentAdminDB agentdownlink -u UserName -pPassword >
//var/data/mysql/agentdownlink.sql
mysqldump AgentAdminDB agentnotes -u UserName -pPassword >
//var/data/mysql/agentnotes.sql mysqldump AgentAdminDB agentpages -u
UserName -pPassword > //var/data/mysql/agentpages.sql [/snip]


Can we see the rest of the script?

Jay

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
<http://lists.mysql.com/mysql> 
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
<http://lists.mysql.com/mysql?unsub=1 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1

-- 
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