<div>
Hi,<br />
<br />
If u have the csv files ,u can do it via a phpmyadmin...<br />
<br />
Go to phpmyadmin<br />
click import<br />
browse for the csv file<br />
and select ,(comma) for terminated by<br />
Then go.<br />
<br />
Before that u need to create a structure of the table there in the database...<br />
<br />
*****LOAD DATA ******command is the efficient one and for beginners phpmyadmin gui is easy.
</div>


Hi,

If u have the csv files ,u can do it via a phpmyadmin...

Go to phpmyadmin
click import
browse for the csv file
and select ,(comma) for terminated by
Then go.

Before that u need to create a structure of the table there in the database...

*****LOAD DATA ******command is the efficient one and for beginners phpmyadmin gui is easy.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im doing some testing and would like to load our MySQL database with 100,000 rows.<br />
I assume il need to write a script to do this.<br />
Does anyone know of any examples on how i can do this?<br />
<br />
Thanks<br />
Pete
</div>
</div>


Hi,

Im doing some testing and would like to load our MySQL database with 100,000 rows.
I assume il need to write a script to do this.
Does anyone know of any examples on how i can do this?

Thanks
Pete

Bulk load dummy test data into mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.