Hosting Joomla! at One and One
Last Updated on Saturday, 28 February 2009 18:54 Written by Administrator Sunday, 25 January 2009 17:46
I've been using the "One and One" hosting provider for several websites. Their system works and is cost effective. But can a Joomla! site be hosted under it?
The simple answer is "yes", as long as you are prepared to have the "business" package or above. This is because Joomla! requires a database. The "Business" package allows two databases, each with 100MByte size limit. The size seems not to be a problem, because the pages themselves tend not to be very large; added media (.PDF files, images etc) are stored in separate folders outside the database.
The PHP code seems to have a 40Mbyte memory size limit imposed, which causes problems for some image manipulation components.
Uploading a website to 1&1
It's generally recommended to create a site initially on a local host, then copy to the live hosting server when it's ready. This is sound advice: but the task of getting it there isn't as simple as is described. Don't use an FTP program: it will be a lot slower, and more prone to error. An issue that isn't listed anywhere is that the files that need to be copied include a "logs" directory; but that will be readonly. So any attempt to write to it will fail.
To copy the files to the server: zip them up, and copy up the zip files using the web space access mechanism through the 1&1 admin site (or by an FTP client). Then unzip the files through that mechanism. Do NOT copy the files one by one using FTP - it will take ages.
Copying the database was a challenge. Again, through the 1&1 admin pages, you can create the database but it is likely to have a different name from that on your local host. Backup the database from the local host using PHPMyAdmin; then edit the output file from that. Insert a line near the beginning "USE db xxsxxxxxx" where xxxxxxxx is the database name you've created. Click the "sql" tab in PHPMyAdmin, and select "import". if the database has already been used, you will need to delete the existing tables using the "drop" command.
