When loading website, get white screen no image, no front page.

Yes, make a copy of the xxxxx.sql file then edit it. Comment or remove the ‘create database…’ statement and import the file and test.

If the site still has issues then something must be messed up in the database.

@juggledad, sorry to be a pain, but where and which xxxxxx.sql file? where would I find it?

Don’t you have an export of your database ? That is the xxx.sql file

ok, I’ve emptied the database of the tables and did an import of the website, still same problem.

If I have to rebuild the site is there a way to import the tables such as the blog which is the most important into the new database? if so, what is the command?

Thanks

update:

I’m now getting a message
Error establishing a database connection.

I’ve changed the database password, re-entered the username
checked wp-config.php file to make sure its right.

Anything I missed?

If you get the error connecting msg then your credentials in the wp-config.php are wrong but they should be the same as they were before you did the import.

All of the posts will be part of the import.

Check the import for errors.
See if you can access the db with phpmyadmin

Yes, I can access the database in phpmyadmin and no there are no errors.
Do I have to keep the same credentials or can I change them in phpmyadmin?

I have an question ,is the user name and password in MySQL supposed to be the same as the username and password in WordPress.
For example in both there is the same username however the passwords are different. Would that cause a problem?
Let me be clearer
In MySQL there is the MySQL DB and there are other DBs.
The one that is for the WordPress DB has a username and password this matches the WP-confit.php file.
There is also the MySQL DB that took has the same username but a different password.
Would this cause a problem?
I can see how it would since WP confit is looking for a username and password that matches what is entered.

Hi Jon,

1) No WordPress admin and mysql are never the same – it should’nt for security reasons too
2) Are you using wordpress in multisite?

Jon, Sorry I didn’t reply earlier, I’ve been traveling and just got back.

depending on your host, you might have your own instance of mysql where you can create as many databases and as many users as you want OR you might be limited to one database and one user. so the answer to your questions ‘it depends’

MySQL users are different than WordPress users. WordPress users are stored in the WordPress database (a MySQL user database) while the MySQL users are stored in one of the MySQL system databases.

If youa are creating your own databases and users, then the user you create for the WordPress database is the user you name in the wp-config.php

If you have a script that creates the user and database, then that is the user that goes in the wp-config.php
In either case, you should not use that username/password as the WordPress admin.

So you could use the same user/pw that you use to access phpMyAdmin in the wp-config.php and that should get you pass the connection error so you can see if the site works.

@digico it’s a single site. It’s my own website and I host no other website.

@ juggledad it’s what I had thought.

Guys since I’ve decided to rebuild the website, my only question is can I pulled from a exported database information such as my blog and if so I assume this exported database has to be imported in MySQL for that to happen. Is this the correct assumption to make?

Since you have access via phpMyAdmin and have access to the WP database, you can go to that DB and do an export of teh wp-posts table and have all your posts BUT you won’t have the meta data that goes with the posts (tags, categories, images, comments, author). If you can get into the site you can go to dashboard->tools->export and export the post, pages or all your content.