Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Type InnoDB Tables Moved

Discussion in 'General Discussion' started by jackal, Jan 28, 2004.

  1. jackal

    jackal Well-Known Member
    PartnerNOC

    Joined:
    Feb 23, 2002
    Messages:
    708
    Likes Received:
    0
    Trophy Points:
    316
    We are in the process of moving some accounts from a server to a new server, we have tried this in whm and also in shell.
    Both work but we have one problem that continues to exist.
    Somehow in every db that has this type of table (InnoDB ) they get corrupt in the move. All other db table types transfer ok without error.


    error : Can't open file: 'words.InnoDB'. (errno: 1)
    In phpmyadmin all these type tables say "in use not running"
    and the only way to fix is go into var/lib/mysql/ and delete the database. We then went back to old server and into phpmyadmin and downloaded the db and then uploaded via phpmyadmin to the new server and all workked ok , no problems with any tables, so it is something in the move that is doing it.

    Any idea what may be causing this, we believe it to be something on the new server because we have transfered on of these sites before to our other server without any issues.

    Hope someone can lead us in the right direstion to fix this issue.
     
    #1 jackal, Jan 28, 2004
    Last edited: Jan 28, 2004
  2. xphost

    xphost Well-Known Member

    Joined:
    Nov 12, 2003
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    156
    i have similar problem
     
    #2 xphost, Mar 24, 2004
  3. xphost

    xphost Well-Known Member

    Joined:
    Nov 12, 2003
    Messages:
    76
    Likes Received:
    0
    Trophy Points:
    156
    i found

    i try to optimize mysql and just add in /etc/my.cnf with any other options

    skip-innodb

    so after remove skip-innodb and restart mysql all work fine
     
    #3 xphost, Mar 24, 2004
  4. perlchild

    perlchild Well-Known Member

    Joined:
    Sep 1, 2002
    Messages:
    279
    Likes Received:
    0
    Trophy Points:
    166
    Using skip-innodb disables innodb tables(so new tables get created as myisam)

    Innodb tables are contained in special files and cannot be copied over in the usual manner. I recommend a mysqldump to transfer them from one server to the other.
     
    #4 perlchild, Mar 31, 2004
  5. Allin1Joe

    Allin1Joe Member

    Joined:
    Feb 28, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    If cPanel changes the way these files are backed up, then doing a restore on Inno can be done. The issue is they are creating a table, then trying to enable the constraints on that table which reference tables that might not exist yet. Then, data is being inserted that tries to reference data that doesn't exist yet. So, if you change your output to the following format, the restore will work perfectly:

    table structure (indexes and primary keys can be placed here)
    data

    Then, after ALL tables have been created and populated, create the constraints.
     
    #5 Allin1Joe, May 22, 2004
(You must log in or sign up to post here.)
Loading...
Similar Threads - Type InnoDB Tables
  1. whplus

    Different backup type?

    whplus, Jul 12, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    91
    whplus
    Jul 14, 2018
  2. ca2236

    Count Files By Type?

    ca2236, Jun 22, 2018, in forum: General Discussion
    Replies:
    7
    Views:
    97
    cPanelLauren
    Jun 26, 2018
  3. Rajesh Chauhan

    Remove a particular file type from server?

    Rajesh Chauhan, May 17, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    114
    cPanelLauren
    May 18, 2018
  4. Edward T.

    S3 - Change Storage Type

    Edward T., Apr 22, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    105
    cPanelMichael
    Apr 23, 2018
  5. Scott Galambos

    Modify PHP mime type properly?

    Scott Galambos, Apr 4, 2018, in forum: EasyApache
    Replies:
    2
    Views:
    165
    cPanelLauren
    Apr 5, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice