I'm not a developer and don't have any server admin experience, forgive me if this is the wrong forum for this.
I want to access a local back-up copy (uncompressed) of my e-commerce site's MySQL database, from a local Windows PC. I need to do this because eventually I will be pulling data from local machine back-up of e-commerce db to a on a daily basis, for purposes integration with some specialist printing software.
I have downloaded a copy of my e-commerce site's MySQL database to the local machine. I have downloaded and installed Xampp to the same machine. I've worked out how to start Xampp and opened up myphpadmin from within Xampp. I can't work out how to get access the local MySQL database file from myphpadmin.
Can anyone help me? I'm thinking I must have to put the MySQL db in a specific directory, or use a command line to connect,
Anyhelp is appreciated.