Uploading Prosper202 GEOIP Database remotely on memory limited hosts.

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.

Then I scp’d or ftp’d my GEOIP database up to another host with mysql command line access.

Then I simply issued this command, and it imported it for me. No Fuss, no Muss.

# mysql -h HOSTNAME -u USERNAME -p DATABASENAME < geoip_database.sql

When you press enter, it’ll ask you for your password, and then take a few minutes to pop the content over. Now you’re done.

Note my database went up from .5 megabyte, to 50 megabytes after the import, so make sure you have the space available on your host.