WampServer

Hi everyone,

Got a problem that I can't solve. My Wampserver works just fine locally, on PC.

But I decided to move my local wordpress site online.

1. Uploaded the files to a server
2. Created new database and erased all the tables/elements
3. Exported the database from my local PhpMyadmin
4. Imported the database to the online created one
5. Edited wp-config.php - linked it to the database.

THE PROBLEM:

Looks like the wordpress can't read the imported database tables, but wp-config is linked to it properly.

When I open the website online I get the standard Wordpress installation page. When I install it, the tables in my database are duplicated - I have the ones I imported by myself, and the ones that the wordpress installation creates. And I got the basic Wordpress site - not the one I have created localy on Wampserver.

This is my first try with Wampserver. Are there any php - sql issues that I should now about ?

Nope, you just did sonething wrong .

Tell me why you created a database then deleted the tables before importing...

This step sea where yu made all your mistskes

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi Steven,

Thank You for reply.

Well it must have been late yesterday... Today I create a new database in my hosting service, than I go to PhpMyAdmin and I have an empty database with no tables.

So I import the database, but at the and I get the same result as I previously mentioned. New wordpress installation and duplicated tables in PhpMyAdmin.

I noticed that there is a difference betwen the look of database tables in Wampserver localhost and the same database imported to online PhpMyAdmin. It's about wp_prefix_options table.

Here are the screens:

Localhost Wampserver database: [www.dropbox.com]

Database exported from Localhost and imported to online : [www.dropbox.com]

The online database tables duplicated after Wordpress installation, so there is a proper database connection : [www.dropbox.com]

What I might do wrong ?



Edited 1 time(s). Last edit at 08/19/2012 12:59PM by vieckowski.

the record are the same at 225...

so why do you think there is duplicate content? i dont see these duplicate tables you mentioned....

the reason for the increase in size is probably due the the default char set being different on the servers

latin vs utf8

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> so why do you think there is duplicate content? i
> dont see these duplicate tables you mentioned....

Thank You for You time...

The third screenshot.

What I meant was... I import the database, but wordpress doesn't read the tables, so after opening the site url I'm landing at Wordpress installation page. Wordpress should get the data from tables at this point but it gives me new instal instead. So I enter Name, Username, Password, Email, cause I can't do nothing else. After installation has ben made, there are two sets of tables - the one I imported, and the one just fresh created by inastallation process, which the site is connected to.

I have no idea why Wordpress doesn't import data from my imported database. The connection is working though ?

You have capItal letters in one set of tables and no caps in other tables in the duplicate

Unix based systems don't support uppercase letters in MySQL

When u export you can demand lower case and in the wpconfig make sure it matches

If you want to get Teamviewer I'll take a look at this for you

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 08/19/2012 03:18PM by stevenmartin99.

SOLVED !

Thank You Steven. The database was exported correctly - no uppercase. But somehow in wp-config, in my custom wp_table prefix I have inserted one uppercase letter.

Thank you so much!