How to Import a Large MySQL Database

A number of times I have been unable import a big database through cPanel or phpmyadmin because of its sheer size?

So, how do you import a big MySQL database?

The problem is caused by the PHP configuration file on the server, generally limiting maximum file upload size to 2mb, causing Import, Restore methods to fail.

The answer is taking a Big Dump! No, I don't mean you need to do a big poo, you need the nifty script BigDump, written by Alexey Ozerov specially for importing large databases.

-:- Go and download your BigDunp: http://www.ozerov.de/bigdump.zip
-:- Unzip it and upload both bigdump.php and your_database.sql to the same directory via ftp (Both bigdump.php and your_database.sql* MUST be uploaded with ASCII (text) mode)
-:- open bigdump.php via any editor and edit your system variables. Save it.
-:- Access via Browser your bigdump.php file: http://www.yourdomain.com/bigdump.php
-:- Now select the file to be imported from the listing of your working directory

It works with .sql and GZip but not RAR files. If you have a .rar file, unzip it and upload the .sql file. Ensure you have enough web hosting space allocated.

Be patient! DO NOT CLOSE THE BROWSER WINDOW UNTIL IMPORTING IS FINISHED. Mine simply displayed a white screen page, but all 167,468 records in one table had been imported.

Remove bigdump.php and the database.sql from server
Enjoy
KOZ

BigDump script, troubleshooting, help, FAQ, etc
BigDump: Staggered MySQL Dump Importer

How to open large MySQL files - SCiTE

I've long had this issue not being able to open large files, typically MySQL files.

Applications bundled with Windows, such as notepad and wordpad just don't cut it - I think because they read the entire file to memory before opening.

Then I found Scintilla's SCiTE.. WOW! I downloaded the file for Windows, unzipped it and opened a 246mb MySQL file in seconds.

Very impressive stuff! And as I was so impressed, I decided to take a tour and found that it supports syntax highlighting in all the popular programming languages, as well as many I've never before heard of. It even has code collapsing as standard.

And just in case you are having trouble moving a large MySQL file, take a look at my answer on the next post!

Bugmenot.com - Free Logins

Don't you just hate being told you have to login before you can view a web site!

Well Bugmenot.com is your answer..

STEP 1: Make a note of the website address your are trying to access.
For example: http://www.onlysydney.com.au/

STEP 2: Visit http://www.bugmenot.com

STEP 3: Enter the address from step 1 into the box and press the "Get Logins" button

STEP 4: You should now be presented with at least one username and password.

STEP 5: Go back to the site and login with the username and password.

With any luck you should be able to access your article now!

WorldWide Telescope

Want to see the same images that scientists at NASA use for their research or perform your own research with those images? Or do you want to see the Earth from the same perspective that astronauts see as they descend to Earth?

How about taking a 5 minute break and viewing a panorama of a different city?

Install WWT and start your explorations.

Picnik - Photo Editing Software

Picnik is the easy way to edit your photo's online in your browser.

Picnik makes your photos fabulous with easy to use yet powerful editing tools. Tweak to your heart’s content, then get creative with oodles of effects, fonts, shapes, and frames.

-:- Fix your photos in just one click
-:- Use advanced controls to fine-tune your results
-:- Crop, resize, and rotate in real-time
-:- Tons of special effects, from artsy to fun
-:- Astoundingly fast, right in your browser
-:- Awesome fonts and top-quality type tool
-:- Basketfuls of shapes from hand-picked designers
-:- Works on Mac, Windows, and Linux
-:- No download required, nothing to install

It's fast, easy, and fun.

.Htaccess IP Banning - Block Bad Visitors

Increase your web site’s security by blocking bad visitors with .htaccess. If you have nuisance visitors, site scrapers, or spammers, you may want to add some lines of code to your .htaccess file that will block bad visitors by IP address or by blocks of IP addresses.

.Htaccess IP Banning - Block Bad Visitors | WebGeek

.htaccess Tricks and Tips

