Apache Friends Support Forum

Hi

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.

If you have a .sql, or .sql.gz file, you will need to restore the database.

You can use the command line tool \xammp\php\bin\mysql.exe or do it through phpMyAdmin. You may have to create the same database and user name that was used on the host first. You can do that in phpMyAdmin, (databases atb) and (priviieges tab).

http://www.webcheatsheet.com/SQL/mysql_ ... estore.php

If you are gong to do this stuff - you'll need to learn the tools - phpMyAdmin is your friend, as it can work with XAMMP and is offered on mostr webhosts,

http://www.phpmyadmin.net/documentation/

Good Luck