How to Load Test Data in WordPress, Load 20,000+ Articles using phpMyAdmin


In this tutorial, we will show you how to generate Test Data for WordPress using Excel, and then load the generated data into WordPress database. We will take a sample article and duplicate it 20,000 times. We will also mess with phpMyAdmin settings to allow for larger imports.

  • Create sample blog post
  • Export the sample to Excel using phpMyAdmin
  • Duplicate it 20,000 times
  • Adjust phpMyAdmin settings to allow for large import
  • Use phpMyAdmin to Import into WordPress database.


wp_posts C
inner join (
select post_content as post_content2 from wp_posts
where ID=5
) as A
set C.post_content = A.post_content2
where ID>9
// php.ini variables to increase upload size
post_max_size = 50M
upload_max_filesize = 50M

Related Tutorials: