Re: Table update: restore or replace?

On 5/14/19 2:19 PM, Rich Shepard wrote:
> On Tue, 14 May 2019, Adrian Klaver wrote:
> 
>> Does the table you overwrote the data change much?
> 
> Adrian,
> 
> Yes. It's in my business tracking database so it's updated almost every 
> day.
> 
>> If not it might be safer to just fetch it from the April 20th dump and
>> then apply the changes since then.
> 
> The column I FUBAR'd holds e-mail addresses. What I'll do is set all to 
> NULL
> and find the e-mail addresses I have external to the database and enter 
> them
> in a large UPDATE TABLE.

Or just fetch them from the table data you have saved in the dump file.

> 
> And I think I'll set up a cron job to do a database dump each day with the
> date appended to the file name in the bash shell script.

Yeah, that will save a lot of heartburn:)

> 
> Thanks,
> 
> Rich
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com