Never tried to upload or import a large file to Mysql? Well, I recently faced the dilemma of importing a large Wordpress database, over a 100 MB in size and some serious difficulty.

Mysql is initially set up to process 1 MB through import, so i increased this via shell to 120 MB but it still did not work

I tried the bigdump script to no avail. Then, i came across johnon explanation of how to import large files in mysql using Mysql SOURCE Command but he provided no detailed information.

So, I played around in shell and found out the solution. Here it is the solution using XAMPP or WAMPP as the server

1. Create an empty database in phpMyadmin. Give it the same name as the sql file you are trying to upload. You could also create a database in shell by typing: mysql: CREATE DATABASE databasename;

2. Move your sql file to the bin file in your Xampp Mysql directory

3. Log on into shell: mysql -u root -p. It will then ask you for your root password. Type it in

4. Let Mysql know which file you intend to use

-   mysql> USE file.sql;. If you fail to use the USE command you can end up with this error: “error 1046 (3D0000): no database selected. If your database is large this error can freeze the screen

5. Dump the sql data file with this code: SOURCE c:/xampp/mysql/bin/file.sql

If your file is really big it could take over 30 minutes, be patience and your sql database will be imported

So, I search for MySQL String function equivalent to PHP ucwords() function that would allow me to make the first letter of each word uppercase.

So that the string “php and mysql are great ” will be written as this “Php And Mysql Are Great.”

I tried the REPLACE Function, but that did not work.

I also tried the UCASE function yet It still did not work.

Here is what works.

Create a php file with you mysql connect variables

Run a while loop with update function, allowing each row to be updated during the loop

<?php
$result = mysql_query (“SELECT column, id FROM table”);

while ($row = mysql_fetch_array($result)) {

$id = $row["id"];
$column2 = ucwords($row["column"]);
$query2 = “UPDATE table SET column = ‘$column2′ WHERE id = ‘$id’”;
mysql_query($query2);
}

?>

The Advanced PHP/MySQL Techniques course is scheduled for  Tuesday and Thursday, starting on 06/08/10 and ending on 07/01/10. It should be open for registration on our web at .www.pcs.uah.edu. The fee is planned for $825.

The course is listed under Professional Development, IT Tools, Oracle, Related Courses and is being offering by UAH Division of Professional and Continued Studies

Students and PHP developers endeavoring to take their coding skills to a higher level can full advantage of the low-cost but high level functionality provided through PHP/MySQL by taking your skills to a more advanced level.

Focusing on incorporating and using existing libraries and toolkits in the PHP programming environment, the course content will give you thorough knowledge in the areas of working with XML, and defining and consuming Web Services.

The use of AJAX will be introduced, and the Smarty Template Engine will be covered in detail.

Topics Include:

Object-Oriented PHP
PHP XML Support
XML RPC
PHP Web Services
Complex PHP Web Services
AJAX with PHP
Smarty Templates Overview
Installing & configuring Smarty Pear Module
Smarty in N-Tier Architecture
PEAR: HTTP_REQUEST MODULE

Prerequisite: Fundamentals of PHP/MySQL or equivalent experience.

You can used the mysql LIKE function, but you can mistakenly erase valuable data.

Take, for example, trying to change a large list of banner ads with width set to 280px, but you need them to be set to 300px.

Update table SET column = 300 WHERE column_name LIKE ‘%width=”280″%’

<a href=”http://domainname.com” target=”_blank”><img src=”http://domainname.com/serveup.php?type=image&amp;ad_id=1343&amp;aid=904395″ border=”0″ alt=”" width=”280″ height=”250″ /></a>

This will work but it will delete all other characters in the column and replace them with “300″

I was trying to find a way to do it, which took me some time. Here is the solution. I hope this help you

update table set column = replace (column, ‘280′, ‘300′)

You can post this directly into the “Run SQL” box in PhpMyAdmin

The replace function can be in lower case or uppercase

However, depending on what version of Mysql you are working with you might have to execute it with this code

UPDATE table SET column = REPLACE( column, 280, 300)

If you are copying one column to another use this code

UPDATE table set column2 = column1

With online business, like in any other business, building linkages is key to success. The more links of value you have pointing to your website the higher your website ranking would be, and, in turn, the more traffic to your business. Traffic is the crust of the web business. so the more traffic the more products you can sell or the more people you can influence depending on the type of website you are promoting.

Be Controversial

