SitePoint Sponsor

User Tag List

Results 1 to 8 of 8

Thread: INNODB problem

  1. #1
    SitePoint Guru
    Join Date
    Mar 2006
    Posts
    701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    INNODB problem

    Yesterday we did a format and we setup again our windows 2003 server.
    There we have a xampp server, we made a back-up and restore of xampp.
    We put then the files of xampp at the sαme directory with the same config etc.
    But now the innodb tables do not work, we can not read them.
    The Myisam tables are all ok.
    What may we do to fix that?

  2. #2
    SitePoint Wizard bronze trophy Kailash Badu's Avatar
    Join Date
    Nov 2005
    Posts
    2,560
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Unlike MyISAM, InnoDB do not store the table data in the MySQL database directory. InnoDB still stores table format (.frm file) in the database directory but the actual data (rows and indexes) are stored somewhere else. Specifically, in a tablespace. Apparently, only the database directory was preserved and the tablespace was wiped out when you backed up the XAMPP before formatting the disk.

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    which directories did you back up and restore when you reinstalled? and what does your error log have to say?
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  4. #4
    SitePoint Guru
    Join Date
    Mar 2006
    Posts
    701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The directory httpdocs and data of mysql with {ib_logfile0, ib_logfile1, ibdata1} files of xammp.

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    did you copy all of the subdirectories of the data directory, too?

    what does your mysql error log say?
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  6. #6
    SitePoint Enthusiast v1rgil's Avatar
    Join Date
    Dec 2008
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    first, check if mysql has read/write permission to the mysql data directory. if correct permission is set but can't use the database, stop mysql, then copy the database files into the directory again then start mysql.

    hope that helps.

  7. #7
    SitePoint Guru
    Join Date
    Mar 2006
    Posts
    701
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I copy the subfolders and there where the right permissions.
    Dimis

  8. #8
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    ok, one more chance, then i stop playing the game: what does your mysql error log say?
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast


Bookmarks

Posting Permissions

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