Backup via FTP

I have a 1and1 linux business account which provides 250Gb of storage and more email accounts than I could ever need. The only restriction that I run into is the maximum number of files of 262,144. I’m nowhere near the 250Gb maximum file usage.

A few weeks ago I received an email from 1and1 saying that the price for the linux Business service would be going up from $9.99/mo to $13.99/mo in May. At the same time, there would now be unlimited web space, email accounts, MySQL database, subdomains, etc. However, the email made no mention about a change in the maximum number of files.

The cost of online storage options keeps going down whether it’s 1and1, Google, Amazon S3, Dropbox or the new Amazon Cloud Drive .

It would be nice to have a simple backup utility that will backup via FTP to a storage service of your choosing. With 1and1, it would be great if that backup would be to a single file to bypass their file limit. In searching for ftp backup utilities, I found a lot of really old utilities but eventually came across Cobian Backup. I’ve spent a couple of days trying out Cobian backup and it works well and is free. The user interface isn’t initially intuitive but watch this short YouTube video and you’ll be using it in no time.

For my purposes, I’ve found a couple of other options that work well. Under the Archive setting, I select 7z compression because I had a problem with zip compression. I also set up the file to be split into DVD size (4.3Gb) files so that I can download the backup in reasonable size pieces and because Cobian compresses the files on local storage so you’re going to need some amount of free space on the local hard drive if you use their compression option.

Installing WordPress on 1and1 Servers

WordPress 3.0.x installs on 1and1 servers pretty much as documented in the standard installation instructions found here.

In fact, the Famous 5-Minute Install steps found on this page work great but start the 1and1 MySQL db creation now if you want to have a chance of completing it inside of five minutes.

However, you will want to insert the php5 related entries in your .htaccess file as described in some of my other 1and1 related posts and here.

Create a file in the home directory of your site called .htaccess with the lines:
AddType x-mapp-php5 .php
AddHandler x-mapp-php5 .php

Installing SugarCRM on 1and1

Here are the steps I took to install SugarCRM CE 6.1 from http://www.sugarforge.org on a 1and1 linux developer package account.

– Start creation of MySQL DB on your 1and1 account since this takes a while.

– Create new URL on 1and1 server and point to directory that will hold SugarCRM.

– Download from http://www.sugarforge.org (An alternative version can be found here http://www.sugarcrm.com/crm/download/sugar-suite.html)

– Unzip the downloaded file in your new home directory

– Create a file in the home directory of your site called .htaccess with a single line: AddType x-mapp-php5 .php

– SugarForge documentation can be found here – http://www.sugarforge.org/frs/?group_id=6.  Search for the install guide.

– Browse to http://<url>/install.php

– Follow the screens, chose Typical install.

– During the install step, the config.php file is created.  Open the config.php file and file the lines that set dir_mode and file_mode.  Change their values as follows:

‘dir_mode’ => 1517,
‘file_mode’ => 420,

– You may also have to remove the cache directory if the webpage does not display correctly

– There are multiple postings out there on how to get email to work with 1and1 (as well as GoDaddy).  Here are the postings I ran across, only the first one worked for me:

SMTP Mail Server: mrelay.perfora.net (NOT smtp.1and1.com)
SMTP Port: 25
Use SMTP Authentication: checked
Enable SMTP over SSL or TLS?: -none-
Username: xxx@xxx.com
Password: xxxxxxxx

SMTP Mail Server: 74.208.5.2 (NOT smtp.1and1.com)
Use SMTP Authentication: Checked Yes
Username: XXXXX@s320849284.mialojamiento.XX
“From” Address: XXXX@XXXX.XX
SMTP Port: 587

SMTP Mail Server: smtp.1and1.com
Use SMTP Authentication: Checked Yes
Username: XXXXX@s320849284.mialojamiento.XX
“From” Address: XXXX@XXXX.XX
SMTP Port: 587
Enable SMTP over SSL or TLS? : None
Password: XXXXXXXXX

SugarCRM discussion forums can be found here – http://www.sugarforge.org/content/community/.  Most of the solutions to the  problems I encountered with the 1and1 install were solved on these forums.

Note: The logfile for Sugar problems is called sugarcrm.log in the home directory.

Note: To Setup Crontab Note: In order to run Sugar Schedulers, add the following line to the crontab file:
*    *    *    *    *     cd /homepages/27/d242477116/htdocs/prolin; php -f cron.php > /dev/null 2>&1

Duplicating a Joomla Website on 1and1

The first place to look for general steps to make a duplicate copy (at another directory and URL) of an existing Joomla site is here – http://docs.joomla.org/Copying_a_Joomla_website

This is intended to be a shorter version of what’s described above with some specific steps for 1and1.

I’m working with a 1and1 linux developer account which means I have ssh access.  Make sure there are no changes being made to the site during this process.

1. Use the 1and1 admin interface to create a new MySQL database for the new website. This can take 5-10 minutes so start it now.