Controversy sales. You will draw attention to those who are vehemently opposed to what you are saying, and you will draw attraction to those who agree with what you are saying. Either way, a buzz will occur around you and people will make reference to your site which, in turn, will bring easy backlinks. A good example of this are the liberal and conservative bloggers who some love and others love to hate.

Participate in the community. Help Others

Scripture says give and in like manner it will be given to you. shaken down and in good measure. Every time you participate in a online community, weather it is giving answers or solutions to biting questions or joining a forum or social media group – by giving insightful answers to questions or by providing good information to your community you improve your standing as being an authority. Since people love to follow authority you can get lots of organic links from this strategy. Success depends on the number of people you serve.

Dig Deeper. Do original research

People are always looking for information to illustrates who to do things easier. If you can provide information that is unique, beyond the ordinary dabble – just a notch away from the rest, then you have the opportunity of arresting your veiwers attention. People like to tell others about great, helpful information and would gladly refer your site or recommend tips and advise that you were so kind enough to provide. Every reference is a potential link.

Establish Yourself as an Authority of How To’s

Some how the articles with titles such as “top 10 ways” or “top 10 reasons” seems to do well. Psychologically it attracts the reader. Also, articles that teaches how to do something attracts much attention as many people are looking for ways to do things easier. The folks at ehow.com and howtodothings.com have created a business model around this concept.

Offer something free

The more you give the more you get. Offer a free ebook or a free iphone will certainly get a buzz going around your site. Internet surfers will inform their friends about it and in the process create links and references to your site. Get some free articles on ezinearticles.com, package them into an ebook and offer it to your viewers. Contest are also great in creating links. Visitors to your site with a competitive spirit can really get a buzz going.

Set up an Email or RSS Subscription Option

Marketing is all about repetition. By sending fresh, valuable content to your subscribers this will strengthen your brand awareness. The more aware people are of your brand the more likely they are to link to your site. Also, people like sharing great content, so email subscribers are likely to forward your articles to others within their network. They may digg it, post it on facebook, tweet it or reference it on their social media site of choice

Create an Affiliate Program for your products

If you have a product create an affiliate program will not only increase your backlinks but will increase your referral traffic as well. Many people are online to make money and there are a tonne of material online advising others on how to make money with affiliate marketing. Many of these articles have direct links to affiliate program pages. Many website within your niche do reviews and blog post on your affiliate program

Create a Network of Related Businesses

Communicate with a group of businesses within you niche and ask them to link to you. You should also reciprocate. For instance, if you are a realtor it is very likely that you would have a relationship with a mortgage broker. Ask the mortgage broker to place a link on his / her site to yours

Offer Free Seminars and Workshops in Your Community

Offer free conference and seminars to people interested in your line of business. Offer incredible information that would be of use to the attendees. Then refer then to a page on your website that they can either download of view the entire presentation

Write Articles and Guest Post

Writing articles with great content and submitting them to article directories to be published is another great way to get links to your website. Each article should have at least 2 links to your site embedded in the content or author area. The better the article the more it will be published by blogs, and niche websites. Every time your article is published two more additional links will be pointing to your site. Writing guest post on authority blogs does not only establish you as an authority but create backlinks to your site every time a guest post is published. Give it a try. There are a host of blogs accepting fresh, authoritative content.

These are simple techniques without spamming to increase your site links and increase your pagerank and traffic without violating Google’s webmaster guidelines.

If I left out other natural methods to increase backlinks drop me a line below

Google TV? Well this is not a surprise. Google has be dabbling in every form of technology from cellphones to satellite. Today Google announced that it will introduce a brand new TV technology called Google Smart TV that will bridge WEB surfing with watching TV.

Google TV will include search functionality that will give the viewer t option of searching for content on their television or across the Internet. This announcement comes on the heels of announcing Android 2, the next regeneration of Google smart phones at Google I/O developer conference.

It is rumored that Google Smart TV is an electronic box with web functionality that will bring TV programs to anyone in the world. This is a bold step to bring the web to television and television to the web through a device that bring clear uninterrupted picture.

It alleged that Google is working with large media companies like Sony, Logitech and Intel to create the technology to maintain the network. If Google truely succeeds in this venture, it will be the first company to bring this technology fruition.

Let’s hear from you. What do you think of Google entering the television business. Will it monopolize the industry? How do you think it will change web surfing, web design and search engine optimization?

Choosing the best affiliate marketing programs for your website is one sure way to make money with your website. Some webmaster and bloggers that have dabbled into the affiliate marketing business are making as little as $10 a day, while others are generating as much as $100,000.

