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

Hello,

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.

Thanks,
b
bluem
 
Posts: 1
Joined: 10. September 2008 03:21

Postby glitzi85 » 10. September 2008 10:22

Hello,

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.

glitzi
User avatar
glitzi85
 
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 27 guests