Hi All,
I need to know the location of database file and how to access it remotely ?
Thanks in advance ,
Ragav
Hi All,
I need to know the location of database file and how to access it remotely ?
Thanks in advance ,
Ragav
If you’re trying to access the ERPNext database, you can use the command bench mysql
Refer to this for where the files are stored : https://mariadb.com/kb/en/mariadb/default-data-directory-for-mariadb/
Accessing it remotely would need you to open the port for MariaDB
Thank you so much for your swift response sir , it has been mentioned in the link that the files will be stored under /var/lib/mysql but unfortunately i could not find anything in that folder and nothing is mentioned in the config file ?
We use the default directory, i.e /var/lib/mysql
In the my.cfg file, you can find the location, under the “Basic Settings” section as :
datadir = /var/lib/mysql
Thank you sir , i got it .