开发者

creating databases in mysql error

I am trying to work with mysql client and have successfully created a database and table in that database using commands: mysql>Create Database test; mysql>Use test; mysql>Create table test_table ( name varchar(30) );

I got successfully created messages for all the above commands mysql> Show databases displays my database : test

As per my understanding, this new database which I have created should be stored inside c:/users/programfiles/mysql/data/

But I am unable to find the location of this created d开发者_如何学Goatabase. Could some one please help me??? I am at this issue from a super long time :(

I am working on windows 7 and mysql workbench 5.2.33

Thank you, J


Usually importing/exporting tables is done with SQL scripts. Those can be generated automatically. Stop trying to do this with files - even if you find the right folder it won't work. This is not the way to do that kind of things.


check for file my.ini in mysql server installation. the search for string datadir, the value should point you to data directory.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