Blog

Blog

Backup All Databases From MySQL Server

Under: Web Development - July 25th, 2010

Its always good to keep your MySQL server backed up regularly.

However if you need to backup the entire server with all databases at once here is what you do

$ mysqldump --all-databases -p | bzip2 -c > databasebackup.sql.bz2
Enter password:

This will save a bz2 file with all the databases.

To restore the databases back use the following (take care not to restore it to a server with the same table names – it may corrupt your data)

$ mysql -p < databasebackup.sql
Enter password:
Comments (0)

Exercise While You Work – Great for Web Site Designers

Under: Web Design - July 21st, 2010
Exercise Bike for Web Site Designers

Exercise Bike for Web Site Designers

I came across this cool article about an exercise bike that includes a laptop stand. I think I know a few Facebook addicts that would love something like this :)

Read more here at the Bnet blog

Comments Off

How to Use Google Analytics to Build Businesses (Part 1 – Google Analytics Dashboard)

Under: Web Design - July 16th, 2010

Google Analytics (GA) is by far the most popular web analytics program on the web. Currently 57% of the top 10,000 websites use Google Analytics as the de facto web analytics program due to its ease of use, zero payment obligation and advanced functionality.

However, it appears that most people who use Google Analytics have little idea how to segment, data mine and use Google Analytics data to improve their online businesses. Given the rich features and massive number of options, most webmasters fail to grasp the full potential of Google Analytics unless they are ready to dig deeper. What we at Cenango are going to do is carry out a blog post rally encouraging webmasters to explore more on Google Analytics and encourage them to go beyond the nice dashboard.

Google Analytics Dashboard

Google Analytics is truly a great program that can help a business improve their marketing efforts. With advanced segmentation and vital information arranged in such a way for easy data mining, Google Analytics lead the way for today’s web analytics.

Most of the features in Google Analytics need to be explored in detail to yield the best utility. But at the same time, GA has put the most important data on the default dashboard and the user can customize their dashboard according to their preference.

Let’s take a walk around the Google Analytic Dashboard.

Google Analytics on Cenango

This is the typical view of the Google Analytics dashboard. Each visual element can be dragged around according to your preference.

The biggest visual element in GA is the traffic graph and the site usage elements. By default you are shown site traffic for the past month.  The importance of these features is understandable. This report can be easily exported as a PDF or an XML file or it can be e-mailed to a preferred email address as well. You can send the report to yourself or you can add more people to the thread.

There are several advanced segments that you can add to the traffic view. You can add up to 4 advanced segments from the drop down list.  These are the options. (All visits are shown by default.)

  • New Visitors
  • Returning Visitors
  • Paid Search Traffic
  • Non-paid Search Traffic
  • Search Traffic
  • Direct Traffic
  • Referral Traffic
  • Visits with Conversions
  • Mobile Traffic
  • Non-bounce Visits

You can also create a new advanced segment or manage your advanced segments without much fuss. It’s pretty straight forward. Once created, you can test your advanced segment before you go ahead with it. So no worries about messing things up.

There are four independent elements that you can drag around and reposition. This helps you to determine and select the most important elements that you want to grab your attention first.

Have a closer look at Google Analytics elements when you visit the site again. You will notice that there are many things that you can do with Google Analytics. We’ll cover specific options in our forthcoming blog posts. Do keep in touch. This is going to be very interesting.

Comments (0)

Cenango Price Match

Under: General - July 5th, 2010

Cenango Price Match

We have developed a very efficient web development process, optimized to minimize time, cost and resource inefficiencies. Therefore we are capable of providing our clients with superior results and exceptional service at very affordable prices.
We are very confident that we can beat the price of any US based web design company by 10% based on an acceptable quote.

Terms & Conditions:

  • The quote needs to be from a registered US based web design company (corporation)
  • The quote needs to be detailed and has to include a full outline of functionality
  • The quote must be dated within the last 3 months
  • The web design company will be producing your website within the United States
  • Using this offer also means that you get our money back guarantee. No questions asked.

Send us your quotes to info@cenango.com or call us Toll-free on 1(800) 365 1842 for more details.

Comments (0)

Email Newsletters and the CAN SPAM Act

Under: Web Design - July 3rd, 2010

Spam Email

Over the years we’ve setup multiple email campaigns for our clients to send out newsletters using our bulk email web application. For the first time in our seven-year history, we’re getting ready to send out a newsletter to our loyal fans.

One of our nightmares is having our email flagged as Spam. It is a real nightmare as there are lots of things that can go wrong. Some of the most serious being, our domain name being blacklisted by ISP’s or worse getting a $16,000 FTC fine per ’spammed’ email account. Yikes! Enough to send any sane marketer into hiding!

We’ve all received our fair share of not-so-delicious spam and the last thing we want to do is spam our clients.

So why go through the risk? Many of our clients have expressed interest in getting updates on new trends and tips and tricks with regards to website design.

Our goal with the newsletter is to disseminate purely educational content – targeted at our audience of business professionals. Content that is new, engaging and ultimately practical for their business.

We’ll keep you posted on how well it is received.

Just to be on the safe side, I did some research into the legal aspects of email marketing. If you’re considering sending out bulk email, I would recommend reading the FTC CAN SPAM ACT guidelines: http://www.ftc.gov/bcp/edu/pubs/business/ecommerce/bus61.shtm

Here are some of their basic guidelines:

  • Don’t use false or misleading header information.
  • Don’t use deceptive subject lines.
  • Identify the message as an ad.
  • Tell recipients where you’re located.
  • Tell recipients how to opt out of receiving future email from you.
  • Honor opt-out requests promptly.
  • Monitor what others are doing on your behalf.

Most of the CAN SPAM Act rules are quite standard, basic email etiquette we’ve all read about. But one thing that seemed a bit confusing was: (btw I’m no legal eagle – so double check this) if you send an email to a customer (whom you’ve done business with before) with a coupon or gift (e.g. Win an IPAD) and the only way they can redeem that coupon is to take some action (click to register etc) and they forward this email to a friend – your email could be considered to be in violation of the CAN SPAM ACT. Why? Because you have not done any transactions with their friend and it is considered unsolicited email from you.

Email marketing can be very effective if done correctly and hopefully, beneficial to the receiver as well. Case in point, my weekly Kayak.com travel alerts – flights to Aruba are $199 next week -sounds exciting, I can’t go, but Thanks Kayak for tickling my travel taste buds :) .

Comments (1)