Using msqldump while data is being inserted. - users-list - monetdb.org

newer
Building a debug version of...

Using msqldump while data is being inserted.

older
couldn't locate mserver5

Pedro Salgueiro

13 Jan 2014 13 Jan '14

4:04 p.m.

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

Attachments:

attachment.html (text/html — 392 bytes)

Reply

Sign in to reply online Use email software

Show replies by date

Sjoerd Mullender

13 Jan 13 Jan

4:22 p.m.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 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/ iQCVAwUBUtQEvj7g04AjvIQpAQID0gP/WmT6IHjC4zmM4rx3WgOF1RhV9iKQwu3q hBTAcoCYZeSvM716H/3c504tkI6sVqyJr0znSFSU1k4Gg9/YDgMr6LemtPBb5CLU XIPZhV7BXfq4IHY660OGACoYdfvs5x21f7Et7wwNN0nNxx5JnjcaLGOrxfZe4bPX Gc2l8NAU6KM= =FuEi -----END PGP SIGNATURE-----

Reply

Sign in to reply online Use email software

Pedro Salgueiro

4:30 p.m.

The snapshot is over the entire database or over the individual tables? On Mon, Jan 13, 2014 at 3:22 PM, Sjoerd Mullender wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

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 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/

iQCVAwUBUtQEvj7g04AjvIQpAQID0gP/WmT6IHjC4zmM4rx3WgOF1RhV9iKQwu3q hBTAcoCYZeSvM716H/3c504tkI6sVqyJr0znSFSU1k4Gg9/YDgMr6LemtPBb5CLU XIPZhV7BXfq4IHY660OGACoYdfvs5x21f7Et7wwNN0nNxx5JnjcaLGOrxfZe4bPX Gc2l8NAU6KM= =FuEi -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Sjoerd Mullender

4:48 p.m.

-----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-----

Reply

Sign in to reply online Use email software

4020

Age (days ago)

4020

Last active (days ago)

Download

3 comments

2 participants

tags

participants (2)

Pedro Salgueiro
Sjoerd Mullender