MySQL DB & Table updation

[Rok]

I am running two phpBB based forums, one is on my Office Network and another one is my personal. But I am using the same version and themes on both forums. Some times, I install new MOD on Office Forum and other on my personal and then update both fourms accordingly.

2. The problem comes, when I do install more than One MOD or many new MODs, which requires lot of MySQL Table creation, insertion or updation. As of now, I am updating both SQL DB's manually, which some times require lot of work.

Q1. So, what's the best way to update two different MySQL DB of phpBB forum, where about 100 SQL querys are involved? other than manual insertion.

Q2. Or is it possible that we export only Table Strutcture from the latest SQL DB and then import into the other one without effecting exisiting Data.

Please advice.

[Noobarmy]

Moved to phpBB Discussion.

Help & Support is for phpBBModders site problems

[igorw]

Q1: You should use a script generator. http://sql.phpmix.com/index.php
Q2: Yes, it´s an option in phpmyadmin. I don´t have one here right now, so i cant take a screenshot. But it´s in the export options.

Hope that helps.