Unfortunately due to the nature of the ccgi platform we use PHP with suexec, which means we have to use PHP in cgi mode rather than an apache module.
Also, we don't allow DirectoryIndex to be used in an .htaccess file, so it will fail. It is currently set as below:
DirectoryIndex index.html index.html.var index.htm index.shtml index.cgi index.pl index.php
If that .htaccess file doesn't have anything else in that isn't commented out, you don't need it.
To extract the file and import the sql you'll need a script like the one below, put your details in the section at the top.
#!/bin/bash
##### EDIT THESE DETAILS #####
# Input details
TARFILE=name.tar.gz
SQLFILE=name.mysql.sql
# MySQL details
USERNAME=your_username
PASSWORD=your_password
SERVER=rumpus_or_humbug
DATABASE=your_database_name
###### DO NOT EDIT BELOW THIS LINE #####
echo -e "Content-type: text/plain\n"
echo -n "Extracting Tar file: "
tar xzf $TARFILE
if [ $? -ne 0 ]
then
echo "Failed"
exit 1
else
echo "OK"
fi
echo -n "Importing mysql database: "
mysql -u$USERNAME -p$PASSWORD -h$SERVER $DATABASE < $SQLFILE
if [ $? -ne 0 ]
then
echo "Failed"
exit 1
else
echo "OK"
fi
echo "All done"
exit 0
Call this script 'install.cgi', and upload it to xx. Give it execute permissions and then browse to it in your browser. It may take a few seconds to run, be patient.
