How to view a mysql database??

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

How to view a mysql database??

Postby bluem » 10. September 2008 03:34


I installed xampp on my computer and I am able to get into the phpmyadmin control panel...I would like to know how to view info about an existing mysql database...

We had a workstation collecting test info and the there are three files created; testinfo.frm, testinfo.MYD, and testinfo.MYI.

I copied all files to the following directory: C:\xampp\mysql\data\mysql however when I opened phpmyadmin I was not able to see the database listed. Is something to do to add the database or a command to run? I really appreciate the help on this matter since I need to be able to view the database and pull some data from it.

Posts: 1
Joined: 10. September 2008 03:21

Postby glitzi85 » 10. September 2008 10:22


inside the data folder you should have several folders. Each folder represents one Database. If you copied your files into mysql, you added the table to the MySQL-Database. You also can just create a new folder in the data directory and put your files there. After restarting MySQL you should have a new Database with the name of the folder you created.

User avatar
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests