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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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.
>
>
> -------------------------------------------------------------------------
> 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
