I first used this process for OLP-Clarksville.

1. Get a back of the WordPress Site.  BackupBuddy (https://ithemes.com/backupbuddy/) was able to give me the SQL.  This may cost.   I got a backup of the wp17_posts, wp17_term_relationships & wp17_term_taxonomy tables.  I also backed up all of the media (for any pictures)

2. Create a new Schema in MYSQL (i.e. Clarksville) and make it the default Schema

3. Paste in SQL and run (get a coffee)

4. Upload files into dirctory /images/stories/wpbackup/ from current site

5.  Get CSV for Articles.  You might not be able to do it all at once depending on mySQL Workbench limits (sometimes it can only do 500 at a time).

SELECT REPLACE(p.post_title, '"', '""') AS title, TRIM(TRAILING '-' FROM p.post_name) AS alias, REPLACE(TRIM(TRAILING '\\' FROM (REPLACE(REPLACE(REPLACE(REPLACE(p.post_content, '\n', ' '), '\r', ' '), ',', ''), '\\', ' '))), '"', '""') AS introtext, '' AS `fulltext`, 1 AS state, 'in-memoriam' AS category, p.post_date AS created, p.post_modified AS modified, p.post_date AS publish_up, '0000-00-00 00:00:00' AS publish_down, 'no' AS featured, 'yes' AS published, '' AS tags, 
'' AS images, '' AS urls, '' AS attributes, '' AS metadata, '' AS metakey, '' AS metadesc, '' AS `language`, '' AS xreference
FROM wp17_posts p
LEFT JOIN wp17_term_relationships rel ON (p.ID = rel.object_id)
LEFT JOIN wp17_term_taxonomy tax ON (rel.term_taxonomy_id = tax.term_taxonomy_id)
WHERE tax.term_id IN (84) /* ID BEING IMPORTED */
AND p.post_status = 'publish'

6. Replace the path for images to the new directory.

Example:

Replace: https://www.providencehigh.net/wp-content/uploads/
http://www.providencehigh.net/wp-content/uploads/
http://providencehigh.net/wp-content/uploads/
https://providencehigh.net/wp-content/uploads/

Replace With
/images/stories/wpbackup/

7. Import in Categories using Import Dialog on the Administrator