Posts Tagged "mysql"

How to reset Auto-increament in MySQL?

It is possible to reset the auto increment value of a MySQL auto incremental primary key to a new value, either higher or lower than what it would otherwise next be. This post looks at how to do this using…

Like to share it
Read More

How to export the data from MySQL into a XML file with PHP?

There are a couple of ways to export data from MySQL to a XML file. This post looks at how to export the data from MySQL into a XML file with PHP. The example code below uses the raw mysql_*…

Like to share it
Read More

How to export the data from MySQL into a CSV file with PHP including a header row?

There are a couple of ways to export data from MySQL to a CSV file but some of them never supports adding a header row to the CSV which contains the column names. This post looks at how to export…

Like to share it
Read More

How to create new user in PhpMyAdmin at localhost

How to create new user in PhpMyAdmin at localhost? Go to phpmyadmin at your localhost if you are using xampp server than go with http://localhost/phpmyadmin or if you are using easyphp than go with http://127.0.0.1/phpmyadmin Now you can see different…

Like to share it
Read More

Increase your website speed through .htaccess in LAMP Technology

How to increase my website speed through .htaccess in LAMP Technology Many LAMP(Linux Apache MySQL PHP) driven websites today could easily decrease their bandwidth output and increase their speed through implementing caching and compressing their content. Even with the new…

Like to share it
Read More

Install MySQL Server 5 on Ubuntu 9.10

Installing MySQL 5 Server on Ubuntu is a quick and easy process. It almost feels like it should be more difficult. Open a terminal window, and use the following command: sudo apt-get install mysql-server If you are running PHP you…

Like to share it
Read More