[MonetDB-users] Table trace in file system
Hi there, Is there any way to export\import tables between machines by only coping files and\or folders Thanks, Alfred -- View this message in context: http://www.nabble.com/Table-trace-in-file-system-tp20478519p20478519.html Sent from the monetdb-users mailing list archive at Nabble.com.
Hi Alfred, may I assume you are talking about SQL tables? In any case, MonetDB does not (yet??) provide any functionallity to transfer individual database tables between machines by "simply" copying files or folders --- if at all, this would in any case only be possible between binary compatible machines (and likewise MonetDB installations). Dump+restore is the recommended way of transfering data/tables between machines. In case you are dealing with binary compatible machines (and likewise MonetDB installations), you could transfer a complete database by copying the complete <dbname> folder from one machines dbfarm to the other machines dbfarm --- of course, both MonetDB servers need to be stopped and their logs flushed before copying the data. Regards, Stefan On Thu, Nov 13, 2008 at 02:51:18AM -0800, Alfred Nordman wrote:
Hi there,
Is there any way to export\import tables between machines by only coping files and\or folders
Thanks,
Alfred -- View this message in context: http://www.nabble.com/Table-trace-in-file-system-tp20478519p20478519.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ 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-4312 |
Hi Alfred,
may I assume you are talking about SQL tables?
In any case, MonetDB does not (yet??) provide any functionallity to transfer individual database tables between machines by "simply" copying files or folders --- if at all, this would in any case only be possible between binary compatible machines (and likewise MonetDB installations).
Dump+restore is the recommended way of transfering data/tables between machines.
In case you are dealing with binary compatible machines (and likewise MonetDB installations), you could transfer a complete database by copying the complete <dbname> folder from one machines dbfarm to the other machines dbfarm --- of course, both MonetDB servers need to be stopped and their logs flushed before copying the data.
On Thu, Nov 13, 2008 at 02:37:40PM +0100, Stefan Manegold wrote: please include you log directories too. Niels
Regards, Stefan
On Thu, Nov 13, 2008 at 02:51:18AM -0800, Alfred Nordman wrote:
Hi there,
Is there any way to export\import tables between machines by only coping files and\or folders
Thanks,
Alfred -- View this message in context: http://www.nabble.com/Table-trace-in-file-system-tp20478519p20478519.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ 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-4312 |
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (3)
-
Alfred Nordman -
Niels Nes -
Stefan Manegold