.htaccess tricks and tips.. part two: url rewriting with mod rewrite.


more clever stuff here


redirecting and rewriting

.htaccess Tricks and Tips

.htaccess tricks and tips.. part two: url rewriting with mod rewrite.


more clever stuff here


redirecting and rewriting

Google Search Engine Ranking Factors

SEOmoz.org article represents the collective wisdom of 37 SEO experts who have voted on the various factors that are estimated to comprise Google's ranking algorithm.

The result is a resource of incredible value - although not every one of the estimated 200+ ranking elements are included, 90-95% of the knowledge required about Google's algorithm is discussed.

Server Response codes - SEO

What Server Response codes mean and how search engines interpret the Server Response codes...

Court Rules Against Target in Web Site Accessibility Lawsuits

The world gone made! A federal court judge issued rulings Oct. 2 2007 that the $60 billion retailer Target needed to stand trial on charges that its Web site is not sufficiently accessible to visually-impaired shoppers.

Home Page Optimisation

Clients are forever asking what content should be on their home page, and how should it be optimised.

How long is a piece of string used to be the answer, until Kevin Gold wrote this excellent guide - Five Factors for Landing Page Optimization, which reads like a good balance between content and optimisation.

Five Factors for Landing Page Optimization Search Marketing Standard Blog

(1) Keep Focused on Your Primary Objective
(2) Choose a Clear and High Visibility Headline Placement
(3) Present the Call-to-Action Clearly and Vibrantly Right on the Landing Page
(4) Reduce Navigational Links
(5) Use Crisp, Eye-attracting Images

Spelling - Optimization -v- Optimisation

I often say this... beware of spelling differences between Australia and U.S.A. Yes folks, here in Australia (and very similar to the United Kingdom), spelling tends to replace a 'Z' with an 'S'.

Optimization = Optimisation
Landing page = Home page
Search engine optimization = Search engine optimisation

Never trust anyone who calls a buoy a BOOEE... more commonly known as BOY in the southern hemisphere, as in buoyant! So, does that mean they say booeeant?

Search Engines Unite On Sitemaps

Last November, Google, Microsoft and Yahoo united to support sitemaps, a standardized method of submitting web pages through feeds to the search engines.

Today, the three are now joined by Ask.com in supporting the system and an extension of it called autodiscovery. This is where the major search engines will automatically locate your sitemaps file if the location is listed in a robots.txt file.

Top Software
http://gsitecrawler.com/

More reading:
http://www.sitemaps.org/

Google, Yahoo, MSN Search Engine Updates Latest SEO Updates Latest SEO News

Search Engine Marketing Blog

I see a lot of seo blogs with most not worth the html, but Dave's Search Engine Marketing Blog is one of the exceptions...

Well worth reguarly reading! Keep up the good work Dave!

GSiteCrawler

Google Sitemap Generator for Windows :: GSiteCrawler will help you generate the best Google Sitemap file for your website.

The GSiteCrawler uses different ways to find all the pages in your website and can generate all sorts of files, statistics and more.

The sitemaps file format has lately been also adapted by Yahoo! - even MSN/Live.com is pledging it's support.

The man who owns the Internet

Kevin Ham is the most powerful dotcom mogul you've never heard of, reports Business 2.0 Magazine.

Here's how the master of Web domains built a $300 million empire.

Since 2000 he has quietly cobbled together a portfolio of some 300,000 domain names that, combined with several other ventures, generate an estimated $70 million a year in revenue.

How to scale Mt. Google

SEO - shorthand for search engine optimization, the craft of increasing your rank on search engines - is now a $4.1 billion industry. Ad agencies have entire SEO divisions. Companies hire SEO pros.

Yet expertise isn't a must; understanding basic SEO strategies can help the smallest site climb Google's "organic," or nonpaid, results.

Google PageRank Checker

Google Page Rank is a free tool to check Google™ pagerank and to display your site's PageRank™ value on your web pages or blog.

Google Maps - Australia

