Andis wrote:
> I have LAN with some PC, which use MySQL database. Sometime power supplay failure
>occurs. I have back-UPS too, but them can't hold power for 2 or more hours and
>because it server loose power supplay and just stop (without correct system
>shut-down).
>
> I got such problem: I waste data in this situation (users waste what them did). As I
>understand, MySQL server don't write data on disc immediatly, but after some time.
>
> What can I do for saving data regularly (for example once at hour or something like
>that)?
mysql -e "FLUSH TABLES" writes everything down and closes all files. OS
can then maybe delay it and you should issue "sync".
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Hong Kong, China
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php