Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: Where's the data ?

    So, I imported a database from SQL Server 2005 into MySQL, the data in SQL Server was about 500MB. There were 14 tables.
    It was converted to mostly 9 InnoDB tables and 5 MyISAM.
    I look in the "MySQL\MySQL 5.0\Data\MyDatabase\" directory and the size of files is barely a few megs. Seems like just the tables who were converted to MyISAM are showing the real size it should be, while the InnoDB tables are just a few KBs.

    Now if I browse with MySQL Browser or MySQL Administrator, I see there's data in my database.

    But where's the data really stored ? windows\system !? a hidden directory?

  2. #2
    Join Date
    Feb 2005
    Mumbai, India
    I dont see how MySQL could've compressed the data so much, esp from MS SQL Server 2005 !

    In MySql, for every MyISAM table you should've .MYD, .MYI and .frm files.
    For Innodb, there seems to be only .frm files and db.opt file.
    MySQL 5.1

  3. #3
    Join Date
    Dec 2006
    I found a big data called: ibdata1, without extension on the root of :

    C:\MySQL\MySQL Server 5.0\data

    Later I saw this filename on the config. I think that's were the InnoDB data goes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts