Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 where can I find MySql database??

Author  Topic 

MaryLee
Starting Member

8 Posts

Posted - 2010-11-14 : 06:19:59
Hi,

I made a database for my project called shopdb using MySql on my own computer, and the teacher ask me to bring the directory of the database (shopdb) to another computer. I made a quick search and I could not find any directory with this name (shopdb).
I went to c:\program files\mysql ..... and I found nothing there
where can I find My SQL database and how can I move it to another computer
can you help me, please?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-14 : 06:25:33
mysql\data should have a folder with the databasename.

But this is a MS SQL Server forum and you can get better help in a MySQL forum


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

MaryLee
Starting Member

8 Posts

Posted - 2010-11-14 : 07:56:11
Hi webfred,
what is the differnce between MS SQL server and MySQL?
because I found two folder in c:\program files(x86)
first one is : MYSQL
second one is : Microsoft SQL server
when I search into MYSQL folder I found no folder with name data at all
when I search into Microsoft SQL server I found folder (data) but inside it there is no folder with my database name

Oh! no! where is my database ????
the program works fine and it seems the program find this database

Note: when I first generated this database I went to this path: C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysql.exe

Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-14 : 08:17:20
The difference is not easy to describe...
It is like the difference between MS Office and another open source project.

To search for your database directory see here: C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data

Maybe that helps.
Otherwise, as I said: Ask in an MySQL forum because we are not that experts for MySQL...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -