Blog

Blog

25
Jul
2010

Backup All Databases From MySQL Server

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:
13
May
2010

Reset Presta Shop Password with PhpMyAdmin or SQL

I spent 30 minutes trying to reset the Presta Shop Admin password via PhpMyAdmin (MD5 (cookie+password)) with no luck.

Then I stumbled upon this post (click here for link) – a huge thank you to the author – saved me a from going crazy.

To reset the password make sure you download and edit this file (it is part of the attachments in the above link) “prestashop_pword_hash.php”

Edit the file and change $cookieKey and $newPassword

Once done upload it to your webserver and run the file. Copy the output MD5 hash string from your browser and paste it into the “ps_employee” table under the “passwd” column and hit Go.

This should hopefully get you in.

29
Apr
2010

Refresh Miami – 29th April 2010

Join the team at “The Groove Spot” on Thursday at 7:30pm for this month Refresh Miami where they will have two great presentations that will help to be iPad-ready.

First Damian Montero will present “How to Make Your Website iPad Friendly,” showing how to leverage HTML5 in order to play videos and more on the portable device.

The second presentation is by Luciano Ibias, COO of Zila Networks, the company behind the successful Friends Around Me, who will talk about “iPad App in a Week: How To Port Your App From iPhone To iPad.”

Follow the April speakers on Twitter:
Damian Montero @damianmontero
Luciano Ibias @ibias

Please RSVP Via Facebook
iPad Crash Course

Date: Thursday, April 29, 2010
The Grove Spot
3324 Virginia Street
Miami, FL 33133

Time: 7.30 PM

27
Apr
2010

Web Design: Why it Helps to Go Local

Web Design: Go Local

If you are considering hiring a web design company to assist you in setting up your space on the internet, you should consider hiring a local web designer. There are so many design companies today to choose from and they are located all over the world. While it is fine to use a design company located far from you, it could become a problem if a face-to-face meeting is necessary in order to go over some fine details concerning your website design.

23
Apr
2010

Top 5 Resources to Help Build Your Website

There are so many ways to build a great website that it can be somewhat confusing knowing where to start. The very first thing that must be decided when building a site is, what is the primary purpose of the website? Will you provide content? Will you sell products/services or is it simply informational? These questions must be answered before starting to put your website together.

Once you have decided what type of website you wish to build, then you must choose the best resources to use. This will save you a lot of frustration when building your site and it is not even all that necessary that you understand HTML in order to build an effective site.

20
Apr
2010

The Difference Between a Static Website and a Dynamic Website

If you are planning on having a website, it is important that you understand that there are two distinct types of websites: static and dynamic.  We will take a few minutes here to explain to you the differences between the two, and once you are finished reading, you should have a very good understanding of both so that you can decide clearly which type of website is best for you.

Difference Between a Static Website and a Dynamic Website

Millions of us rely on a printed newspaper as a way to read the happenings in the world. A newspaper is in fact, a very good example of a static media. Once a story has been printed on a newspaper, it cannot be changed as its type has been set. You will simply have to wait until the next edition is printed in order to receive the latest news. Much in the same way, a static website cannot be changed until the webmaster or someone familiar with HTML or flash edits and/or updates the content.

15
Mar
2010

Google Tracks User Actions on Gmail

Google is tracking some user actions on Gmail. Though this might seem obnoxious at first, it can prove to be a helpful for busy Gmail users when used appropriately.  For example: Gmail can be set up to remind you to attach documents. This is triggered by the use of certain keyword combinations. See screenshot below.

Google Tracks Gmail actions

(Click the image to expand)

15
Mar
2010

Beginners Guide to CSS, HTML and XHTML – Part I

This post is going to be the first of a series of posts on deconstructing CSS, HTML and XHTML for newbies.

HTML & CSS

HTML is a presentation language. Unlike programming languages like C# or JAVA, HTML is used to define the way content is presented in a web page. The primary tools for defining presentation characteristics of a web page are tags.

Ex:  ‘<html> <title> <br> <p>’

There are open tags such as ‘<p>’ and ‘<l1>’ etc. But compared to the number of closed tags, these tags are comparatively very limited. All the other HTML tags need to be closed to make them meaningful and add the intended formatting.

