List:General Discussion« Previous MessageNext Message »
From:Adrian Phillips Date:July 13 2000 1:40pm
Subject:Re: locking tables
View as plain text  
>>>>> "Robert" == Robert Hall <rhall@stripped> writes:

    Robert> I recently inherited a MySQL database when a coworker left
    Robert> the company. When I looked into maintenance procedures, I
    Robert> discovered that the database is being backed up nightly by
    Robert> a crontab file that triggers a script. The script has the
    Robert> following two lines in a for loop: isamchk -eiv
    Robert> /path/$i/*.ISM > /path/$i-ismcheck.log ; mysqldump -u
    Robert> <login> -p <adgangsord> $i > /path/$i.dump; The
    Robert> skip_locking variable is set to ON.

I believe mysqlhotcopy does some of what he above does. See how it
does it and modify it or write your own version.

Sincerely,

Adrian Phillips

-- 
Your mouse has moved.
Windows NT must be restarted for the change to take effect.
Reboot now?  [OK]
Thread
locking tablesJaskirat Singh11 Jul
  • Re: locking tablessinisa11 Jul
RE: locking tablesRobert Hall11 Jul
  • Re: locking tablesRolf Hopkins12 Jul
  • Re: locking tablesAdrian Phillips13 Jul