Member Avatar for HunainHafeez

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
  • 187 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by HunainHafeez
Member Avatar for smantscheff

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.

Member Avatar for HunainHafeez

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

Member Avatar for smantscheff

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

Member Avatar for HunainHafeez

ok but files are no where :(
i am sick of searching for it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.