Change mysql schema and table collation

I was working performancing the Mysql DB and realized that some of my tables needed to be changed to UTF 8 from Latin. Here is the quick script to changing the Mysql schemas and Mysql table.

 ALTER DATABASE `Database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci 
 ALTER TABLE `table_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci 

Just by changing the Schema does not changes all the tables in it. Individual tables need to be change. All the table, until explicitly told, will be made in the new collation / character set.

[category Mysql, DbAdmin]

My new closeups of Mira

Server time out when php script takes too long to execute.

Most of the time, if the php script is process intensive on client end, by default, the APACHE server times out the script. If the script is timing out on server, one needs to add a small line on the top of the script.


Pizza or Sharwarma

Pizza or Sharwarma, originally uploaded by Salman, Khwaja.

Does it feels like this is pizza.

No. This is picture of pizza. Picture of Shawarma pizza. This pizza was delicious in the sense, that we can taste the turshi in it.

A nice flavour for those who are trying to have an alternative flavour rather than regular pizza.