OPEN SOURCE

HOW TO GET A SIZE OF COLUMN IN MYSQL

AUTHOR: ahmedv // CATEGORY: Development, mySQL, Open Source
No Comments

2
SEP
So last week I got an email from our host saying a database has received its maximum size of 3GB. I was like what? How? So I quickly ran the below to check which column was causing the problem.

If you want to find out the size of column=COLUMN_NAME from table=TABLE_NAME, you can always run a query like this:
```
SELECT sum(char_length(COLUMN_NAME))FROM TABLE_NAME;
```
Size returned is in bytes. If you want it in kb, you could just divide it by 1024, like so:

SELECT sum(char_length(COLUMN_NAME))/1024FROM TABLE_NAME;

Happy querying.
MULTI BOOT USB FLASH DRIVE

AUTHOR: ahmedv // CATEGORY: Development, Linux, Mac OS X, Open Source, PC
No Comments

25
JUL
Okay, so I love having recovery tools on a bootable USB drive.

One of my life savers is Hiren Boot Tools (Download the ISO here). Then I had a great idea. What I’ll do is buy a HUGE 64GB USB flash thumb drive and make different partitions. I.e. one for Hiren, one for Windows 7 Installer, one for BackTrack (for you know what – wireless sniffing), one for Ubuntu etc. However I came into a bit of an issue. On Windows only the first partition is identified, however on MacOsX or Linux (Unix) all the partitions are found. However, I’m currently working on more Windows machines. So after some research I came across Yumi Multi Boot Loader.

I highly recommend the app … it runs multiple loaders on a single partition and does it very neatly.

Download from here

Creating a YUMI Multiboot MultiSystem Bootable USB Flash Drive
YUMI works much like Universal USB Installer, except it can be used to install more than one distribution to run Live from your USB. Distributions can also be uninstalled using the same tool!

YUMI’s Main Multiboot Boot Menu

Credits:

http://www.pendrivelinux.com/yumi-multiboot-usb-creator/

Happy multi-booting
PIRATEBAY PROXIES

AUTHOR: ahmedv // CATEGORY: Open Source, Other
1 Comment

15
APR
So The Pirate Bay blocked in your country or by your ISP …

Do not fear – head over to http://ukbay.org/ and click on the ship and a mirror proxy will open up in a new windows. Every click generates a different mirror.

Enjoy and happy Seeding …
BIGDUMP SQL IMPORT

AUTHOR: ahmedv // CATEGORY: Development, Open Source
No Comments

11
APR
So … sometimes you on shared hosting and you need to import a large database. Problem phpmyadmin only supports a max of > 50MB. So the first option is to check the php.ini or the cursed .htaccess file – however many times shared providers override these or won’t allow an apache restart immediately.

So in comes BigDump SQL Import (http://www.ozerov.de/bigdump/)

Usage
1. 1- Download this file or from the http://www.ozerov.de/bigdump.zip
2. 2- Open bigdump.php in a text editor, adjust the database configuration and dump file encoding.
3. 3- Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE” (use phpMyAdmin).
4. 4- Create the working directory (e.g. dump) on your web server
5. 5- Upload bigdump.php and the dump files (*.sql or *.gz) via FTP to the working directory (take care of TEXT mode upload for bigdump.php and dump.sql butBINARY mode for dump.gz if uploading from MS Windows).
6. 6- Run the bigdump.php from your web browser via URL likehttp://www.yourdomain.com/dump/bigdump.php.
7. 7- Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.
8. 8- BigDump will start every next import session automatically if JavaScript is enabled in your browser.
9. 9- Relax and wait for the script to finish. Do NOT close the browser window!
10. — IMPORTANT: Remove bigdump.php and your dump files from your web server.
Credits to http://www.ozerov.de/bigdump/usage/

Happy importing
.HTACCESS REDIRECT

AUTHOR: ahmedv // CATEGORY: Development, Open Source
No Comments

9
MAR
So like me who doesn’t like to install in the root of a server, you may need to redirect an incoming web connection to another directory (sub) or an alternative page. It’s also cool if you want to redirect to a website under construction page etc.

I do this with the cursed .htaccess file by adding this line

# This allows you to redirect index.html to a specific subfolder
Redirect /index.html http://www.abc.com

Where abc in (http://www.abc.com) is you redirected site. You could include a subdirectlyt by adding the slashed link (http://www.abc.com/def)

Happy redirecting.
HOW TO ADD GOOGLE ADSENSE TO WORDPRESS?

AUTHOR: ahmedv // CATEGORY: Development, Open Source, Wordpress
No Comments

6
MAR

How to add Google AdSense to WordPress?

With WordPress you can easily add your AdSense code to your blog. In order to do this, first login to the administrative end of your website. Then, go to the Appearance -> Widgets menu.

In this page select to drag-and-drop a “Text” widget onto your registered sidebar.

Then you should add a title (in our case – Advertisement) and right under it the actual code that you have obtained from Google. Finally, click on the on the “Save” button right under it.

Well done! You have just added your AdSense code to your WordPress blog.

Credit to http://www.siteground.com/tutorials/wordpress/wordpress_adsense.htm
NATURAL HR – FREE ONLINE HRMS

AUTHOR: ahmedv // CATEGORY: Development, Management, Open Source
No Comments

6
MAR
We all love free stuff … for an HR System check out

https://www.naturalhr.com

They offer a totally free online (web based) HR system. It’s very comprehensive including modules like:

Very impressive for a free solution.
NATIONALITY LIST

AUTHOR: ahmedv // CATEGORY: Development, Open Source, Uncategorized
No Comments

4
MAR
Nationality List – a List of Nationalities!

Your time is precious and the last thing you want to do is scour the web for hours searching for a list of nationalities to use in your website or application. We’ve done this boring job for you and have compiled a nationality list in a list text file. So download the file you need and get back to your programming!

List of Nationalities.txt

Credits – http://www.guavastudios.com/nationality-list.htm
BUILT WITH

AUTHOR: ahmedv // CATEGORY: Development, Joomla, Open Source, Wordpress
No Comments

4
MAR
So come across a site and you’re interested in what technology, language is used?

I use https://builtwith.com/ provides a simple background check of the site includes CMS used, languages, widgets and technologies. Pretty cool if you just want a quick scan of what’s happening on the backend of the site.

Happy building …
ONLINE DUPLICATE CHECKER

AUTHOR: ahmedv // CATEGORY: Development, Open Source, PC
No Comments

4
MAR
Ever have a list of data and want to quickly check for duplicates. Now I know it’s possible in SQL or even Excel but if you looking for a really easy online way without tweaking check out http://www.somacon.com/p568.php – Paste your data in the form click on Display / Update Counts and view the results …

Happy duplicate checking …

CATEGORIES

Photo Gallery

mandrel mandrill