mysqldiff

registered · Posted: Tue Mar 13, 2007 7:01 pm

It looks like this will be useful for converting to RavenNuke:

http://www.mysqldiff.org/

I ran it on 7.9 compared to Raven 2.10 and captured the SQL statements it generated. On first glance it seems pretty straightforward. I'll likely attempt the conversion this weekend (on a test system first Wink

).

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Have you seen Guardian's Only registered users can see links on this board! Get registered or login! from Code-Authors.com?

Posted: Tue Mar 13, 2007 8:36 pm

Yes I tried it but I could not get it to work. It is quite possible I didn't edit the config file correctly...I spent all of 5 minutes with it before trying mysqldiff and it worked the first time. I'll double check it again tomorrow.

Posted: Tue Mar 13, 2007 9:08 pm

From the description, it sounds like it's worth it. It can execute the SQL to update a database, rather than having to copy and paste it.

registered · Posted: Wed Mar 14, 2007 6:04 am

Nice, thanks!

registered · Posted: Wed Mar 14, 2007 7:09 am

yep.. it gives you a link beside each statement to click and execute. However, it would be even nicer if one could select multiple rows and then execute them all... wink.... wink.... :hint:... :hint: Laughing

Posted: Thu Mar 15, 2007 6:55 am

Finally got round to upgrading some of my sites and I've found mySQLDiff to be very very useful. The fact that it gives you the SQL to execute is great!

I haven't tried Guardians script, but I will be sure to give it a go.

Posted: Thu Mar 15, 2007 7:04 am

I tried Guardian's script again last night and could not make it work under XAMPP and MySQL5. Confused

I filled in the database names, login (root), and password (''). I didn't see anywhere to point it at localhost though. I uploaded the whole db_util directory and accessed it via http://localhost/db_util/compare.php. Did not show any differences. Any idea what I am doing wrong?