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 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:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, June 19, 2003 10:10 AM To: Dickey, Dallas; Christensen, Dave; [EMAIL PROTECTED] 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/[EMAIL PROTECTED] <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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]