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.
http://www.juliefilms.com/index.php
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 ( http://www.tamba2.org.uk/wordpress/empty-drop/ )
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 🙂 )
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
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 21, 2005 at 04:39 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.11
--
-- Database: wp_wordpress`
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.
