sja1233.x86_64.tar.gz

<job version="8.21"> <!--This document documents the schema that will be used for SJA for scheduled ODBC import. Unlike other options of SJA which are cross platform, this one is not. ODBC import uses strict Win32 ODBC functions and thus is non-portable.--> <odbcimport> <source> <!--Specifies the MySQL server information where to import the data--> <tunnelinfo type="http"> <!--Specifies tunnel information. Tunneling can be either SSH/HTTP--> <url>http://localhost/tunnel/SQLyogTunnel.php</url> </tunnelinfo> <host>localhost</host> <user>root</user> <pwd>root</pwd> <port>3306</port> <db>dbtoimportto</db> </source> <dsn type="system"> <!--Dsn section specifes information about the dsn--> <!--Type attribute specifes the type of dsn used in the import. Possible values are *file* or *system*. Default results to system.--> <name>hugetable</name> <user>sarat</user> <pwd/> </dsn> <import source="file"><!--Source attribute specifes whether to import data from the data source or from result returned from a query. possible values are *query* or *data*. If not specified it will default to data.--></import> <tables> <!--Sepcifes options for which table to import and table importing related options.--> <table source="sourcetable1" target="targettable1" comment="Comment to be used for the target table" type="MyISAM"> <!--Describes each table that will be imported--> <!--Source table. This table exist in the ODBC source and will be imported to MySQL.--> <!--Target table. The source table will be imported to the target table.--> <ddl create="yes"> <!--Specifes option for DDL statements.--> <!--Create spcifies whether to execute DDL statement for the table.--> <!--What happens if there is a confilct? *recreate* or *ignore*--> <onconflict>recreate</onconflict> <!--What happens on error? *ignore* or *abort* are the possible values.--> <onerror>abort</onerror> </ddl> <dml create="yes"> <!--Specifies option for DML statements.--> <!--Create attribute is similar to ddl *create*--> <!--Onconflict has same meaning like *DDL* onconflict. Possible values are *ignore*, *replace*, *abort*--> <onconflict>ignore</onconflict> <!--OnError is similar to DDL onerror.--> <onerror>continue</onerror> </dml> <columns> <column source="col2" target="col2"/> </columns> </table> <table source="srctable2" target="tgttable2"> <ddl create="yes"> <onconflict>ignore</onconflict> <onerror>abort</onerror> </ddl> <dml> <onconflict>replace</onconflict> <onerror>continue</onerror> </dml> <columns> <!--Specifies how to map each column from source to target. Each element provides details about each columns.--> <column> <source>col1</source> <target>col1</target> <type>char</type> <length>10</length> <default>sqlyog</default> <primary>yes</primary> <binary>yes</binary> <notnull>yes</notnull> <unsigned>no</unsigned> <autoincr>yes</autoincr> <zerofill>no</zerofill> <comment>comment for something</comment> </column> </columns> </table> <table> <source>srctable3</source> <target>tgttable3</target> <ddl create="no"> <onconflict>na</onconflict> <onerror>na</onerror> </ddl> <dml create="yes"> <onconflict>abort</onconflict> <onerror>continue</onerror> </dml> <columns> <!--Specifies how to map each column from source to target. Each element provides details about each columns.--> <column> <source>col1</source> <target>(NULL)</target> <type>char</type> <length>10</length> <default>sqlyog</default> <primary>yes</primary> <binary>yes</binary> <notnull>yes</notnull> <unsigned>no</unsigned> <autoincr>yes</autoincr> <zerofill>no</zerofill> <comment>comment for something</comment> </column> </columns> </table> <table> <source>srctable4</source> <target>tgttable4</target> <ddl create="no"> <onconflict>na</onconflict> <onerror>na</onerror> </ddl> <dml create="no"> <onconflict>na</onconflict> <onerror>na</onerror> </dml> <columns> <column source="col2" target="col2"/> </columns> </table> </tables> <smtp> <!--Provides SMTP server information to which the email will be sent.--> <displayname>Webyog Support</displayname> <toemail>support@webyog.com</toemail> <fromemail>sales@webyog.com</fromemail> <cc>hr@webyog.com</cc> <bcc>admin@webyog.com</bcc> <replyemail>somename@webyog.com</replyemail> <host>smtp.someserver.com</host> <port>25</port> <auth required="yes"> <user>bkavas</user> <pwd>aaaaaa</pwd> </auth> <subject>Subject</subject> </smtp> <!--Specifies what happens if there is any error. *ignore* and *continue* are the possible values. By default, *ignore* has to be taken.--> <onerror>ignore</onerror> </odbcimport> </job>