Hi,
on restart after a crash, MonetDB/SQL is supposed to recover itself from
the crash. There is no option (and should be no need) for any explicit
action.
Please provide a details bug report via
http://bugs.monetdb.org/
in case you experience any problems with crashes or during automatic
recovery of the server on restart after a crash.
To prevent data loss, i.e., in case of disk failure or alike, you might want
to back-up your database regularly, though, either by dumping (e.g., using
the "\D" command in mclient or mclient's "--dump" commanline option), or by
stopping the server an backig up the complete dbfarm using your favorite
(filesystem-) backup software.
Stefan
> ------------------------------------------------------------------------------
On Tue, Jun 29, 2010 at 09:01:09PM +0800, ÀîÀ¤ wrote:
> Hi all.
>
> I plan to deploy monetdb into production environment, but i don't know how
> to recover from a crash.
>
> I find some sql log files in var\sql_logs\$dbname\sql\, can i use these log
> files to recover, and how?
>
> Or are there any other methods to recover from crashes?
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
--
| Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
| CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
| 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
| The Netherlands | Fax : +31 (20) 592-4199 |
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users