Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Load mysql dump to ASA 6.0???

3 posts in General Discussion Last posting was on 2004-06-24 13:28:05.0Z
LEB Posted on 2004-06-23 23:32:27.0Z
From: "LEB" <edge_leb@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Load mysql dump to ASA 6.0???
Lines: 5
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 200.84.66.201
X-Original-NNTP-Posting-Host: 200.84.66.201
Message-ID: <40da130b$1@forums-1-dub>
Date: 23 Jun 2004 16:32:27 -0700
X-Trace: forums-1-dub 1088033547 200.84.66.201 (23 Jun 2004 16:32:27 -0700)
X-Original-Trace: 23 Jun 2004 16:32:27 -0700, 200.84.66.201
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3204
Article PK: 6661

Is it possible to load a dump mysql file to ASA...

LEB.


Jason Hinsperger Posted on 2004-06-24 12:06:35.0Z
From: "Jason Hinsperger" <NOjason_hinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <40da130b$1@forums-1-dub>
Subject: Re: Load mysql dump to ASA 6.0???
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: vpn-concord-033.sybase.com
Message-ID: <40dac459$1@forums-2-dub>
X-Original-Trace: 24 Jun 2004 05:08:57 -0700, vpn-concord-033.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jun 2004 05:02:34 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jun 2004 05:06:35 -0700
X-Trace: forums-1-dub 1088078795 10.22.108.75 (24 Jun 2004 05:06:35 -0700)
X-Original-Trace: 24 Jun 2004 05:06:35 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3208
Article PK: 6668

If you dump to anascii file with columns comma delimited, then you should be
able to use the server LOAD TABLE statement or the dbisql INPUT statement to
move the data into the ASA database.
The only problem you may have is with binary data, as I am unsure how the
MySQL dump utility will unload this data from the MySQL database.

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
************************************************************
For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
************************************************************

"LEB" <edge_leb@yahoo.com> wrote in message news:40da130b$1@forums-1-dub...
> Is it possible to load a dump mysql file to ASA...
>
> LEB.
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-06-24 13:28:05.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40da130b$1@forums-1-dub> <40dac459$1@forums-2-dub>
Subject: Re: Load mysql dump to ASA 6.0???
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
Message-ID: <40dad6e5$1@forums-1-dub>
Date: 24 Jun 2004 06:28:05 -0700
X-Trace: forums-1-dub 1088083685 24.112.219.219 (24 Jun 2004 06:28:05 -0700)
X-Original-Trace: 24 Jun 2004 06:28:05 -0700, cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3211
Article PK: 6667

The following link may help:

http://www.sybase.com/content/1030300/MySQL-ASA-Migration.pdf

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Jason Hinsperger" <NOjason_hinspergerSPAM@hotmail.com> wrote in message
news:40dac459$1@forums-2-dub...
> If you dump to anascii file with columns comma delimited, then you should
be
> able to use the server LOAD TABLE statement or the dbisql INPUT statement
to
> move the data into the ASA database.
> The only problem you may have is with binary data, as I am unsure how the
> MySQL dump utility will unload this data from the MySQL database.
>
> --
> Jason Hinsperger
> Product Manager
> iAnywhere Solutions
> ************************************************************
> For the latest downloads technotes, whitepapers, webcasts and other
> developer
> resources, go to: http://www.ianywhere.com/developer/
> ************************************************************
>
>
> "LEB" <edge_leb@yahoo.com> wrote in message
news:40da130b$1@forums-1-dub...
> > Is it possible to load a dump mysql file to ASA...
> >
> > LEB.
> >
> >
>
>