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]
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.
<?php set_time_limit(0); ?>
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.