Hi guys!
I am not sure if the is the proper way of act, in case not please could
u point me to the right place? Thanks.
In case i am so lucky that this is the place and the way of sharing my
question. I have one.
I have been trying to setup sequoia-2.10.9 in Windows. The backends
databases are MySQL 5.0.
I have a huge problem (well maybe not so huge) while trying to setup the
recovery log. What i am
doing is:
- adding in the xml virtual database setup file:
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"/>
</Backup>
- and setting up the RecoveryLog like:
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/demo" login="root" password="*******">
<RecoveryLogTable tableName="logtable"
sqlColumnName="sqlcol"/>
<CheckpointTable tableName="checkpointtable"/>
<BackendTable tableName="backendtable"/>
<DumpTable tableName="dumptable"/>
</RecoveryLog>
- The tables were created manually as specified in the userGuide except
for the column sql which i changed. And i am using VARCHAR(255) for
those columns
which are specified as VARCHAR.
Well once connected to the virtualdatabase what i do is:
> initialize mysql-node1
> backup mysql-node1 my_dump_test Octopues backup
And always getting this error:
Backup backend mysql-node1 in dump file my_dump_test
Exception in method generate() in LoaderGenerator class!
Error while generate sql statements for all vendors.
I also added the mysql-connector to the classpath in the console.bat as
i read that there should be explicitly added to the CLASSPATH. The
process i wanna do to setup recoveryLog
is restore node2 from backup in node1 and then enable both nodes. Is
that correct? Anyway the step 2 is not working...
PLEASE, could anyone bring me some light into this? I appreciate very
much your help and your time.
And of course thanks very much in advance.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
