Friday, December 21, 2012

Note: This script is applicable to any website using MySQL as its database.

I wanted to change my MySQL table prefix for my Drupal installation and googling and trying various methods that I bumped across in various websites, but to no avail until I landed upon this awesome little script. I've tried and tested this script and it's an excellent little but powerful script to change your MySQL Table prefixes.

Just download the script provided here MySQL Table Prefix Changer and place it in your document root folder. Then enter something like this in your browser "www.example.com/prefix-dxc.php" and fill in the form with the relevant inputs. And within seconds your table prefix should be changed/updated.

Once all's done you will get a final report. One error I noticed during my process was this:

Deprecated: Function mysql_list_tables() is deprecated in C:\xampp\htdocs\prefix-dxc.php on line 109

There is nothing to worry about this as it's just a message telling the above function is no longer supported by my current MySQL version.

If the mod_wsgi file is malfunctioning and stopping Apache from loading you may try these mod_wsgi files from here. Please note the correct version before downloading. There are different types here depending upon the OS (32 bit or 64 bit): http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi

Wednesday, December 12, 2012

If you have made a backup using Windows 7 Backup option where the backup is a large dump of VHD file and unable to recover the back up please follow the methods explained below. I've collected a handful of handy links which should serve your purpose:

Case #1: How to restore VHD file backup?

Answer:

The reason why you’ve a VHD file is because you’ve created a system image backup. A system image includes Windows and your system settings, programs, and files. You can use a system image to restore the contents of your computer if your hard drive or computer ever stops working. When you restore your computer from a system image, it is a complete restoration; you can't choose individual items to restore, and all of your current programs, system settings, and files are replaced.

You wouldn’t be able to restore VHD files using backup and restore center. You can mount the image by following the steps below.

Thursday, December 6, 2012

If you were fiddling around with Zencart for the first time and experience some problem connecting to your Zencart database and the errors is because of a password changed you made, like I did in the Godaddy shared hosting account try the following steps:

1. Change the password in the includes/configure.php file
2. Change the password in the admin/include/configure.php file.

Do check whether other details like the server name, website URL etc. are also set correctly.

Even though you might have kept your folders in a folder which makes the domain name as:http://www.example.com/folder_name

the following values still should be just your site name:
define('HTTP_SERVER', 'http://www.example.com'); define('HTTPS_SERVER', 'https://www.example.com');

The following values should be as (including the trailing slash):
define('DIR_WS_CATALOG', '/folder_name/'); define('DIR_WS_HTTPS_CATALOG', '/folder_name/');

And make sure you don't overwrite any one of the configure.php file with the other. Although they both have the same filename they are different and server different purpose.

Wednesday, December 5, 2012

Here are some dose of inspiration that I've managed to garner so far along my Internet business journey and undoubtedly they are nothing but SO TRUE!!!!

1. One of the co-founder of reddit.com (one of the top website in the
world and America) says, "Don't try to build an awesome product in the
start itself. That barely happens. Start small and then go on building
on it."

2. "Nobody should start to undertake a large project. You
start with a small trivial project, and you should never expect it to
get large. If you do, you'll just overdesign and generally think it is
more important than it likely is at that stage. Or worse, you might be
scared away by the sheer size of the work you envision. So start small,
and think about the details. Don't think about some big picture and
fancy design. If it doesn't solve some fairly immediate need, it's
almost certainly over-designed. And don't expect people to jump in and
help you. That's not how these things work. You need to get something
half-way useful first, and then others will say "hey, that almost works
for me", and they'll get involved in the project." - Linux Times
(2004-10-25), Linus Torvalds (Main man behind Linux Operating System)

3. It's hard to tell with these Internet startups if they're really
interested in building companies or if they're just interested in the
money. I can tell you, though: If they don't really want to build a
company, they won't luck into it. That's because it's so hard that if
you don't have a passion, you'll give up. -Steve Jobs

- the push to try new ideas (even if they fail),
- and to promote new products quickly (even if they’re imperfect).

The hacker approach has made Facebook one of the world’s most valuable Internet companies.
Hackers
“believe that something can always be better, and that nothing is ever
complete,” Zuckerberg explains. “They just have to go fix it - often in
the face of people who say it’s impossible or are content with the
status quo.”

Email Subscription:

Support/Donate:

Drupal Association Member

eV@gabond - The Meaning

" I want to be an educated vagabond, not a vagabond out of weakness. I don't want to do anything in my life out of weakness - because I could not be anything else, that's why I am a Vagabond - that is not my way. First I want to prove to the world that I can be anything that I want to be, but still I choose to be a vagabond - out of strength. Then there is respectability even if you are a Vagabond, because respectability has nothing to do with your vocation, your profession; respectability has something to do with acting our of strength, clarity, intelligence. "