site hosted locally. Problem transfering it my DB got damaged. WordPress
I need help.
I had a local hosted WP site. WHen I was moving the DB (exporting/importing) somewhere in the middle it got damaged and now I cant access my old local site. Please help
Answers (4)
Joshua Nelson answers:
You'll have to access your phpMyAdmin through your host, and export the database entirely. Then, create a new WordPress installation on a subdomain (example.com/test/) and a new, separate database. Once that new WordPress install is running, import the old database via phpMyAdmin. Use [[LINK href="http://interconnectit.com/products/search-and-replace-for-wordpress-databases/"]]this tool[[/LINK]] to search and place the old domain name and the new one.
Here are some great instructions on migrating a WordPres installation: [[LINK href="http://www.billerickson.net/migrating-wordpress-websites/"]]http://www.billerickson.net/migrating-wordpress-websites/[[/LINK]].
If you do all that and the new installation with the imported database still fails you might need more specialized assistance.
cgscheer comments:
Can you help me.
I do have access but Im a big mess with this.
I have access but when I do a new dB and upload the old one the site goes blank.
Also, The old one doesnt open anymore to do any changes
Joshua Nelson comments:
I can help you, sure. Direct message me the site and login info and I'll see if I can figure it out. Did you originally use the WordPress built-in import/export functions or were you importing/exporting the .sql file from phpMyAdmin?
Joshua Nelson comments:
I will be offline for probably the next hour, but can look at it after that - if it is straight forward enough it shouln't take too long. If it isn't straight-forward we'll have to adjust our plan.
cgscheer comments:
ok. The site is: www.hydroindie.com
login: jorge
pass: password
please let communicate via email.
[email protected]
Many thanks.... this is a critical issue I need to fix.
Thank you
Joshua Nelson comments:
Okay, I think I see the issue. I sent you two emails with instructions, hopefully we can figure it out from there.
Hariprasad Vijayan answers:
Hi,
Can you please tell what kind of error that you are getting while accessing old site. Normally exporting the database will not affect original.
Abdelhadi Touil answers:
Try to use this tool, it's very good:
[[LINK href="http://www.ozerov.de/bigdump/you-need/"]]http://www.ozerov.de/bigdump/you-need/[[/LINK]]
For the broken blog, have tried to repear the database via phpMyadmin?
Sabby Sam answers:
Hi,
The simple instruction is :
Open your phpmyadmin download the your database file.
Open it with notepad.exe
Go to Edit -> Replace
(cntrl + h )
Type Find what -> localhost:8888
Replace with -> www.hydroindie.com
click on replace all.
Once done this option, re-upload all your modified file to PHPMyadmin.
It should work 100%. What you have done is you worked on your localhost so localhost doesn't have main domain. You need to change the exact url.
Hope this will work for you.