0

i created database in mysql along with 3 tables but when i opened C:\ProgramData\MySQL\MySQL Server 5.5\data then i found on .frm files and a single .opt file
so where is my originalo datbase and data ?
my datbase name is kustkht

2
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by HunainHafeez
0

From your mysql console, run

show variables like "%dir%";

The result will contain a variable named datadir which contains the path where you should look for data files.

0

i don't have console facility mean i downloaded Mysql workbench 5.2
it only has interface

0

In a standard installation, the mysql console resides in
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.