Import to MySQL

[Beatrix Willius]

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.