Re: [erpnext-dev] location of erpnext database file

Hi Satish,

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

Regards
Manish

On 6/13/14, Satish sa...@gmail.com wrote:

Hi All,

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

Regards
Satish Gupta


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-forum+un...@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.


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-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAJgXDfvSf0KT%3DE70p3ceXLg7WpvwHxwPK5diitoz_kxPv802hw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

Regards,
Mahesh



On Fri, Jun 13, 2014 at 3:38 PM, Satish <sa...@gmail.com> wrote:
Hi All,

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

Regards
Satish Gupta



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-forum+un…@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.




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-forum+un…@googlegroups.com.

    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.

    For more options, visit https://groups.google.com/d/optout.
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

On 14-Jun-2014, at 7:13 pm, Mahesh <ma...@maheshengg.com> wrote:

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

Regards,
Mahesh



On Fri, Jun 13, 2014 at 3:38 PM, Satish <sa...@gmail.com> wrote:
Hi All,

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

Regards
Satish Gupta



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-forum+un…@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.





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-forum+un…@googlegroups.com.

    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.

    For more options, visit https://groups.google.com/d/optout.



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-forum+un…@googlegroups.com.

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

    For more options, visit https://groups.google.com/d/optout.
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 ?




On Sun, Jun 15, 2014 at 2:53 PM, Rushabh Mehta <rm...@gmail.com> wrote:
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

On 14-Jun-2014, at 7:13 pm, Mahesh <ma...@maheshengg.com> wrote:

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

Regards,
Mahesh



On Fri, Jun 13, 2014 at 3:38 PM, Satish <sa…@gmail.com> wrote:

Hi All,

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

Regards
Satish Gupta



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-forum+un…@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.





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-forum+un…@googlegroups.com.
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.

For more options, visit https://groups.google.com/d/optout.



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-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/F261B989-7CC3-478C-ADFF-9A57B455CBF6%40gmail.com.

For more options, visit https://groups.google.com/d/optout.



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-forum+un…@googlegroups.com.

    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.

    For more options, visit https://groups.google.com/d/optout.
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.


On 17-Jun-2014, at 10:50 am, Mahesh <ma...@maheshengg.com> wrote:

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 ?




On Sun, Jun 15, 2014 at 2:53 PM, Rushabh Mehta <rm...@gmail.com> wrote:
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

On 14-Jun-2014, at 7:13 pm, Mahesh <ma...@maheshengg.com> wrote:

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

Regards,
Mahesh



On Fri, Jun 13, 2014 at 3:38 PM, Satish <sa…@gmail.com> wrote:

Hi All,

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

Regards
Satish Gupta



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-forum+un…@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.





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-forum+un…@googlegroups.com.
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.

For more options, visit https://groups.google.com/d/optout.




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-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/F261B989-7CC3-478C-ADFF-9A57B455CBF6%40gmail.com.

For more options, visit https://groups.google.com/d/optout.




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-forum+un…@googlegroups.com.

    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.

    For more options, visit https://groups.google.com/d/optout.



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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/F6E02054-F757-4B67-9145-86B2978159C4%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.