Many affiliate marketing professionals use a combination of social media, PPC marketing, Clickbank, white hat and black hat techniques, but most use their own website full of authentic content related to their niche. If you are thinking of going into affiliate marketing here are some things you can do:

Website Content and Affiliate Offers

1. Build a website and ensure that it is user friendly, meaning, it is easy to navigate and the colors are not too taxing on the eye. The theme of the website should be consistent. It means that the content of your website should be about one niche only.

For instance if you have affiliate links pointing to cellphone related sites, then your content should be about cell phones, cell phone accessories and related items. Once you have your site looking authentic sign up for an account at different affiliate networks: Google Ads, Clickbank, Commission Junction, NeverBlue Ads, ShareAsale, MarketHealth, Click2sell to name a few.

Selecting and Publishing the Best Affiliate Programs

Once you have been approved by the affiliate networks log into your affiliate account and grab some banners, text links and flash creatives to add to your site. Place them on places on your site where the viewer tend to navigate the most.

The upper left column of your site is usually the most viewed, so place a 300*250 banner there. Some merchants will provide data feeds. If you are comfortable with php you can incorporate these data feeds into your content. If you have an updated email list use that to send affiliate offers to your subscribers.

Testing Affiliate Offers

Follow up with an account manager at the different affiliate networks. Ask them to refer you to affiliate programs that pays a commission of more than 20% and those that are very popular and trendy. Also, these items should be worth more than $50.

You want to make at least $10 per sale, that way your commission can grow very quickly. Better 10 sales at $10 than 50 sales at $1. Once you have identified products that you would like to promote place banners on your site and send out an email with authentic content with an affiliate offer included.

Give it about 7 days, then analyze your results. If results meet you expectations add more content to your website related to the product and do some dedicated SEO, such as link building, to get you page ranking high, which will result in increase traffic. If, on the other hand, the results are lackluster, move on to another product, or, in some cases, to another affiliate networking with more support and better offering.

Consistency Yields Increase Affiliate Income

Like every good thing, choosing an affiliate marketing program for your website is just part of the equation. To be successful at anything you need to be consistent, willing to adapt and accept changes and also seeking new ways of accomplishing the task.

Keep learning. Subscribe to blogs of top affiliate marketing like Jonathan Volk, John Chow, Zac Johnson, to name a few. There are lots of money to be made with affiliate marketing if you can be consistent and able to put on your adventurous hat.

If you have a small business or non profit organization you may be contemplating getting a website to increase your online presence in the Huntsville Alabama area. The internet is a proven way of spreading the word about your business quit quickly. You will need a reputable web design company to build and design your company’s website.

Some web design companies charge an exorbitant amount of money and deliver unsatisfactory work, while others charge a reasonable price, under promise and over deliver. In light of the number of web designers in the Huntsville area, you should be able to have your website build and maintain at an affordable price.

Couple places you could try are Ebay and Craiglist. There are many new web design companies advertising their service online. However, you will need a professional design that represents the great service that your company provide.

Settle for a professional web designer that is willing to sit with you and offer free consultation. The web designer you choose should be verse with article marketing, building back links, search engine submission, website optimization, video creation, affiliate marketing among other things.

Sometimes, the best way to select a professional is to ask friends and family about web designers in the Huntsville area. When you finally get to sit down with a prospective web designer ask him for references. Ask to see a portfolio of sites that he or she has build.

Ask questions about the final prices of the project, details of contact, the time for the project will be completed, and so on. Finally, give your web designer a list of design styles and colors you would like on your website. A typical small business website should not take more than 2 weeks to be done

Free Web Design Consultation

If you are thinking of building a website for your business contact us for a FREE web design and web optimization consultation

A few days ago I discovered that my credit card number was stolen and had to go through some steps to feel safe again. Having gain this experience, i decided to write a few cautionary words that may help you avoid this nightmare.

In those private moments when you are accessing your bank debit card or credit card account you don’t think that there is someone – a hacker looking at your information at the same time. Your bank, of course, offers secure online banking, so there seem to be no need for worry. Wrong! You should worry. Hackers are using trojans and other softwares to secretly steal data from your computer or from online forms that you regularly fill out.

In 2009 American were robbed of about $560 million by internet vigilantes according to the Internet Crime Complaint Center. That is more than 100 percent increase from 2008.  In fact, in 2009, there were more online robberies than physical banks robberies. The most frequently used techniques that hackers used was trojans.

These malicious scripts are specially tailored to steal user names, passwords, social security numbers and other vital data associated with your bank account and other pertinent online transactions like mortgage payments, bill paying and medical records.

