moving prosper to a new server

[opinijus]

Hey,

How to move Prosper to a new server without loosing an old data? I could get an answer on Prosper forums, but it takes 2-3 days till staff answers question. Furthermore, they don't have a search feature... :/

Thanks

 

[Derek Pankaew]

Upload Prosper 202 to your new server. Then go into your old server's Cpanel, go to PhpMyAdmin and export all the databases with data (Landing Pages, Text Ads, Trackers, Keywords just off the top of my head.) Manually go through and export all the data.

Then go into your new prosper and import all the data files in PhPMyAdmin.

Wala.

 

[Yaxxx]

Wala.

Voila*

 

[opinijus]

Wala.

Thanks!

 

[majorbta]

An easier way to do it is just do a full download of the single database, instead of all the tables individually, ftp the downloaded database onto your new server, SSH in the new server, and dump the downloaded database into the newly created one. Took me 5 minutes tops, instead of trying to do it manually.

No to mention, phpmyadmin has a 53mb limit on sql uploads, so if you have a lot of clicks several of your tables will be bigger thanthat

 

[testonej]

Another thing to keep in mind is if you do the export/import method you will need to zero out some of the new tables before you import because you will get duplicate record errors. Also, make sure you are on mysql 5.1 so that you can take advantage of partitioning and use the updated partitioning script that I wrote from this thread:


http://www.wickedfire.com/affiliate-marketing/53426-fix-some-prosper202-speed-issues.html

Feel free to IM or PM me if you need any other help.

Best of luck!