2. Copy source directory contents to target directory.
cd <src-dir>
tar cvfz <target-dir>/sourcefiles.tgz *
cd <target-dir>
tar xvfz sourcefiles.tgz

3. Make a backup of the existing Joomla sites MySQL database. Use the 1and1 phpMyAdmin tool to do an export.  I choose the default no compression option and saved the results to an ascii file on my local PC (good to have a backup of the db – it saved me work the first time I did this – see below). If you’ve never done this before, 1and1 has an FAQ on how to export and import MySQL databases using phpMyAdmin.

4. Import the database you just exported to the newly created MySQL db.
– Remove the “CREATE DATABASE” and “USE” lines near the beginning of the exported database sql file
– Start phpMyAdmin on the new database
– Choose the icon for the SQL query window in the upper left hand corner (see the online help if you can’t find this)
– Paste the exported sql from the source database into the window and hit Go
– Watch for the status of the import in the main browser window, you should see the number of lines executed

5. Critical first step to using your new site. Login to the new Joomla sites’ admin interface (http://<site>/administrator). Browse to Site > Global Configuration and change the MySQL parameters Hostname, Username, Password. If you don’t do this first, you’ll be editing the old sites database from the new sites admin GUI.

You now should be all set to use your new site.

JoomlArt Quickstart Template Install on 1&1 Servers

If you’re using the Joomla templates from JoomlArt they have quickstart versions of the templates which allow you to install your own copy of their demo version on your own Joomla server. If you’re not familiar with JoomlArt, check out their example templates here.

To view much of the information that follows and to download the JoomlArt templates, you’ll need to purchase a subscription with JoomlArt.  A description of the subscriptions options can be found here. I purchased the Standard Membership for $59/year.

User guides and instructions on downloading and installing the templates can be found in the JoomlArt forum for the template you’re working with.

Quickstart Install on 1&1

The Quickstart zip file for each template can be found with the rest of the downloads for that template (go to the main JoomlArt Templates Page, select the template you’re interested and then the Download link on that page). The install instructions for the JoomlArt quickstarts can be found here.

Unforunately, there’s a problem with the format of the quickstart zip files that does not allow you to un-zip them on linux servers.  Here are the steps I used to install the quickstart template:

1) Create a home directory on 1&1 for your quickstart JoomlArt site. You won’t need to install the standard Joomla bits from joomla.org.  Just leave the directory empty.  However, you will need to do the 1&1 setup steps described below – create the domain and a MySQL database.

2) Download the quickstart template to your PC. Note that JoomlArt quickstart templates are contained in a “quickstart” subdirectory inside of the template zip file that you download from their website. Within the quickstat subdirectory is another zip file (zip within a zip) that contains the quickstat files.

3) Un-zip the quickstart zip file to it’s own directory and make sure you maintain the folder structure during the un-zip.

3) Use FileZilla or another ftp program to copy the entire un-zipped directory structure to your Joomla site’s home directory.


Scratch and Reinstall Joomla on 1&1

It’s easier to do a new install.  With SSH access to your 1and1 account, here’s what I do (using the existing MySQL db which will be scratched).

1) Rename the directory (just in case I want it back)

2) Make another directory with the original name (the directory that your 1&1 domain is pointing to)

3) ftp the Joomla zip file to the root directory and un-zip it.

4) Browse to the URL and follow the normal installation instructions (see my blog entry on that) except that on the Database Configuration page, select the Delete existing tables option in the Advanced Settings.

Joomla Setup on 1and1

How to setup Joomla on 1and1 servers (assuming you have ssh access).

1) Login to your 1and1 admin page and create a new MySQL database for your new Joomla website (this will take a few minutes so lets start it right away).

2) Download the latest .zip from http://joomla.org

3) FTP it up to your 1and1 home directory.

4) SSH to your 1and1 account.

5) Create the directory that will host your Joomla site and copy the Joomla zip file to it.

6) CD to the home directory and unzip the Joomla zip file.

7) Go to the 1and1 domain admin page and setup a domain or subdomain for your Joomla site and set the home directory to the directory you created in the previous step.

8 ) In a web browser, go to http://<your-domain>, and follow the prompts until you get to the ftp step.

9) For the ftp, select Yes and enter your ftp login and password. The home directory should be /<directory> with the name of the directory you created two steps back. Click the Advanced box and set the FTP Host to the domain name you setup in the prior step. Click Yes to save the ftp password. Click the Verify FTP Settings and if it fails, try the Autofind FTP Path option.  Then, click Next

10) On the main configuration page, click “Install Sample Data”, then click Next and follow the remaining steps.

11) Create a file in the home directory of your site called .htaccess with a single line: AddType x-mapp-php5 .php

Here’s another take on setting up Joomla on 1and1 – http://sschill.wordpress.com/2010/01/12/installing-joomla-on-a-1and1-com-hosted-site-manually/