1. Create a new Schema in MYSQL

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

3. Upload files into dirctory /images/stories-archive from current site

4. Eval to see how many articles you will be bring over

SELECT cat.path, COUNT(0) AS number
FROM stmarybell.amal16_content con, stmarybell.amal16_categories cat
WHERE con.catid = cat.i
GROUP BY cat.path

5. Get CSV for Categories

SELECT CONCAT('Z - ', title) AS title, path AS alias, 'Article' as type, '' AS image, description, IF(published = 1, 'Yes', 'No') AS published, 'Public' AS access, '' AS tags, note, '' AS language, '' AS layout, '' AS 'Alt Text', metadesc AS meta_description, metakey AS meta_keywords, '' AS author, '' AS robots
FROM stmarybell.amal16_categories
WHERE extension = 'com_content'
AND published = 1
AND path NOT IN ('academics', 'testimonials')

6. Import in Categories using Import Dialog on the Administrator

7.  Get CSV for Articles.  NOTE: I was able to only import in 500 at a time since MySQL Workbench exports would cut off around 500-600 entries.

SELECT con.title, TRIM(TRAILING '-' FROM con.alias) AS alias, REPLACE(TRIM(TRAILING '\\' FROM (REPLACE(REPLACE(REPLACE(con.introtext, '\n', ' '), '\r', ' '), '\\', ' '))), '"', '""') AS introtext, REPLACE(TRIM(TRAILING '\\' FROM (REPLACE(REPLACE(REPLACE(con.`fulltext`, '\n', ' '), '\r', ' '), '\\', ' '))), '"', '""') AS `fulltext`, con.state, cat.path AS category, con.created, con.modified, con.publish_up, con.publish_down, IF(con.featured = 1, 'yes', 'no') AS featured, IF(con.state = 1, 'yes', 'no') AS published, '' AS tags, 
'' AS images, '' AS urls, '' AS attributes, '' AS metadata, '' AS metakey, '' AS metadesc, '' AS `language`, '' AS xreference
FROM stmarybell.amal16_content con, stmarybell.amal16_categories cat
WHERE con.catid = cat.id
AND cat.published = 1
AND cat.path NOT IN ('academics', 'testimonials')

8. Edit the Article CSV by finding and replacing the old image directory with the new.

Example
Search: images/stories
Replace with: images/stories-archive

8. Import in Categories using Import Dialog on the Administrator.