Recover item master, purchase and sales invoices from SQL dump

The last few sales invoices we created would refuse to submit because there’s no stock, when purchase invoice and warehouse clearly shows stock entry was successful. I tried to update Frappe and ERPNext, but something broke and SQL import into fresh bench setups isn’t working.

I urgently need a way to get the minimum of item master, purchase and sales invoice, associated chart of account and warehouse updates from the SQL and insert into new ERPNext instance.


On a new bench setup, I created the site using bench new-site site1.local --force --sql sql_file.sql, it ran without issues. After that, running bench --site site1.local migrate will give the error pymysql.err.IntegrityError: (1048, u"Column 'translatable' cannot be null").

Never mind, I somehow managed to fix it.