Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Export SQL doesn't generate any SQL


Robin

Have a look at http://instantdb.enhydra.org/community/library/index.html.
DBtool might be what you need.

Alternatively, you could try CSV files. I don't know a lot about mysql, but
I'm guessing that it will be able to read comma separated values from files.
You'd have to the table CREATEs manually using a script, and then use
mysql's equivalent of IMPORT to read the csv files. See

http://instantdb.enhydra.org/software/documentation/import.html

for details.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Robin Green <greenrd@hotmail.com>
To: instantdb@enhydra.org <instantdb@enhydra.org>
Date: 07 August 2000 17:27
Subject: InstantDB: Export SQL doesn't generate any SQL


I need to export an InstantDB database into a format that mySQL can read
(we're using instantdb on the client side and mysql). Something like
mysqldump would be ideal - it can generate a set of CREATE and INSERT
statements. RMI-JDBC is not an option - it must be a single file that can be
uploaded. I thought that SET EXPORT "filename.txt" SQL might work, but I
don't get any SQL out of that, I just get this:

0·All·0.0·999999.0
1·< £1·0.0·0.99
2·£1 to £3·1.0·2.99
...

I even set the exportSQL property to 1 in the database properties file.
Looks like a bug.

Shouldn't be too hard to workaround for now, of course.


--
Robin Green
i-tao Ltd.
4 Skyline Village
Limeharbour
London E14 9TS
United Kingdom
Phone +44 20 7537 2233  Fax +44 70 8081 5118
http://www.i-tao.com


________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

----------------------------------------------------------------------------
-
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.