yes, it is possible to use power gallery locally if you have a local testing server installed.
see our learning resources page for details on installing a local testing server:
tutorials.php
when you wish to upload to the remote server, you would need to export the local database using PHPMyAdmin or another MySQL GUI Tool, then import it to the remote server, and edit the power gallery database connection file to use the remote mysql server.
there are a number of tutorials for exporting a database using PHPMyAdmin around the web, here is one of them:
mysql_export.htm
