Archive for the ‘web development’ Category

How to Install/Recompile MCRYPT in PHP (CentOS VPS)

Jan 17, 2010 Work, web development

I’m starting to develop sites with the Interspire Shopping Cart system, which I think is totally way better than Prestashop. I suggest people who want a better system than Prestashop to checkout the Interspire Shopping Cart, its worth every penny.

So I’m setting it up for our company in a VPS hosting, and it requires the PHP installation to be compiled with MCRYPT package. Specifically, this is needed for the manual credit card processing module. And it seems that the Godaddy VPS support is NOT willing to support (ironic) so I had to deal with the challenge myself. I found this instructions from NotesBit.com on how to recompile PHP with MCRYPT support. Here are the steps I followed – it was actually easier than I thought:

Read the rest of this entry »

Tags: ,

Search and Replace in MySQL

Nov 30, 2009 web development

I just went through a domain transfer for one of our websites, and the links in the posts are all pointing to OldSite.com rather than the NewSite.com. But it’s an easy fix, as long as you got Google.

Read the rest of this entry »

How To Completely Backup your GoDaddy Website Files

Nov 26, 2009 web development

Godaddy mainly offers domain names for sale, but they are also selling hosting plans including shared hosting, VPS and dedicated server. For those who are using shared linux hosting on Godaddy, it can be a pain to backup all of your website’s files because they do not have an option for that purpose. This has been my problem too when we needed to transfer from Godaddy shared hosting to VPS – the files needed to be backed-up.

Here are two ways you can backup your Godaddy website files:

Read the rest of this entry »

Working Paypal Module for Prestashop

Oct 28, 2009 Prestashop, web development

I just finished adding the Paypal payment option for our e-commerce site that uses Prestashop as the shopping cart application. I’m quite getting more comfortable configuring and editing the source code of Prestashop, but along with those modifications is the failure of the default Paypal payment module that came with the Prestashop code package to fail.

Read the rest of this entry »

How To Repair Corrupted MySQL Tables in Linux

Oct 22, 2008 Work, web development

I had this problem for days and can’t find a solution. What I had was .frm, .MYD and .MYI backup files from a previous MySQL installation. My task was to restore these files to the newly reformatted dedicated server. I searched all over the net to find the solution, and here’s what I did (commands are in italics):

  1. Make sure you log in as root.
  2. All the files were in a tarball file: “admin_backup.tar.gz”, so I extracted everything to a directory. tar -xvf admin_backup.tar.gz
  3. Now all the .frm, .MYD and .MYI files are extracted. I placed all the files in the MySQL database folder located at /var/lib/mysql/admin_mike.
  4. I immediately logged into phpMyAdmin and tried to access the tables, but unfortunately it says that “Can’t find file: ‘./admin_mike/sometable.frm’”. What I had to do was check the ownership of the files. ls -la /var/lib/mysql/admin_mike/*
  5. The files should have the ownership like “drwx—— 2 mysql mysql sometable.frm” if not, chown all the backup files. chown mysql:mysql *
  6. I tried to access the tables now in phpMyAdmin, and now they are all accessible!

I thought I’d share this so that others would also fix their own corrupted mysql table. :)