Google has launched a BETA version of its Local Maps service linked to TrueLocal. Users can search for types of business and location to view a Google Map with search results and linked tabs.

Goodbye, television. Hello, Joost™

Joost™ is a new way to watch TV, free of the schedules and restrictions that come with traditional television. Combining the best of TV with the best of the internet, Joost™ gives you more control and freedom than ever before - control over what you watch, and freedom to watch it whenever you like.

Google Apps for Your Domain

Google Apps lets you offer private-labeled email, IM and calendar accounts to all of your users, so they can share ideas and work more effectively.

Google's Sitemaps Standard

The world's three largest search engines [Google, Microsoft and Yahoo] agreed to support the same protocol for submitting web pages to their crawlers.

Google created the protocol, known as sitemaps, in June 2005 as an experiment to help webmasters increase their visibility in Google's search index.

Website Translation

This page explains how to add translation to your website.
By Digital Inspiration © Amit Agarwal.

Image Reflection

I googled for a reflection of our logo and found this wonderful solution...

The World Wide Web project

I thought this was interesting, a copy of the very first web page. Blogged on the day they announced 100 Million web sites later!

SitePoint Awards 2006

Nominations are open for SitePoint Awards 2006 closing Friday the 27th of October.

Design Your Site
Program Your Site
Host Your Site
Community Centre
SitePoint Marketplace

10 tips on fighting forum spam

SitePoint Forums - 10 tips on fighting forum spam

1. Use human validation
2. Email verification
3. Prevent new users posting links
4. Limit post edit time
5. Limit signature links
6. Use conditionals
7. Block common sources
8. Censor common offenders
9. Have a moderator team
10. Remain vigilant

Bad if phpbb, SMF and vbulletin are less targeted.

buletmann@aol.com - spammer

It’s all coming from the same ip address 203.198.162.120 to 203.198.162.127, so it’s safe to block all of those.

10 Tips for Successful Web Design

Here are 10 specific tips to help you make sure that your web site is everything you want it to be.

Synergy

Synergy lets you easily share a single mouse and keyboard between multiple computers. It's intended for users with multiple computers on their desk since each system uses its own monitor(s). Freebie!

FavIcon from Pics -- how to create a favicon.ico for your website

Simple to use browser based ICO creator... display your icon on the browser address bar when visitors view or bookmark your web page.

Simply select a picture, logo or other graphic (of any size/resolution) for the "Source Image" and click "Generate FavIcon.ico"

Identity theft – protect yourself

Read this excellent report by choice.com.au..

• Checklist of precautions
• Stolen ID - What to do!
• Check your credit report

Games Industry Link - Melbourne 2006 Commonwealth Games supplier and project Opportunities

In March 2006, Melbourne will host the XVIII Commonwealth Games. An event of this magnitude provides many opportunities for Victorian and Australian business.

To assist organisations take advantage of these opportunities, the Victorian Government and Melbourne 2006 Commonwealth Games Corporation (M2006) has tasked the Industry Capability Network (ICN) to design, develop and implement the 'Games Industry Link' website.

Buxton Group

Here is a fabulous web site, clear navigation, wonderful graphics and... content!

Only problem is... who will ever find it ? SEO!

Like so many igloo sites, great if you can find them.

Australia gets second root name server

VeriSign has added a root name server in Australia, along with authoritative name servers for the .com and .net top-level domains which it administers.

Resume Laundry

Fabulous 'Melbourne Made' software aimed at the recruitment industry.

Imagine all Position and Skill Attributes in Resume's...
formatted to ONE Standard?

End of perfunctory 'job interviews'.

Most Hated Advertising Techniques

Top 10 Hates

of 2005 (Jakob Nielsen's Alertbox)

Design Element Users Answering "Very Negatively" or "Negatively"
Pops-up in front of your window 95%
Loads slowly 94%
Tries to trick you into clicking on it 94%
Does not have a "Close" button 93%
Covers what you are trying to see 93%
Doesn't say what it is for 92%
Moves content around 92%
Occupies most of the page 90%
Blinks on and off 87%
Floats across the screen 79%
Automatically plays sound 79%

Top Ten Web Design Mistakes

of 2005 (Jakob Nielsen's Alertbox)

Cut any questions that are not needed. For example, do you really need a salutation (Mr/Ms/Mrs/Miss/etc.)?
Don't make fields mandatory unless they truly are.
Support autofill to the max by avoiding unusual field labels (just use Name, Address, etc.).
Set the keyboard focus to the first field when the form is displayed. This saves a click.
Allow flexible input of phone numbers, credit card numbers, and the like. It's easy to have the computer eliminate characters like parentheses and extra spaces. This is particularly important for elderly users, who tend to suffer when sites require data entry in unfamiliar formats. Why lose orders because a user prefers to enter a credit card number in nicely chunked, four-digit groups rather than an undifferentiated, error-prone blob of sixteen digits?

Official Google Blog: Preventing comment spam

If you're a blogger (or a blog reader), you're painfully familiar with people who try to raise their own websites' search engine rankings by submitting linked blog comments like "Visit my discount pharmaceuticals site." This is called comment spam, we don't like it either, and we've been testing a new tag that blocks it. From now on, when Google sees the attribute (rel="nofollow") on hyperlinks, those links won't get any credit when we rank websites in our search results. This isn't a negative vote for the site where the comment was posted; it's just a way to make sure that spammers get no benefit from abusing public areas like blog comments, trackbacks, and referrer lists.

We hope the web software community will quickly adopt this attribute and we're pleased that a number of blog software makers have already signed on:

No Follow Hyperlink 2005

The "rel" attribute : rel="nofollow"

As of 18th January 2005, Google, together with other search engines, is recognising a new attribute to the anchor tag. The attribute is "rel", and it is used as follows:-

link text

The attribute tells Google to ignore the link completely. The link won't help the target page's PageRank, and it won't help its rankings. It is as though the link doesn't exist. With this attribute, there is no longer any need for javascript, forms, or any other method of hiding links from Google.

SitePoint

Since 1997 SitePoint has been the pre-eminent publisher of enjoyable, informative, and exciting Web development and design content.

Collingwood : Melbourne

Guide to Australian Broadband

Web based guides about broadband internet services in Australia.

Whirlpool - Best known Australian Broadband forum and news.

Broadband Guide - enables search and comparison of 600+ Broadband and Dialup products, and then get connected online or over the phone.

Broadband Choice - Comprehensive list of Australian Broadband ISP's.

Australian Broadband - Connectivity solutions for residential apartment complexes.

Resinet - eCommunity connecting apartment resident to resident intranet. Communication portal interface connects building management, local tradesman, services and stuff to do. Software designed and developed in Melbourne by GANZ Media Group.

How do we get inbound links?

Simply the best guide you will find ~ How do we get inbound links?

Inbound links, link exchanges and link acquisition..

DMOZ - a.k.a. The Open Directory Project

Getting a website listed in DMOZ can be very frustrating. We know that being listed will probably help our Google rankings, but getting in can take a very long time.

In this article I will explain why it often takes so long and why what you do when submitting your site is sometimes the cause of the delay. But first I will explain what DMOZ is and why it is worthwhile for websites to be listed in it.

Horrible Holes

I found this researching how we should optimise internal links to avoid what the author calls 'horrible holes'.

how I hate horrible holes
==================

Any link off your site is a hole.

Any link to a internal page that doesn't link back is a hole.

Affiliate links are horrible holes.

All in all linking to any page a search engine doesn't need to see (like a user profile, etc) is a hole.

You can plug holes, or you can out number them with links pointing back into your site.

Lets do!

SitePoint Forums - Controlling PageRank proves possible with prudent planning.

Swat - Swat

Swat is an open-source web application toolkit built with PHP5.

It is primarily developed and maintained by silverorange, but participation and contributions are welcome.

Edition 01

nothing to see but a little testing..