tag:blogger.com,1999:blog-12459003.post113035148794151990..comments2023-08-03T09:19:28.438-04:00Comments on So What Co-operative: Skipping a beatJeff Hunterhttp://www.blogger.com/profile/15701602600662849251noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-12459003.post-1130493254201194532005-10-28T05:54:00.000-04:002005-10-28T05:54:00.000-04:00In such circumstances I log off and on again - pro...In such circumstances I log off and on again - prod & dev/test passwords being different.DaPihttps://www.blogger.com/profile/05039114783599655315noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-1130440901073753272005-10-27T15:21:00.000-04:002005-10-27T15:21:00.000-04:00I've gotten major amounts of work following up peo...I've gotten major amounts of work following up people who've done major amounts of production damage :-/<BR/><BR/>The odd thing is I'm probably klutzier than average. That makes me paranoid enough to be able to recover quickly from common catastrophes.<BR/><BR/>vstcxioJoel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-1130378701711228412005-10-26T22:05:00.000-04:002005-10-26T22:05:00.000-04:00and while we are talking about exports:always take...and while we are talking about exports:<BR/><BR/>always take one *without* data (rows=n)<BR/><BR/>Takes only a coupla minutes even on a VLDB. The number of times I've been able to quickly go to a dmp file with rows=n and grab a quick SQL to fix up a table, view, index, constraint, whatever, is just mind-boggling. <BR/><BR/>Instead of waiting for hours while the import churns through all the Noonshttps://www.blogger.com/profile/07694829378563989648noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-1130371306471798912005-10-26T20:01:00.000-04:002005-10-26T20:01:00.000-04:00I think the word export comes to mind. These days ...I think the word export comes to mind. These days even if they say "drop it", I make an export whihc I keep for a week or two. I had a number of cases over the years where they come back two days later and ask if I can bring back something. Also it gives me a double check that I am pointing to the right database.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-1130363148115225092005-10-26T17:45:00.000-04:002005-10-26T17:45:00.000-04:00Same here. That's good practice though, always dou...Same here. That's good practice though, always double-check or triple-check before deleting/truncating.<BR/><BR/>=)<BR/>--Emily--Anonymousnoreply@blogger.com