Does Your Bank Has A Safe Online Banking System?

The more questions you have to answer or the more forms you have to fill is the safer your online banking is likely to be. If you bank’s online portal only ask for a user name and password to enter, it is not as secure to stand against sophisticated trojans out there.

Regions Bank online banking, for example, only ask for a user name and password and its requirement for what constitute a password is not as stringent: 8 character password with letters and numbers combination. It should be a 8 letter password with letter, number and character combination with at list one letter in caps.  If you are doing online banking you should check your computer for virus on a regular basis.

There are trojans such as ZEUS what will create a fictitious forms, asking for additional information such as social security numbers, before allowing you to enter you banking account.

Who bears the liability

The moment you are notified of any irregularity on your bank account act quickly to remedy the situation. In general, if you notify you bank in a timely manner of the violation to your account the bank is liable.

However, if you have a business account or a line of credit account the bank in most cases may not be liable. In the final analysis, the conclusion will be based on whether you acted with safety and report the incident in a timely manner.

How to Protect Your Account and Your Identity Online

Hacking is not the online way your information can be stolen. There is a whole democracy of information on the internet and bits of information about yourself can be found everywhere, from mortgage information from your county’s court filings to the footprints we leave on social media sites. Here are some things you can do:

1) Avoid posting personal information about yourself online

2) Change your passwords every 90 days or every time you log into your account, which ever works for you

3) Purchase anti-virus and firewall for your computer. Cable companies like Comcast and Knology offer free anti-virus to their customers, so if you subscribe to a cable company services, follow up for free virus protection

4) In some cases anti-virus is not enough, you will have to add a trojan remover to you computer as well. Exterminate-it.com is a good source .

5) Do not download free programs that you can’t vouched for. Many free programs have spywares attached that can rip out many personal information on your computer

6) Avoid using public networks or wifi at coffee shops as they are sometimes easy to penetrate.

7) Review your statement meticulously and report any unusually item to your bank or credit card company.

Create strong passwords made up of at least one capital letter, with a combination of numbers and symbols or characters

9) Never use the same password on more than one account

10) Ask your bank or credit card company if they have an alert system that sends an alert every time an unusual purchase is registered. I am very grateful my credit card company had one of those. They alerted me quickly and closed that particular credit card

11) Sign up for credit alert so that if any thing suspicious or out of the ordinary is placed on your credit report you will receive an immediate alert informing you of changes in your credit score

12) If you find information about you that is too personal or incorrect ask the webmaster to go to http://www.google.com/webmasters/tools/ and remove the page with your information

13)Visit spokeo.com and search for you name. If you name and other private information shows up, click on the privacy link at the bottom of the page and request a removal

Get Equifax Score Watch Now!

1. Participate in small community events. These small events are always looking for donations and sponsorships. In many cases sponsorship can begin from $10. In exchange they will allow you to put up your company’s banner at the event. This is a fantastic way to advertise.

2. Print T shirts with your website address and give to friends and family to wear. Give them out to your customers and associates. Attend community events with your T shirt on. You become a walking billboard.

3. Add bumper stickers on your car with your website on it. Vista Print sometimes gives free stickers and door magnets. Purchase a few and give to friends and family to add to their cars. Through this alone, thousands of people will be expose to your website. Also, Vista Print sometimes have a free yard sign promotion. Get one and place it in your yard.

4. Cross promote with other associates. Provide a percentage of every sale to associates you make a referral. This is a great way to provide incentives to others who are already in your network.

5. Attend community business events, seminars, workshops and conferences within your niche and related business. Bring business cards and brochures to further enhance networking opportunities.

6. Purchase pens printed with your website address and distribute them to associates, clients, friends, family members and acquaintances you meet through networking sessions and business events. Live some at your favorite restaurant, bank, and doctors offices etc..

7. Get listed in your community chambers of commerce or business center. These businesses are in the business of promoting small local business and they would gladly tell other small business about your services. Also, spread the word about your website in your church or spiritual circles.

8. Write meaningful and relevant articles in your field and try to have your local newspaper publish them. Some newspapers circulation is over 100,000 and these could mean an introduction to a massive audience.

9. Create workshop for aspiring people in your field. Tell others that you are available for free consultation and will give free business presentations upon request. This way you can build yourself as an authority in your field. These methods if properly implemented, taking your target market into consideration, could bear much fruit. The result? An ongoing presence, through word-of-moth and person interaction.

What other ways could be used to market a website offline?