Skip navigation links

MySQL Forums :: MaxDB :: SQL dump?


Advanced Search

Re: SQL dump?
Posted by: S Dierkes ()
Date: June 14, 2006 03:26AM

For dumping use script like:

loadercli -d mydb -u dba,dba -b exportdata

where exportdata is a configuration file:

CATALOGEXTRACT USER OUTSTREAM FILE '[some path]\mydb_cat'
//
TABLEEXTRACT USER DATA OUTSTREAM FILE '[some path]\mydb_data' RECORDS

The first line will extract the catalog (i.e. table definitions, etc.) the next command line will extract the data.
Since I usually use sqlstudio to create the tables, I edit the file mydb_cat and load it from the sqlstudio. To load the data use something like:

loadercli -d copy_db -u dba,dba -n 192.168.178.17 -b uploaddata

In this case the data is loaded to a remote db and uploaddata is a command script:

TABLELOAD USER DATA INSTREAM FILE '[some path]\mydb_data' RECORDS

You might change in both command scripts the parameter "USER" (see docs).

In case of "USER" it's important that the user exists on the copy db.



Edited 1 time(s). Last edit at 06/14/2006 03:27AM by S Dierkes.

Options: ReplyQuote


Subject Written By Posted
SQL dump? Martin Wendel 05/24/2006 07:13PM
Re: SQL dump? Martin Wendel 06/12/2006 11:19AM
Re: SQL dump? S Dierkes 06/14/2006 03:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.