ERPNext mysql-python connection

[Anil Prabhakar]

Hello Everyone,

Some how my data was corrupted so I recompiled ERPNext and installed python and mysql.

Now I had a backup of my earlier database but when I try to restore it then there are many tables missing in the database.

Can someone help me with the structure of ERPNext databse or is there someway to connect mysql with python.

Again I am new to ubuntu and ERPNext so I do`t know how to frame my question properly but below I m posting the commands I had performed and their errors

I m not very sure what is the problem but I think ! is treated as a bash event but then I tried this

 mysql -u root -p erpnext < backupdb.sql'

and this command shows the following error:

ERROR 1146 (42S02) at line 13: Table 'erpnext.barcode' doesn't exist

I think I might have to create the tables but is there some way possible to get those table created by connection it to python.

Kindly help me.

[Rushabh Mehta]

This seems like a non-ERPNext table. All ERPNext tables start with "tab" e.g. tabBarcode.

Are you importing the right DB? Or did you customize this app?

--
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dd453a90-277c-4c0b-9b5e-4e6d512d3388%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.