28 points
Community rank #2163
kuka
VeteranJust Getting Started
MemberLikes (0)
Hi there, got a question regarding multi-db. When i configure the move-blogs.php, what do i put to $newdb_prefix, this: $newdb_prefix = 'wm001'; or this $newdb_prefix = 'wm001_';
if i have 16 dbs, like wm001_0, wm001_1, wm001_2 etc. Should i put "_" after the dbprefix or not?
Responses (9)
Member (joined August 2008) Likes (0)
also, if i have vip blog 1, does this need to be mentioned somewhere in move-blogs script?
Member (joined August 2008) Likes (0)
ok solved the above problems but now get 404 error when going to
http://domain.com/wp-content/scripts/move_blogs.php?table=copy
Member (joined August 2008) Likes (0)
ok solved :)
Member (joined August 2008) Likes (0)
now the problem is that VIP1 table is empty and the main blog has got no new posts
Member (joined July 2008) Likes (0)
On question #1 you do need the '_' in the prefix.
The vip blogs are not handled in the move blog script.
Member (joined August 2008) Likes (0)
solved )
Member (joined August 2008) Likes (0)
can anyone tell me pls whats the difference between HyperDB and MultiDB though?
Member (joined August 2008) Likes (0)
after moving to 16 dbs, the following line in plugins doesnt work
global $current_blog,$wpdb;
$post = get_the_ID();
$tableName = $wpdb->base_prefix . "ExampleTable";
$count = $wpdb->get_var("SELECT COUNT(*) from $tableName WHERE blog_id = ".$current_blog->blog_id." AND post_id = $post");
Member (joined August 2008) Likes (0)
all issues resolved :)
Become a member