Access MySQL on Windows PC

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Access MySQL on Windows PC

Postby radtanto » 26. August 2010 14:39

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.
radtanto
 
Posts: 1
Joined: 26. August 2010 14:18

Re: Access MySQL on Windows PC

Postby JonB » 27. August 2010 04:42

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 123 guests