Usually what is required is time for DNS to promulgate… discuss with host…once your new IP address (as assigned in DNS) with this host resolves in DNS properly you can access your site…this is normal…24-72 hours…you can also contact your host if you feel there is still an issue… discuss WP and Nameservers.
If your sites DNS has propegated to the new wever, then it sounds like your site is pointing to a different DB that’s just the standard install. The “Sample Page” is what’s shown as a default when you first install. I’d double-check your database connection details and make sure that the DB that you’re connecting to is the one that you imported your data to, and that the DB prefix that’s set up in your wp-config.php file is correct for the new DB as well.
Hi Seacoast Web Design member…
Thanks,
We are long pat the promulgation period. DNS is set up, for over a week. Site files upload too, yesterday I got the SQL database from the old host/webmaster and had trouble getting it imported. That problem is resolved. But still, I get only the sample page. I have poured over the config file, discussed it with the host, all seems in order…but I expect I have missed something in the config and sql file modifications….just not sure what, if that.
I got the SQL database
Do you mean MySql?
sql file modifications
What did you mod?
have missed something in the config
What do you mean by ‘config’?
Hi Catacaustic,
I have reduced all to one database…and the DNS is pointing to the right location, config files modified to reference that DB. database. This thought just occurred… There was a zen cart dedicated database with the old site. As I am ditching Zen cart I did not import that, but the site files have been moved to the new host lock stock and barrel, could that be the issue.
Another thing that has me suspicious is the format for this:
phpMyAdmin SQL Dump
— version 3.3.10.4
— http://www.phpmyadmin.net
—
— Host: xxxxxxxxxxx
— Generation Time: Feb 04, 2013 at 05:14 PM
— Server version: 5.1.53
— PHP Version: 5.2.17
What should that host name format look like? I have the database number as x as follows. “xxxxxx.db.1and1.com”
Seacoast,
yes I meant the MySQL DB file exported from the old host. Modified the database name and the “use” references. I deleted the create a new database line.
I modified the wp-config.php files:
DB_name (to where the worpdpress files reside)
SQL DB password
MySQL hostname
all were pointing to the old host.
The text that you’ve shown from the dump there is pretty generic and is almost exactly what I got when I did a test export form my own phpMyAdmin installation.
I am not sure what you mean by “database number”. Databases hav enames, so I’m thinking that’s what you mean? I also think that “xxxxxx.db.1and1.com” sounds more like the DB server then the DB name, but I’m not familiar with their setup so I could be wrong.
One thing ot look at: What is the prefix that’s used on the tables in your DB? Most times it’s ‘wp_’. Also what is set in your wp-config.php file for $table_prefix? If they are not the same, then you need to change the value for $table_prefix.
If that is the same, check with your hosting company just to double-check that you are pointing to the right DB and that you only have one single DB set up for your account.
It still sounds like there’s either two DB’s or the DB prefix is wrong.
Make sure not to cut and paste too quickly.
Catacaustic,
On a MySQL database creation at 1&1 they give a database name in the format db1234567. We can provide a description but not change the name. The host name is that db number followed by a .db.1&1.com. The domain name is set set elsewhere.
I personally deleted all other MySQL database listings. There is only one, and I have used correct database name, user name, and host name in the config file. I have checked and rechecked those numbers, and uploaded the correct wp-config.php file to the correct destination. It just doesn’t make sense. Guess I will have to get the host back on the line….and have them go through my files.
LOL…They are ok, very responsive on calls and helpful. But I was thinking this might be a word press related problem.
Have you checked the prefix used on the DB tables and that it matches the prefix that’s specified in your wp-config.php file?
If that is the same, and you are 100% sure that you have the correct DB details (not saying that you don’t, but I’ve seen people on here swear they are right only to find out that they were wrong 3 weeks later), then there’s two possibilities:
First, your host has given you the wrong DB information and you’ve imported the old DB file into the wrong database.
Second, your hosts DB server is having issues and they’ll need ot sort it out.
Unfortunately neither of these things can be verified by you by yourself. You need your hosting company to check and verify this for you.
^^^^^^^ <=====Better host?
