Wordpress mysql insert

You could put all your articles into a CSV file and then use PHP to insert them for you like the tutorial found here

http://www.johnboy.com/blog/tutorial-import-a-csv-file-using-php-and-mysql

Replace his column names with the correct Wordpress ones and boom, everything inserted at once.

You will also need a function to create a "slug" for the permalink, but you can find an example here:

http://stackoverflow.com/questions/2955251/php-function-to-make-slug-url-string

Another option is use a plugin like:

https://wordpress.org/plugins/wp-ultimate-csv-importer/
 
Back
Top