Friday, December 21, 2012

Excellent Script to change MySQL Table Prefix in Drupal

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.

Sunday, December 16, 2012

How to install Django in Windows 7





To Install Python and Django with Xampp on Windows 7: http://www.leonardaustin.com/technical/install-python-and-django-with-xampp-on-windows-7

If the above methods don't work try this:


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

Restore VHD File Backup in Windows 7



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.

Method 1: Steps to mount VHD files in Windows 7

a.    Open Start Menu, right-click on Computer and click Manage.

b.    Click on Disk Management.

c.    Click Action -> Attach VHD and specify the external hard disk location on your computer.

Check out the section in the link below about how to extract files from a system image (advanced)

http://blogs.technet.com/b/filecab/archive/2009/11/12/recovering-your-files-in-windows-7.aspx

Method 2: How to restore your computer from a system image backup

http://windows.microsoft.com/en-US/windows7/Restore-your-computer-from-a-system-image-backup

For more information about system image backup, you can visit the link below

Learn more about system image backup

http://blogs.technet.com/b/filecab/archive/2009/10/31/learn-more-about-system-image-backup.aspx

Backup and restore: frequently asked questions

http://windows.microsoft.com/en-US/windows7/Back-up-and-restore-frequently-asked-questions

Hope this information is helpful.

Mouneshwar R – Microsoft Support

Source: http://bit.ly/SUOhjB

CASE #2: Restore your computer from a system image backup: http://bit.ly/127HwPd

CASE #3: Restoring Windows 7 VHD Backup Files with Acronis True Image Home: http://kb.acronis.com/content/3648

Monday, December 10, 2012

Friday, December 7, 2012

Creating Virtual Host on Xampp 1.8.1

Firstly, please follow all the steps mentioned in this post of mine: http://soluzione08.blogspot.in/2012/02/creating-virtual-hosts-on-apache.html and then add this line 'Require all granted' as below for all your virtual host setup.The changes should be made to the file 'httpd-vhosts.conf'

<Directory "c:/vhosts/sandbox.wp">
    Options Indexes FollowSymLinks
    AllowOverride All
    Order allow,deny
    Allow from all
    Require all granted
  </Directory>

Note: The above code is an example for a Name-based Virtual Host. For and IP-based Virtual Host you will have to replace the Name with the IP which usually is "127.0.0.1" on a localhost.

Thursday, December 6, 2012

Zencart unable to connect to database

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

Inspiration for Internet Startups



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

 4. For Facebook, though, hacker means something different. It’s an ideal that permeates the company’s culture. It explains:

 - 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.”

The Hacker Way: Minimum, Viable: http://leanstartupmachine.com/2012/03/minimum-viable-and-viral/

Top Magento Hosting:

Top 5 Posts (Weekly)

Lets Connect: