• Resolved willie

    (@willie)


    I am trying to move a personal WordPress from one hosting provider to another. The new provider does the WordPress 2.2.1 install automatically generating a fresh database with the name/username/password I supply.

    I have a backup of the old site and have uploaded it to the new site via ftp. They have throttled phpAdmin uploads to 2MB, much smaller than my 22MB backup. They claim to have then imported successfully the backup to the new database.

    However, via phpAdmin, it appears the database is emtpy, it has no tables at all. I need some help resolving this issue and their support people havent been much help.

    If you are interested in assisting with this, please advise.

    I will be away from the computer for a few hours, then back at it.

    Thanks,

    Willie

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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, ‘https://newsite.com’, 20, 8, ‘WordPress web address’, 1, ‘yes’);

    REPLACE INTO wp_options VALUES (46, 0, ‘home’, ‘Y’, 1, ‘https://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 https://CozumelGringo.com .

    Willie

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Problems moving to a new server’ is closed to new replies.