Is my command for backup the same as know i am using Innodb?

Discussion in 'Databases' started by ASTRAPI, Apr 3, 2011.

0
  1. #1
    Hello

    All my tables was Myisam and i was use this command for backup:

    /scripts/pkgacct account1
    Code (markup):
    and i got a working backup about 820MB.

    After 2-3 i convert many (not all) of my tables to Innodb and i want to ask if i must use the same command for backup as i got a bit smaller backup 810MB and as i know Innodb make my database much bigger about x3 or not?

    Also is there any command to repair and optimize innodb tables?

    Thank you
     
    ASTRAPI, Apr 3, 2011 IP
  2. mitgib

    mitgib Peon

    Messages:
    16
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I'm not sure, but try mysqlcheck -ro db_name, but /scripts/pkgacct will still backup your site, to just grab the db, mysqldump db_name > db_name.sql
     
    mitgib, Apr 3, 2011 IP