Posted 2 years ago #
So I am having some trouble using an old database for my new WordPress site.
I have done alot of searching and found that I could use my old database if I edit the wp-config.php file. However, when I did this and put in all of the information, my site was coming up with a 500 error.
Does anyone have any suggestions? I'm really having a hard time with this.
Posted 2 years ago #
for the table prefix, instead of wp_ make is wp1_
Posted 2 years ago #
it half worked,
I can access my site now, however my posts and stuff aren't there though?
that was bad advice
can you just use the old wp-config.php?
you should be able to put the correct database name, user, pass and connection as the old site
should have the same table prefix as the old site
Posted 2 years ago #
samboll,
I tried that first but my whole blog went down and i was getting a 500 error.
with chkorspaks advice (editing the table prefixes to 'wp1_'), i was able to get the site back working, but I still don't have my old posts or anything.
Posted 2 years ago #
did you download a xml of your old website posts?
Tools => Export
Once you have that, you can import the posts into your new website
just changing the table prefix gives you a fresh install - no posts or comments from old database
have you tried going to host's phpmyadmin and just importing the database?
http://codex.wordpress.org/Backing_Up_Your_Database
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
Posted 2 years ago #
chkropsak,
I did not, because our hosting was switched and when it was I was no longer able to get on to the blog. This is partially why we created a new blog.
Samboll,
I was thinking about your method, we do not have phpmyadmin. I am going to download it Monday and try that
Posted 2 years ago #
ok guys, so I've decided not to go with PHPmyAdmin because it is too confusing. I have a limited knowledge of all this stuff.
We already have MySQLAdministrator (MySQLWorkbench). Would I be able to import the database with this program? Can someone guide me through this?
You could use the MySQL command line to backup and restore your database:
http://codex.wordpress.org/Backing_Up_Your_Database#Using_Straight_MySQL_Commands
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
This topic has been closed to new replies.
