Premier Predictions 28/11

Lets try again:
Sat 28 Nov 2009,Aston Villa, 2,1 ,Tottenham, 17:30
Sat 28 Nov 2009,Blackburn,2 ,0 ,Stoke, 15:00
Sat 28 Nov 2009,Fulham, 1,0 ,Bolton, 15:00
Sat 28 Nov 2009,Man City, 2,0 ,Hull, 15:00
Sat 28 Nov 2009,Portsmouth, 0,4 ,Man Utd, 15:00
Sat 28 Nov 2009,West Ham,1 ,1 ,Burnley, 15:00
Sat 28 Nov 2009,Wigan, 1,1 ,Sunderland, 15:00
Sun 29 Nov 2009,Arsenal,0 ,2 ,Chelsea, 16:00
Sun 29 Nov 2009,Everton, 0, 1,Liverpool, 13:30
Sun 29 Nov 2009,Wolverhampton,1,2 ,Birmingham, 12:00

Super Crystal Palace 3 - 1 Watford (Wish I was there today)

Premier Predictions

These are my Premiership predictions.

Sat 7 Nov 2009,Aston Villa, 1,1 ,Bolton, 15:00
Sat 7 Nov 2009,Blackburn, 2,0 ,Portsmouth, 15:00
Sat 7 Nov 2009,Man City, 3, 1,Burnley, 15:00
Sat 7 Nov 2009,Tottenham, 3,1 ,Sunderland, 15:00
Sat 7 Nov 2009,Wolverhampton,0 ,3 ,Arsenal, 17:30
Sun 8 Nov 2009,Chelsea, 1,1 ,Man Utd, 16:00
Sun 8 Nov 2009,Hull,0,1 ,Stoke, 13:30
Sun 8 Nov 2009,West Ham,2 ,0 ,Everton, 15:00
Sun 8 Nov 2009,Wigan, 0, 1,Fulham, 15:00
Mon 9 Nov 2009,Liverpool, 2,0 ,Birmingham, 20:00

Also will say that my team Crystal Palace will beat Boro 3-0

Beatles USB Memory Stick

Just spotted one of the best USB memory sticks that we know about:
Beatles limited edition memory stick with their full Entire Digitally Remastered Catalogue.

If I had a spare £200 I would be very interested, it's a great design.

Copied the image below and the link is direct from the site:


The stalk is where the USB hides and it is best to get over to the site for a proper look.

Site link to the Beatles store here

Time to search down the sofa for the missing money......

Joomla Backup and Restore

Joomla Backup and Restore
We have been testing backup and restore tonight on my hosted site to a localhost. It didnt go quite to plan and we will try and post where we went wrong to try and help others.

Create a backup of your database. We are not experts and used the hosting company to help us out.

* We had to use a command line to get the database as we could not use phpMyAdmin with our hosting company.
* We used SSH Secure Shell from http://www.ssh.com/ - Tomorrow we are going to be testing Terminal on a mac to see if it works and also to restore the site on a mac rather than Windows Vista.
* Once connected to your host run the following command:
* mysqldump --host=xx.xx.xx.xx -u username -p database_name > dbbackup.sql

This will create your database backup, ours was in the root of the host connection.

FTP all the files from your host to your local computer, We just created a C:\website_backup\ directory and took ALL files from my host to my local.

Our local machine has WAMP installed so we copied the web files to WAMP\WWW\
Then we ran phpMyAdmin and created a new database and also created a new user. Make sure you copy the encrypted password down as you will need it for the configuration.php file.
We then imported the database to the newly created one.

This is where the fun started for us.
You have to edit your configuration.php file so that you have the "localhost" details rather than www.yourdomain.co.uk and your database names and users are as your new ones.
Good post available here at the Joomla forum on what needs to be changed

I was still getting Server 500 errors and after much head scratching remembered about reading the log files !!!

It was in there that we spotted that the local site was having problems with the .htaccess file. It was changed on the hosted site by our developers to work with the hosting partner and enable SEO.
Error was "C:/wamp/www/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration"
I renamed the file OLD.htaccessOLD and my site came to life.

Worth mentioning that the backend administration used the same username and password as the hosted site.

SkyeMax2002 hope that this post may help other Joomla users when trying to test backup and restores of their websites.

With thanks to our hosting partner at www.openbynature.co.uk for all their help with the command line information.

Now that we are getting a bit more confident with the backup and restore we will be pushing hard to get www.skyemax2002.co.uk up and running so you can come and see the USB Memory sticks that we will be selling.

Yours,
SkyeMax2002

USB Memory Sticks - Preview

Sneak preview of the products:
England USB Memory - Flag style on a T-Shirt / Football kit, available in 2Gb, 4Gb and 8Gb.
Brick USB Memory Stick - Lego type in Red or Blue and available in 2Gb or 4Gb.

More news to follow but wanted you to have a first preview.