The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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. webtipster

    Your server does not support the connection encryption type

    webtipster, May 30, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    156
    webtipster
    May 31, 2017
  2. Masimo

    Changing cPanel from external to internal license type

    Masimo, May 2, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    211
    Infopro
    May 2, 2017
  3. SSy

    Add .php3 as a PHP AddType extension?

    SSy, Mar 29, 2017, in forum: CloudLinux
    Replies:
    2
    Views:
    164
    thaingoc
    Mar 30, 2017
  4. em.ci

    SOLVED WOFF2 - Web Open Font Format / mime type

    em.ci, Feb 9, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    323
    Infopro
    Feb 13, 2017
  5. mvandemar

    Exclude backing up specific filetype globally with cpbackup-exclude.conf

    mvandemar, Dec 21, 2016, in forum: Data Protection
    Replies:
    5
    Views:
    404
    cPanelMichael
    Dec 22, 2016

Share This Page