hi i am new to sap database,i have installed the database and worked for some time on this database ,but now i need to format my system ,so i need to take back up of sapdb data.so i have tried mailing to many forums,but could not get answer,anyhow after extensive search in net i found that we can use repmcli command to do the need full. so i used
repmcli -E 1 -d YOUR_SRC_INSTANCE -u YOUR_SYSDBA,PASSWORD -b copy_out.sql where copy_out.sql contains TABLEEXTRACT ALL OUTFILE 'c:\outfile.unl.' and it was stored into output files.now to test this,i have created a new database instance and recovered data using repmcli -E 1 -d SAMPLE -u ebridgeadmin,admin -b copy_in.sql where copy_in.sql contains TABLELOAD ALL INFILE 'c:\outfile.unl.' OUTFILE 'c:\restart.dat' it worked fine and table schema and data were dumped into new instance.. but i have tried to recover the data in other system where sapdb was installed.but got an error message unexpected keyword: INFILE i cant understand why this is happening. only difference is sapdb installed on my system is sapdb7.4.2.6 and sapdb installed on other system is sapdb7.4.3.0 so please help me in this regard. sorry for such a long query,it is just to explain my problem clearly.. regards raj ________________________________________________________________________ Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
