I am trying to copy content from an old joomla instance to a new joomla instance. We archived the old site and created a completely new site with the same version of joomla both sites are at 3.6.4.
Now the new site has been built and the client wants to import 5000 articles (out of about 7000) from the old site to the new site.
I installed j2xml but had a lot of issues. First I could not export the all the articles php/apache could not deal with that many post variables. So I broke it up into chunks I spent yesterday importing the chunks. After completion a quick article count showed only half of the actual articles managed to import. There were other import issues along the way such as failed imports with no errors, failed user creation, only some of the articles being created etc. etc which meant I spent the whole day on it.
So I want to go back to first principles.
What steps do I have to follow to copy the content from the old site to the new site using sql?