Re: Text Reports query

On Dec 12, 2003, at 11:15, Vincent Danen wrote:

>>> I think one thing I may try is see if there is a way I can dump the
>>> contents of a mysql db and import it into postgres... that way I'd 
>>> have
>>> a db with about 300+ bugs in it (nice for testing since I don't feel
>>> like doing 300 bugs here on my own).
>>
>>
>> I havn't done MySQL to PostgreSQL, but I've noticed these articles 
>> which
>> might be useful.
>>
>> http://www.sitepoint.com/article/529/2
>> http://www.xach.com/aolserver/mysql-to-postgresql.html
>
> Very cool.  Looks like it should be pretty straightforward since the 
> tables are created by the pgsql.dump, so I don't need to worry about 
> that... looks like just the sequences may be an issue.
>
> Thanks, Russell.
>
> Have you noticed any other issues with postgres stuff?  I'm gonna do 
> this dump and fill up postgres with a bunch of stuff and then try and 
> go through everything to make sure there isn't anything I missed, but 
> if you have noticed anything, please let me know (this goes for anyone 
> else fiddling with test1).
>
> If it all looks good, I might put out a 0.3.0beta this weekend to get 
> more people testing (or try to).

Well, this is a little annoying.  I can import everything except the 
bugdesc table... not sure what's going on there.  I keep getting 
pg_atoi errors saying it can't parse what is the text field.  Need to 
dig a little further.

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers