Programming Blog

Tutorial : Enable InnoDB for MySQL

1. Open the MySQL options file, the file is called my.cnf (Linux) – are in the / etc / my.cnf – or my.ini (Windows) – the path c: / windows / my.ini –

2. Find Education skip-InnoDB and comment # before adding it

3. E ‘recommended increasing the max_allowed_packet value to make sure you can upload files larger than 1MB.
Then just below the line just commented write:
set-variable = max_allowed_packet = 64M

4. Restart MySQL

Share on Facebook

Problem : CakePHP gets ugly in apache2 with mod_rewrite problem

I have just gone for a new toy, cakePHP, which I have a little problem with the installation. I have a problem with the style in the first page, because It has no colour no style, just plain text. So, the problem is mod_rewrite in apache2. Well, I do simple three things to fix the problem. I hope every one could fix this problem in the same way.

1. First, add the rewrite.load to /etc/apache2/mods-enabled/

2. Edit the apache configuration for my virtualhosting. For example, in my computer I only have one virtual hosting (/var/www) that is default from installation, so I make some adjustment for that (In my case I have to edit this file /etc/apache2/sites-enabled/000-default)

Change the Allowoverride value to all for the document root directory
For example, I made change to this part of the configuration:

1
2
3
4
5
6
7
8
9
10
<Directory /var/www/>

    Options Indexes FollowSymLinks MultiViews

    AllowOverride all

    Order allow,deny

    allow from all

    # This directive allows us to have apache2's default start page

    # in /apache2-default/, but still have / go to the right place

    # Commented out for Ubuntu

    #RedirectMatch ^/$ /apache2-default/

</Directory>

Finnaly, just restart the apache

Share on Facebook