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 a MySQL query and also with phpMyAdmin. The following example changes the auto increment value for the table named “mytable” to 1. This means that the next time you insert a record into this table the value of the auto…

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_* functions but it should be easy enough to substitute a database library’s functions instead. It also writes the data out line by line to the XML file whereas you could buffer the whole file in memory and write it out…

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 the data from MySQL into a CSV file with PHP including a header row. The example code below uses the raw mysql_* functions but it should be easy enough to substitute a database library’s functions instead. It also writes the…

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 links related to phpmyadmin like database, sql, status, variables etc. Click on Privileges and now you will see different user is availble in your phpmyadmin. Look at the below of your list of users there is a link i.e. Add…

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 high speed connections of today it is still highly important to improve websites efficiency and performance to increase the users experiences. This article goes over will decrease your bandwidth output. Lets get to increasing the performance efficiency of your website…

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 will also need to install the php module for mysql 5: sudo apt-get install php5-mysql To create a new database, use the mysqladmin command: mysqladmin create Shashi Dhar KumarShashi Dhar Kumar Experience in Web/software development including client server and implementation…

Read More