Smart people... I need your help :-)

Shannon Herod · 08-16-2009, 08:16 AM

Hey Everyone,

OK, I need some help here. I had a blog that was hacked and my hosting company did not back it up because I have to much information.

Lesson learned. Do not rely on a third party to do your backups.

Any way, I had to reinstall wordpress, but I did hot overwrite the old data base.

So, I have access to the posts from the old database. I want to take the data from the old data base and upload it to the new data base.

Can I do that and if I can please PM me a quote.

I have the posts from the old database downloaded in CSV format and .XML format.

I tried doing it myself with no luck.

Thanks,

Shannon

Intrepreneur · 08-16-2009, 08:21 AM

You may have to rename your database and a new install (if done from fantastico) will have a generic database name.

Find config.php and look for database name and password..

Once finding that then upload your saved databse, rename to what is in the config.php file, add the same user and password and it should connect ok.

BIG Mike · 08-16-2009, 08:27 AM

For those of you looking to manage your MySQL data from one location, including backing them all up with the click of a button, here is a product I use:

Navicat Oracle, MySQL Admin Tool - the World's Best Oracle Manager, MySQL GUI & PostgreSQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, ph

This is not one of my products and it's not an affiliate link - it's a fantastic product if you work with more than a couple of dabases and need centralized management. I've used it for years and it literally saves me 12 to 15 hours per week!

TristanPerry · 08-16-2009, 08:29 AM

I'm not sure how to port in the data since it's in .xml format, but if you had the full database it's simply a case of setting up a new database, importing the data in, and then changing the configutation file to point to the new database.

But yeah, sorry to hear that your old host didn't bother to keep proper backups. I assume it was HostGator or another crappy extreme overseller? As a note (I know it's too late now!), always check with a host that they will *always* backup your data. Plus keep backups yourself. Even a quality host who keeps daily backups can make mistakes (or be targetted by a very malicious hacker, etc)

Brad Gosse · 08-16-2009, 08:33 AM

Try this plugin

Importing Posts from CSV file into WordpressbyZack Preble

I have used it to populate blogs with future dated posts. THis should work for you.

Shannon Herod · 08-16-2009, 08:42 AM

Quote:

Originally Posted by Intrepreneur

You may have to rename your database and a new install (if done from fantastico) will have a generic database name.

Find config.php and look for database name and password..

Once finding that then upload your saved databse, rename to what is in the config.php file, add the same user and password and it should connect ok.

Dude, That worked perfectly!! You are the MAN!!!!

Shannon

Intrepreneur · 08-16-2009, 08:51 AM

Quote:

Originally Posted by Shannon Herod

Dude, That worked perfectly!! You are the MAN!!!!

Shannon

Glad you got it fixed. Now go blog some more

08-16-2009, 08:16 AM	#1
Shannon Herod Focused2Win.com War Room Member Join Date: Aug 2004 Location: Florida , USA. Posts: 2,355 Blog Entries: 18 Thanks: 73 Thanked 519 Times in 231 Posts Social Networking Contact Info	Smart people... I need your help :-) Hey Everyone, OK, I need some help here. I had a blog that was hacked and my hosting company did not back it up because I have to much information. Lesson learned. Do not rely on a third party to do your backups. Any way, I had to reinstall wordpress, but I did hot overwrite the old data base. So, I have access to the posts from the old database. I want to take the data from the old data base and upload it to the new data base. Can I do that and if I can please PM me a quote. I have the posts from the old database downloaded in CSV format and .XML format. I tried doing it myself with no luck. Thanks, Shannon
	Click Her For Instant Access To The "Inner Circle"

08-16-2009, 08:21 AM	#2
Intrepreneur I.C.Hope War Room Member Join Date: Apr 2009 Location: Northern Ireland Posts: 2,515 Thanks: 446 Thanked 227 Times in 181 Posts Contact Info	Re: Smart people... I need your help :-) You may have to rename your database and a new install (if done from fantastico) will have a generic database name. Find config.php and look for database name and password.. Once finding that then upload your saved databse, rename to what is in the config.php file, add the same user and password and it should connect ok.
	I want a good keyword researcher, not for min sites but for tech articles. Hit me up if you've got those skillz!

08-16-2009, 08:27 AM	#3
BIG Mike Drunken Greek War Room Member Join Date: Dec 2004 Posts: 9,630 Blog Entries: 1 Thanks: 1,847 Thanked 3,671 Times in 1,070 Posts	Re: Smart people... I need your help :-) For those of you looking to manage your MySQL data from one location, including backing them all up with the click of a button, here is a product I use: Navicat Oracle, MySQL Admin Tool - the World's Best Oracle Manager, MySQL GUI & PostgreSQL GUI for Windows, Linux & Mac OS X - Download Now! Support Access to MySQL, Excel to MySQL, MySQL editor, MySQL administrator, MySQL frontend, MySQL manager, ph This is not one of my products and it's not an affiliate link - it's a fantastic product if you work with more than a couple of dabases and need centralized management. I've used it for years and it literally saves me 12 to 15 hours per week!

08-16-2009, 08:29 AM	#4
TristanPerry Advanced Warrior War Room Member Join Date: Aug 2009 Location: Cardiff, United Kingdom Posts: 772 Thanks: 171 Thanked 147 Times in 103 Posts Social Networking	Re: Smart people... I need your help :-) I'm not sure how to port in the data since it's in .xml format, but if you had the full database it's simply a case of setting up a new database, importing the data in, and then changing the configutation file to point to the new database. But yeah, sorry to hear that your old host didn't bother to keep proper backups. I assume it was HostGator or another crappy extreme overseller? As a note (I know it's too late now!), always check with a host that they will always backup your data. Plus keep backups yourself. Even a quality host who keeps daily backups can make mistakes (or be targetted by a very malicious hacker, etc)
	"If you are clear where you are going and you take several steps in that direction every day, you eventually have to get there."

08-16-2009, 08:33 AM	#5
Brad Gosse Senior Warrior Member War Room Member Join Date: Jan 2009 Location: Orangeville, Ontario Posts: 2,906 Thanks: 1,311 Thanked 1,070 Times in 566 Posts Social Networking	Re: Smart people... I need your help :-) Try this plugin Importing Posts from CSV file into WordpressbyZack Preble I have used it to populate blogs with future dated posts. THis should work for you.
	Vegan Recipes \| Vegan Desserts \| Vegan Diet Click here if you want me to promote your product(s)