Hi Andrew and Patrick, The Idea is good.. a good to have feature.. but.. During the porting work of drizzledump to windows, noticed that drizzledump got lots of dependency on files in: drizzled\internal\* and others. to be exact.. total 26 other source files it touches!. I hope many of these complexity should go off. To connect to mysql server and pull the data, IMHO we should not be stregthening this dependency again.
On the otherway, if user gets mysql dumps files generated by mysqldump. drizzledump can be made to read data from it. I hope this will be easier and cleaner to implement. there is another advantage too.. it will be easier to make it read postgres or oracle dumps too. allowing migrations from other planets too.. :) Thank you, Jobin. On Mon, Sep 6, 2010 at 11:09 PM, Andrew Hutchings <[email protected]>wrote: > Hey Patrick, > > > On 06/09/10 18:22, Patrick Crews wrote: > >> At first glance, this looks really good to me. >> > > Thanks :) > > > The only thing that makes my spider-sense tingle is this: >> any date data containing 0000-00-00 -> 0001-01-01 >> >> I agree we need a conversion, but what if the table also contains date >> data with '0001-01-01' (Who can say what depraved use of special dates >> exist out there?) ; ) >> >> Of course, we can document this heavily so people will know what to >> expect and can adapt as they see fit. It seems nicer than trying to >> think too much for the user. >> > > I totally agree, but I cannot yet see any way around this, which is why I > said that it should warn to stderr. Something like: > > "Warning: table `t1` has data with the date '0000-00-00' which is invalid > in drizzle. This has been converted to '0001-01-01'." > > Also we will need good documentation on this. > > Although I'm open to suggestions if anyone has a better solution to this > issue. > > > I've also been thinking about how to help you test this. We should be >> able to set up something with the randgen that will generate some random >> test beds, convert them to Drizzle, then do some validation queries. >> > > I was wondering how to apply this in dtr without having either a MySQL > server to hand or something simulating one (which feels like it will be a > lot of work). > > > Kind Regards > -- > Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/ > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
