Yes Michael,
I agree with you. It will create problem when DB will be on a separate server.
Right now databases are on the same server, when they will be on different server then i will go for you solution.
Again thank you for my help.
Hello Michael,
Thank you for your reply.
I have already tried this but it don’t work. because in the config.php they have defined the constant of db information so next time it is not resetting the DB values.It insert all the records in the first database.
By the way i have fixed this issue.
We can handle this thing by using the information of root database through which we can access all the databases and then we can simple use the
$wpdb->select(‘database_name’);
$wpdb->flush(); to clear SQL result cache with flush
And this worked for me.