Import to MySQL

[william humphrey]

What is the largest text file a program like BBEdit can open?

On Mon, Oct 13, 2008 at 12:47 PM, Beatrix Willius <bwillius at gmx.de> wrote:

> If I have to edit the file, the sql dump won't work. The customer has
> huge databases (> 5 GB), which make editing impossible. And of
> course, I'm using ObjectPtr's.
>
> What other possibilities do I have to move the data to MySQL other
> than having the databases talk to each other directly? Since it's
> just for one customer I don't want to put too much time into this if
> possible.
>
> On 13.10.2008, at 18:41, Ruslan Zasukhin wrote:
>
> > On 10/13/08 6:13 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:
> >
> > Hi Beatrix,
> >
> >> one of my customers wants to move from Valentina to MySQL. I tried to
> >> load a sql export from Valentina into MySQL. Should this work?
> >
> > Only if simple CREATE TABLE and inserts, and no such things as e.g.
> > ObjectPtr.
> >
> >> I got an error message that the sql isn't okay at the first line.
> >
> > Ah, right.
> >
> > First line is
> >
> >     SET PROPERTIES OF DB
> >
> > MySQL do not have such command. You can erase it in dump.
>
> Mit freundlichen Grüßen/Regards
>
> Trixi Willius
>
> http://www.mothsoftware.com
> Mail Archiver X: archive, clean and search email
> http://www.beatrixwillius.de
> Fractals, 3d landscapes etc.
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com