However, HTML carries some basic limitations. One of them is that, styling has to be applied to individual tags. For example, though the H1 tags may appear the same in every page in a web site with 30 pages, the formatting has to be done individually. This is a tiresome and a time consuming task that can lead to many unforeseen problems. Also, this increases the size of the web page leading to much larger websites.

Cascading Style Sheets [CSS – a Style sheet language] was introduced to address this issue. CSS is intended to be used as a substitution for individual HTML style tags pertaining to attributes of HTML tags. For example, a single CSS script can be used to apply attributes for ‘<h3>’ tags throughout a website. These scripts can be called by a hyperlink or can be entered at the head of the web page or at the intended place of formatting.

Sample CSS script

CSS gives web developers much flexibility to address formatting issues. Also, a CSS can be altered and given the circumstances, [ex. Call the CSS via a hyperlink] the changes can be automatically applied to all HTML formatting done using that particular CSS script. This is considered to be a very important development in web developing.

HTML and XHTML


The introduction of Extensible Markup Language [XML] is considered to be one of better developments. It allows users to define their own tags and use them accordingly. XML needs an Extensible Stylesheet Language Transformations (XSLT). Which is an XML-based language used for the transformation of XML documents into other XML or “human-readable” documents. The original document is not changed; rather, a new document is created based on the content of an existing one. The new document may be serialized (output) by the processor in standard XML syntax or in another format, such as HTML, .wmv, .avi or plain text.

Due to the ease of use provided by XML as well as the cohesion, orderliness and well-formedness, a new standard was adopted for web development as well. This is XHTML.

The Extensible Hyper Text Markup Language, or XHTML, is a markup language that has the same depth of expression as HTML, but also conforms to XML syntax.

Whereas HTML is an application of Standard Generalized Markup Language (SGML), a very flexible markup language, XHTML is an application of XML, a more restrictive subset of SGML. Because they need to be well-formed, true XHTML documents allow for automated processing to be performed using standard XML tools—unlike HTML, which requires a relatively complex, lenient and generally custom parser. XHTML can be thought of as the intersection of HTML and XML in many respects, since it is a reformulation of HTML in XML. XHTML 1.0 became a World Wide Web Consortium (W3C) Recommendation on January 26, 2000. XHTML 1.1 became a W3C recommendation on May 31, 2001.

This is very important because most HTML validators use XHTML by default. To override this, specific script has to be added at the head of a HTML page.

Ex: ‘<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>’

‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>’

Most web development tools available in the market today such as Macromedia Dreamviewer have the ability to define the way web pages are presented as XHTML or HTML. The latest versions of such tools create web pages in XHTML by default.

The failure to define the presentation medium, [I.e. XHTML, HTML] can lead to an unprecedented number of errors when HTML coding is to be validated. Web developers need to take extra care to define the medium to prevent this problem.

02
Mar
2010

Features of Forums and Social Networks: A Comparison

Social Networks and Forums are two of the major interactive platforms on the web. While both have their strong points and large user bases, the two are vastly different. Forums are more or less evolved bulletin boards. They are meant for discussion of various subjects and subject based interpersonal interaction.

The Forum is structured like a tree. Each is made from many topics or threads and each topic is usually part of a group of topics which fall under a common generic topic. Each thread is made up of posts. A post is whatever an individual user publishes on the forum at that time. Forums are public domains which have administrators and moderators who maintain the site as well and the enforcement of rules and regulations. Rule breaking can result in one being banned from the forum. Repeat offenders are banned for increasing amounts of time till the use of a permanent ban. Forums are very much active with Japan far in the lead with over two million posts per day on 2channel which is their largest forum. China’s Tianya Club also has many millions of posts. Forums present a wealth of information for anyone willing to dig in.

01
Mar
2010

Online Customer Interaction, the Best Foot Forward…

One of the vital cogs in the online marketing mechanism is effective customer interaction.  With the number of commercial websites rising with unprecedented rapidity and market niches  diminishing into almost invisible blips, the key in effective online marketing lies in retaining the visitors and converting  them into customers as much as in attracting new visitors.

Retaining a customer is by far a more difficult job since the audience keeps comparing your site to that of your competitors. If their product or service offering is better than yours, chances are that your customer may get disenchanted and eventually seek a better option. Bleak stories aside, let us see what you can do to improve the customer interaction.