>
> ----Server - openSuse 11.2 (192.168.0.100)
> --------VBox
> ------------Guest - openSuse 11.2 (Drupal Dev) (192.168.56.103)
> ------------Guest - openSuse 11.2 (Drupal Pro) (192.168.56.104)
> ------------Guest - openSuse 11.2 (MySql Database) (192.168.56.105)
>
> Both my Drupal box’s connect to the MySql Server, but with different
> databases. I use fileZilla to publish to the Pro box any changes and
> additions.
>
> What I need is, do anyone have or now where I can get a Sql script that
> will update certain tables from my dev_database to my pro_database?
>
> or
>
> Is there a module that can do something like this?
Do you need to do this once in a while, or repeatedly? If only once in a
while, you should be able to do it manually by using an Export function for
the Dev database, then an Import function on the Pro database. If
repeatedly, maybe the Export/Import functions will give you an idea how you
might approach this.
You can use phpmyadmin to copy tables from one DB to another. It can also be done by issuing mysql commands, so you just have to write the SQL. Basically an INSERT INTO … SELECT … preceeded by a TRUNCATE.
Only will be doing it once and a while, but I have the 1.2.12 version of the GUI MySql Admin. and it doesn’t have an export feature. Just a dump for the database.
I’ll give the phpMyAdmin a try, but I just want to update non-user tables, when I add modules and activate them, content, forms, etc on my development database, then when is ready to production, I want to update the corresponding tables.
>
> Only will be doing it once and a while, but I have the 1.2.12 version of
> the GUI MySql Admin. and it doesn’t have an export feature. Just a dump
> for the database.
>
> I’ll give the phpMyAdmin a try, but I just want to update non-user
> tables, when I add modules and activate them, content, forms, etc on my
> development database, then when is ready to production, I want to update
> the corresponding tables.
It occurs to me that the Export/Import functions I mentioned are actually
functions in phpMyAdmin. Good luck!
It is possible to use the in built binary log replication to do this very simple to setup in a master slave topology. You can also do master/master and other combos.
I would recommend you check this out. You can replicate tables not just entire DB’s.