location of erpnext database file

[Satish]

Hi All,

Where is erpnext database located? I was thinking of linking it to access to generate some custom reports.

Regards

Satish Gupta

[MANISH SHAH]

Hi Satish,

Check the DB dir path in /etc/MySQL/my.conf
The default path is /var/lib/MySQL

Regards
Manish

> --
> Note:
>
> If you are posting an issue,
> 1. 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.
> 2. Paste your code at http://pastebin.com or http://gist.github.com and send
> only the URL via email
> 3. 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/a9f769f4-79db-4d03-a0c4-f0b296048c21%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

[Satish]

Thanks.

> email to erpnext-developer-forum+unsub...@googlegroups.com.

[Mahesh]

Hello, I have a simillar question.
Is it possible to access the database tables "directly" that resides on frappecloud host ?

Regards,
Mahesh

--

Note:
 
If you are posting an issue,
1. 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.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. 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.

[Rushabh Mehta]

Mahesh,

Quick answer: no - its too risky. API is the best option.

If you have reports you want to execute, you can create an app and if it looks okay we will host it (at our discretion).

best,

Rushabh

@rushabh_mehta

https://erpnext.org

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAPjtCMn8t23d5Jmry7K%3DoH5-qC4s%3DDtOO8pcehV3C2mN%2B3Yw3w%40mail.gmail.com.

[Mahesh]

Alternatively a script that mirrors a few transaction tables to a new database on a periodic interval and gain access to the mirror database if its too risky to touch the main database ?

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/F261B989-7CC3-478C-ADFF-9A57B455CBF6%40gmail.com.

[Rushabh Mehta]

You can extract the data via API and push it to another database.

If you have reports that you have made and are decent enough, we can host them / add them to the product too.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAPjtCMnw_67JQ%3DQFNJF9Ko_RjecxN0_15zgNagt56OC_pbWYcg%40mail.gmail.com.