turkel

Yes I did these and I have backup except wp-content folder

OK I have repaired then optimized globals and xxx_c database which home site is located then upgraded, same result ??

yes sure going to do this now, but I think it will only optimize tables which is not related to my problem, but wordpress repair tool checks for not existing databases.

I have tried to repair database through:
wp-admin/maint/repair.php

ad i got following errors on my global database:

vzd_1_posts: Table 'xxx_global.vzd_1_posts' doesn't exist
vzd_1_comments: Table 'xxx_global.vzd_1_comments' doesn't exist
vzd_1_links: Table 'xxx_global.vzd_1_links' doesn't exist
vzd_1_options: Table 'xxx_global.vzd_1_options' doesn't exist
vzd_1_postmeta: Table 'xxx_global.vzd_1_postmeta' doesn't exist
vzd_1_terms: Table 'xxx_global.vzd_1_terms' doesn't exist
vzd_1_term_taxonomy: Table 'xxx_global.vzd_1_term_taxonomy' doesn't exist
vzd_1_term_relationships: Table 'xxx_global.vzd_1_term_relationships' doesn't exist
vzd_1_commentmeta: Table 'xxx_global.vzd_1_commentmeta' doesn't exist

So first I want to know why it looks for main site at globals database instead of own database which is xxx_c ?
What do this means and how to repair it ?
This wordpress site root is came from version 2.7 by upgrading.

Yes I did it also, uploaded only wp-admin and wp-includes with index files and got same error ??

ahh perfect that is what i am trying to create. They have created it as plugin which i have not thought that way lol.

Thank you very much Andrea_r ??

actually, Multi DB seems works because newly created blogs have required table. Problem is on old ones and that is why i have created this script for to create tables on DBs. This code not works because of Multi DB as i understand.

My script code is this:

<?php
error_reporting(E_ALL);
$db_connect = mysql_connect("localhost","root","");
if (!$db_connect) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("wpmu_global", $db_connect);
$sqlid = "SELECT * FROM wp_blogs";
$result1 = mysql_query($sqlid) or die(mysql_error());

while($row = mysql_fetch_array($result1)){
	$blogid = array($row['blog_id']);
	$data = $row['blog_id'];
}
mysql_close($db_connect);

$db_connect = mysql_connect("localhost","root","");
if (!$db_connect) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("wpmu_1", $db_connect); //first db and i will run script for each db

foreach ($blogid as &$data) {
echo $sql = "CREATE TABLE IF NOT EXISTS <code>wp_&quot;.$data.&quot;_commentmetaTest</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  <code>comment_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
  <code>meta_key</code> varchar(255) DEFAULT NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY (<code>meta_id</code>),
  KEY <code>comment_id</code> (<code>comment_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
}

$result = mysql_query($sql) or die(mysql_error());

mysql_close($db_connect);
?>

Nope that is wordpress question as they are same on this problem.
I need it just for frontpage, i need publish my articles on frontpage as docs directory.