Multilingual support in PHP website
So many developers thinks that its hard to provide multilingual support to website. Are you one of them? No problem. Here are some helpful tips to provide basic multilingual support for you website. There are 3 different cases CASE#1 Provide multilingual to static contents of …
A multi-user blog system in PHP – Bluetrait
Blog systems are now very popular and there are plenty of solutions to implement blogs. “Bluetrait” allows the one or more users to login and post articles that are stored in a database. Currently it supports storing posts in MySQL and SQLite posts. It supports …
Export data to a CSV file using MySQL command prompt
> SELECT tableColumnName1, tableColumnName2 INTO OUTFILE ‘/path/to/file/data.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘n’ FROM tableName; Access Denied Even if you have been granted the SELECT privilege, you will still need to be granted the FILE privilege, or else access will …
Edit MySQL stopword list [MySQL full text search]
>There are two ways to edit MySQL stopword list. Actually its not editing. Its all about creating a new file with your own stopwords & point MySQL to refer to that file location. 1st option———- Create File: e.g. /etc/stopword.txt* Change permission of this file, so …
Optimize mysql queries
>1. use the explain command Use multiple-row INSERT statements to store many rows with one SQL statement. The explain command can tell you which indexes are used with the specified query and many other pieces of useful information that can help you choose a better …
Reset MySQL incase of LOST of Password
>In case of MySQL password LOST… (1)service mysql stop# wait until MySQL shuts down. Then run (2)mysqld_safe –skip-grant-tables &# then you will be able to login as root with no password. (3)mysql -uroot mysql# In MySQL command line prompt issue the following command: (4)UPDATE user …
Mysql Replication
>Follow the steps if you want to do Mysql Replication. Example:- MySQL Server A and Server B (1) Database should be same on both servers. (2) Create Slave User on each of the 2 servers:-USE mysql;INSERT INTO user(User, Passsword, Select_priv, Reload_priv, Super_priv, Repl_slave_priv) VALUES(‘USR’,’PASSWD’,’Y’,’Y’,’Y’,’Y’);FLUSH PRIVILEGES; …