Recover item master, purchase and sales invoices from SQL dump

1

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.

PLEASE HELP.

2

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").

3

Never mind, I somehow managed to fix it.