I've started a new thread because my problem shifted from its original problem to my current problem..
Reader's Digest Version:
I moved to a new host provider. There was issues because of the Mysql engine supported. The previous thread helped me restore the database and documents what I did. Besides the InnoDB vs MyISAM differences ... there was also this issue - in the wp-config.php file..
define('DB_NAME', 'newmoon'); // The name of the database
define('DB_USER', 'petlvr'); // Your MySQL username
define('DB_NAME', 'newmoon_newmoon'); // The name of the database
define('DB_USER', 'newmoon_petlvr'); // Your MySQL username
The newmoon_ prefix is the name of the domain login. For the actual tables, it was unchanged from the old to the new database ...
$table_prefix = 'moon_'; // example: 'wp_' or 'b2' or 'mylogin_'
I went into the new database with myphpadmin and fixed the siteurl in the moon_options table.
The URL/domain is http://NewMoonScribbles.com
This is the new problem. The site is moved, the files copied over, the database recreated .. but when you go to the above site - it wants to INSTALL wordpress and doesn't recognize anything. After my first install, I always rename the install.php to something else, so I there's not been any risk of clicking it.
I would like to know what I can do to get my site working. There is only about 5-10 posts I think in this one. It's a prelude 'practice' for moving a much larger site and while I can risk the downtime on this blog, I can't risk downtime moving any other blogs, like my PetLvr.com blog ..
Any suggestions? What will happen if you reinstall a wordpress blog on a database that already exists? Why doesn't my wp-config work?
Thanks in advance