Re: Using msqldump while data is being inserted.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2014-01-13 16:30, Pedro Salgueiro wrote:

The snapshot is over the entire database or over the individual tables?

The entire database.

On Mon, Jan 13, 2014 at 3:22 PM, Sjoerd Mullender mailto:sjoerd@acm.org> wrote:

Expected behavior is that msqldump ignores the new data. msqldump runs inside a transaction, and in MonetDB that means that msqldump works on a snapshot of the data.

On 2014-01-13 16:04, Pedro Salgueiro wrote:

...

Hi,

...

What is the expected behavior of msqldump if I try to a backup a database or table, and at the middle of the backup process new data is inserted?

...

Would the dump process ignore the new data, or it would rollback and restart all over again?

...

Thank you, Pedro Salgueiro

...

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQCVAwUBUtQKuT7g04AjvIQpAQIzMgP9GpoyfBydn+aurC0EktaJK08uW1JtI29+ g4+9KEvn9D0eHg6ao7qwC0Rk9bYgK6V4L00fdDNQpz6cEkJsHeJf5hIcMvjc1JbG lgLwUecpoAp7Wkh/vSUP+AQaz8rKtaKZ1oktxYKlIjBIOa9qv3GOl3ETsXaVrMC0 /XbkCJBK7Bc= =O4Ea -----END PGP SIGNATURE-----