For method of simplicity I want to have a DB Sync to MYSQL from our Quickbooks file
This is the absolutely most complex setup you could have chosen. Having the two DBs sync is NOT simple, by any means. If you want simplicity, DO NOT use the SQL mirror and attempt to sync QuickBooks with an SQL database.
This is an extremely complex thing to do, for a number of reasons:
- The code to sync the two is BETA -- hence the big warning in the comments: "THE SQL MIRROR CODE IS BETA CODE, AND IS KNOWN TO HAVE BUGS!"
- QuickBooks isn't SQL-based at all, and has only a somewhat limited XML-based API, so there really isn't any way to fully sync with QuickBooks cleanly -- a lot of translation has to happen
- The QuickBooks API doesn't even allow access to all data it contains, so it's tough to get a fully up-to-date and reliable sync
If you want a simple and reliable approach, follow the quick-start guide:
If I look in the DB it is not the 140 tables that the docs says I have
Then something went wrong. Remember, it's beta code. If you have your server properly configured to log PHP/SQL/web server errors, then you can check your error log and find out what the issue is.
the quickbooks_user table is empty
This is because something went wrong, per my above comment. You need to drop the tables and run it again, and check your error logs to figure out what's wrong.