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