Prosper202

Today I was faced with migrating my P202 installation from one host to another. As normal, I ran the mysqldump command on the old server to dump the database and scp’d it over to my new host – went to import and I got a bunch of errors like this; ERROR 1016 (HY000): Can't open file: './202_SITENAME/202_locations_block.frm' (errno: 24) ERROR 1016 (HY000): Can't open file: './202_SITENAME/202_locations_block.frm' (errno: 24) ERROR 23 (HY000): Out of resources when opening file '....

Like me, you may be hosting your Prosper 202 installation on a cheap hosting account. This may lead to issues if you want to import the GEOIP database so you can track by country. Many hosts won’t allow a file this large (20 something megabytes) via phpmyadmin. So, how do you get around this? In my case, it was pretty simple. I went to the control panel for my hosting, added a new database user that was allowed to connect from anywhere....