Manually insert post into MULTISITE database: Need to specify the TABLE

This is how it worked for me:
– uploaded the file into site root
– ran it from the subsite, like this: http://subsite.mainsite.com/my-script.php

It ended up inserting the new post into the subsite.

error code: 523