Venks wrote:
Hi,
Hi, first comment. Did you also move the sql-log directory to the other machine?
I am trying to test the backup/restore of a MonetDB database. I installed MonetDB latest version on a 32Bit Red hat Linux. I created a database on Machine-1, created a table and loaded the table with 1M rows. After that I shutdown the database and took a back-up of the entire "dbfarm" directory. I moved the backup to Machine-2 where the "dbfarm" directory points to the similar location as Machine-1. I then opened the database on Machine-2 but there is no table/data on Machine2 even though the directory contents between the 2 machines appear the same. Please let me know if I am missing something.
I also made sure that Machine-2 is not creating the database in any other location, except the location where I copied all the files.
The idea here is to create the database on one machine and then move the database to different machine using simple file system COPY.
Thanks,
- Venks
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users