Support » Fixing WordPress » New Host , Restore database

  • Resolved n3mesis


    I’m currently moving my blog to a new host and I made a backup of my db using the one click db backup but when I try to use it I just get the default install . I have also tried to install the db thu phpmyadmin but when I do it that way I end up with a white screen for my wordpress page . Anybody here got any ideas on what I can do ? Thanks for the help

Viewing 15 replies - 1 through 15 (of 22 total)
  • I’d love some help on this one too… I recently moved to Bluehost to support wordpress, but my database backup doesn’t seem to fit. Anyone got any ideas?

    jonnyboy – “doesn’t seem to fit” What do you mean exactly ?

    n3mesis – how large is the backup file ? Do you have access to the original database ? The white screen – have you double checked that your Theme files are okay ? try uploading the default them ?

    Podz, I can’t seem to make a database on bluehost without their username suffix. Where my old db was ‘wordpress’, the new one is ‘username_wordpress’.

    I changed my wp-config.php to fit the new names, but that didn’t help; it still displays the regular new-install posts.

    The actual name of the db doesn’t matter to anything except the connection in wp-config.php
    It’s name does not affect the contents.

    How large is the sql file ? And do you have phpmyadmin ?

    okie i guess u are installing wordpress on the new server. nopes u dont need to install. just dump wordpress onto the server and do not run install.php. now upload ur database, modify ur wp-config.php and point ur browser to /wp-admin/upgrade.php

    Oh really? I assumed that this was the problem. How about the tables? Usernames?

    The sql is about 1.5 megs, and yes, I’ve got phpadmin, but I’ve never used it before (the old host didn’t have it).

    Here’s the process:

    Install WP on the new host
    Login to cpanel and get to phpmyadmin
    DROP all the tables ( )
    Click the SQL tab – you’ll see a large white box

    In Notepad or another plaintext editor (NOT a wordprocessor, or Dreamweaver or GoLive) open the sql file.
    Copy the contents and paste it into the white box.
    Wander off and make a coffee
    Come back and all should be good.

    If it is not, come back with the error and we’ll try another way.

    Ok I’ll do that now.

    Does it matter whether I had multiple blogs on the old site? Should I set up the other blogs (with virgin installs) first before dropping the tables?

    Where are the database files for these other blogs ?
    It shouldn’t matter though as the config specifies which tables to use.

    How many blogs are there in this one database file ? (We need to do this right 🙂 )

    Argh, it timed out.

    How many blogs ??
    Time outs can be worked round.

    Ah ok, I’ve figured it out; two blogs in the same database… different prefixes.

    If the sql import timed out, you need to split the file, though at 1.5meg it should have been fine.

    Open the file in a plain text editor.
    At the top will be something similar to this:
    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl2
    -- Host: localhost
    -- Generation Time: Jun 21, 2005 at 04:39 PM
    -- Server version: 4.0.24
    -- PHP Version: 4.3.11
    -- Database:

    Some way through the file that will be there again but with a different database name. Split the file in two, saving them both as .sql files
    Try importing those.

    ok, pasted and executed successfully.

    “Your SQL-query has been executed successfully:
    The content of your file has been inserted. (: 1510 Instructions) “

    Now the wordpress location comes up blank… DB_NAME, DB_USER, DB_PASSWORD and the table prefix are all correct.

    I can see all the appropriate tables on the left hand list, so I think the database is correct. As for what’s screwing up the connection, I’m not really sure.

Viewing 15 replies - 1 through 15 (of 22 total)
  • The topic ‘New Host , Restore database’ is closed to new replies.