Good point Joop! I'll make sure the initial data doesn't get inserted. Thanks!
-Todd On Tue, Jun 17, 2008 at 2:21 AM, Joop <[EMAIL PROTECTED]> wrote: > Todd Chapman wrote: > >> Someone wants me to convert their Postgres backed RT to MySQL. Doesn't >> matter why, they want it. :) >> >> Here's what I am thinking. >> >> 1. Shut down the web server. >> 2. Dump the DB data. >> 3. Reconfigure RT for MySQL. >> 4. Run initdb >> 5. Load the data. >> 6. Restart the RT/web server. >> > > You're probably in trouble between points 4 and 5 since initdb does create > not only the db objects but also loads data which will be in the dataset > that comes from postgres, if you're lucky the inital data will be the same > but I wouldn't bet on it. You could truncate the tables and reset the > sequences but it might be easier to modify initdb to only create but not > load the data. > > Joop > >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
