In this tutorial I will explain you two methods to import csv file into MySQL database. First this requires a MySQL database with same numbers of column as csv file. Import csv with LOAD DATA INFILE Import csv file with mysqlimport
Category Archives: Mysql
Get rid of mysql sleep process
Some times there are many many sleep processes in your SQL connection. These sleep connections consume a lot of resources (RAM, cache and processor). This can cause your MySQL server slow down. If your MySQL server is not responding then the query to the database will take a lot of time. In such situations, your […]
Backup and restore large mysql database
If you have very large mysql database then it is very hard to backup and restore using the conventional phpmyadmin or any other program ( like bigdump). In this Tutorial I will explain you how to backup and restore a larger database ( having millions of rows). This tutorial can be used while moving your […]
How to change Mysql data directory location?
Mysql is most famous open source RDBMS (Relational database management system) software used by millions of websites. Most of website with very large Mysql database experience storage problem because /var partition is to small which holds Mysql data files and folder by default. If you are experiencing such a problem then you have to move […]
How to store array in mysql?
This is one of the most asked question by php programmer because mysql doesn’t has any array data type. So we can not store array directly into mysql database. To do this we have to first convert array into string using php serialize() function then save it into mysql database.