Well if the database is empty, then there’s not much you can do. Please talk to your host about that–tell them to use phpMyAdmin to see that there are no tables.
Of course, that assumes you are looking at the correct database 😉
Thread Starter
willie
(@willie)
Thank you for the response MichaelH, however, I have had no luck with support at the provider. I believe if I cant figure out how to do it myself, I will just have to change providers where I have real access via ssh or the like. The folks at the previous provider have been quite helpful, but they cant do much on the receiving end.
I am working through the various other posts similar to this to see if I can glean any wisdom that will help me. I was just hoping to get a more knowledgeable person, willing to assist directly.
I worked on this all last night and will probably be at it tonight until I can solve the problem. I usually manage to get the problem solved, I am just so slow. The old brain just doesnt multi-task as well as it once did. Who am I kidding, it doesnt multi-task at all any more.
Willie
Thread Starter
willie
(@willie)
Problem solved by using manual sql entries within phpAdmin to upload a little bit at a time and populate the database.
I clicked on the SQL tab in phpAdmin and pasted lines from the backup.sql into the window and clicked ‘Go’. A little tedious, but worked like a charm.
I also had to manually change the siteurl and home references using these commands.
REPLACE INTO wp_options VALUES (1, 0, ‘siteurl’, ‘Y’, 1, ‘http://newsite.com’, 20, 8, ‘WordPress web address’, 1, ‘yes’);
REPLACE INTO wp_options VALUES (46, 0, ‘home’, ‘Y’, 1, ‘http://newsite.comy’, 20, 8, ”, 1, ‘yes’);
There was also a define(‘DB_HOST’, ‘xxx’); problem. My provider had changed the host that the database was on and I didnt notice the change.
So except for a few plugin issues (the old site was WP 1.5.2 and the new site is WP 2.2.1) it is up and running at http://CozumelGringo.com .
Willie
