Some basic information first
Database name: moorg_
Database WordPress is installed in: moorg_Wp786
Database username: moorg_yaseen
Database pwd: pa55word
Server IP: 74.55.156.66
Details from wp-config as follows:
define('DB_NAME', 'moorg_Wp786');
/** MySQL database username */
define('DB_USER', 'moorg_yaseen');
/** MySQL database password */
define('DB_PASSWORD', 'pa55word');
/** MySQL hostname */
define('DB_HOST', 'localhost');
The following databases were created and user moorg_yaseen added to them:
CREATE DATABASE moorg_0 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Databases moorg_0 through to moorg_f where created
Also the following was created:
CREATE DATABASE moorg_global DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
First I will address db-config.php what i have entered into here is as follows:
Line 10 : define ('DB_SCALING', '16);
Line 16: add_dc_ip('74.55.156.', 'dcl');
Line 25: add_global_table('moorg_global');
DB server information was added as follows:
add_db_server('global', 'dc1', 1, 1,'74.56.156.66','127.0.0.1', 'moorg_global', 'moorg_yaseen', 'pa55word');
add_db_server('0', 'dc1', 1, 1,'74.56.156.66','127.0.0.1', 'moorg_0', 'moorg_yaseen', 'pa55word');
This was done for all databases save pasting it all in here.
Now to move-blog.php
Line 19: $dbname = "moorg_Wp786";
Line 20: $blog_table_prefix = 'wp_';
Line 21: $newdb_prefix = 'moorg';
Line 24: $dbhost = 'localhost';
Line 25: $dbuname = 'moorg_yaseen';
Line 26: $dbpass = 'pa55word';
Line 29: $db_scaling = '16';
The files were FTP’d to the respective locations on the server.
I cannot for the life of me work out whats going wrong.
Any advise appreciated.