Hi, I works for me. How did you start your MonetDB server on the second m/c? I created two tables (1M and 10M) and realised that the default MonetDB installation is keeping the BAT in C Drive ( Windows ). So i simply moved the dbfarm to D and started MoentDB server with this "D:\Software\MonetDB\bin\mserver5.exe" --set "prefix=D:\Software\MonetDB" --set "exec_prefix=D:\Software\MonetDB" --dbfarm="D:\applications\monetdb\data\MonetDB5\dbfarm" --set "sql_logdir=D:\applications\monetdb\data\MonetDB5\sql_logs" --dbinit="include sql;" and thatz all. I can see the tables :) Hope that helps Thanks Bharani Venks wrote:

Yes. I did after Colin informed about the same. But still I don't see the table and the data. I am still missing something.

On 6/23/07, Martin Kersten wrote:

...

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

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

-- View this message in context: http://www.nabble.com/Database-backup-restore-tf3967414.html#a11825786 Sent from the monetdb-users mailing list archive at Nabble.com.

Hi Venks, I know i was trying to take the move in the same m/c out of the equation. And i just did a copy from my office to home pc and i can see all the tables and data. I am doing this in windows i could try on linux though. I am interested in taking backups with copy as well so do let me know when you have solved the problem Thanks Bharani Venks wrote:

Bharani,

I was trying to move the data files across the machines. On the same machine I was able to do so.

On 7/27/07, Bharani wrote:

...

Hi,

I works for me. How did you start your MonetDB server on the second m/c?

I created two tables (1M and 10M) and realised that the default MonetDB installation is keeping the BAT in C Drive ( Windows ). So i simply moved the dbfarm to D and started MoentDB server with this

"D:\Software\MonetDB\bin\mserver5.exe" --set "prefix=D:\Software\MonetDB" --set "exec_prefix=D:\Software\MonetDB" --dbfarm="D:\applications\monetdb\data\MonetDB5\dbfarm" --set "sql_logdir=D:\applications\monetdb\data\MonetDB5\sql_logs" --dbinit="include sql;"

and thatz all. I can see the tables :)

Hope that helps

Thanks Bharani

Venks wrote:

...

Yes. I did after Colin informed about the same. But still I don't see the table and the data. I am still missing something.

On 6/23/07, Martin Kersten wrote:

...

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

...

...

...

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

a 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

-------------------------------------------------------------------------

...

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

-- View this message in context: http://www.nabble.com/Database-backup-restore-tf3967414.html#a11825786 Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- View this message in context: http://www.nabble.com/Database-backup-restore-tf3967414.html#a11839726 Sent from the monetdb-users mailing list archive at Nabble.com.