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.
Steps:
- 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.
Update
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:
- How to create a Server/Droplet in DigitalOcean and connect with ZoomAdmin
- How to quickly install MySQL Server using ZoomAdmin Server Control Panel
- How to Install phpMyAdmin, Login to MySQL Server and create Databases/Users
- How to Deploy and Host Multiple WordPress Websites on One VPS Server
- How to Manage DNS Settings in DigitalOcean and Configure Domain Names for apps
- How to Install Redis Server and Redis Commander
- How to Connect Visual Studio Code with VPS Servers to Run Commands and Modify Files
- How to Configure Redis Object Cache in WordPress
- How to Backup DigitalOcean Server and Configure Automatic Backups