Multi-DB: Production environment issue

Hi Guys,

This week I did a mayor update including going to Multi DB. Now after a few days the support tickets are exploding. All e-mail lists (subscribe by email plugin) are empty. It looks like the data is not copied.

I can see the data in the original database. I'm looking for a solution to recopy all the subscription table.

If I modify the move_blogs.php with the folowing changes:

---------------------
line 54: alter the table selection to only select the subscription tables
from
$result = mysql_query( 'SHOW TABLES FROM ' . $dbname );

to
$result = mysql_query( 'SHOW TABLES FROM ' . $dbname ' WHERE Tables_in_'. $dbname .' LIKE "%_subscriptions"; ');

---------------------
line 123: remove the table exist check (because the tables are there)

from
if ( !empty( $tabletomove ) && !$tableexists ) {
mysql_query( "CREATE TABLE {$row[0]} LIKE {$dbname}.{$row[0]}" );
mysql_query( "INSERT INTO {$row[0]} SELECT * FROM {$dbname}.{$row[0]}" );
}

to
mysql_query( "INSERT INTO {$row[0]} SELECT * FROM {$dbname}.{$row[0]}" );

--------------------------

Again I try to fix this ASAP and I think this is the easiest solution for 5000+ sites. Let me know what you think?

I also opened another topic, but topic was focused on the problem being SE. But it doesn't look like that anymore. Sorry if I'm spaming the foru :slight_smile:. But it is the production enviroment.