Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2003
    Posts
    20

    Unanswered: Problem with innodb files

    Hi !
    I am using mysql 4.x . How to take the backup of innodb files. I got the backup for MYISAM type files. I have taken .FRM , .MYI, .MYD files for taking back up of MYISAM type tables.

    Thanks in advance
    Regards,
    Prasanthi

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: Problem with innodb files

    Originally posted by prasanthik83
    Hi !
    I am using mysql 4.x . How to take the backup of innodb files. I got the backup for MYISAM type files. I have taken .FRM , .MYI, .MYD files for taking back up of MYISAM type tables.

    Thanks in advance
    Regards,
    Prasanthi

    There many free solution and one commercial software

    You can use MySqldump to create text files for your data

    You can copie your table space

    You can use replication with an other server acting as a backup server
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2003
    Posts
    20
    Hai !
    Thanks for ur reply. I took the backup using mysqldump into a text file. But how to import the file in to the destination database.

    Thanks in advance
    Regards
    Prasanthi

  4. #4
    Join Date
    Dec 2003
    Location
    Sweden
    Posts
    4
    Originally posted by prasanthik83
    Hai !
    Thanks for ur reply. I took the backup using mysqldump into a text file. But how to import the file in to the destination database.

    Thanks in advance
    Regards
    Prasanthi

    I guess you colud use LOAD DATA INFILE for that if you take out the part in the dump where the database is created. To run the dump (and create the database) run
    mysql database < backup-file.sql. /maria

    http://www.mysql.com/doc/en/mysqlimport.html

  5. #5
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Originally posted by pingu8613
    I guess you colud use LOAD DATA INFILE for that if you take out the part in the dump where the database is created. To run the dump (and create the database) run
    mysql database < backup-file.sql. /maria

    http://www.mysql.com/doc/en/mysqlimport.html
    Check that

    http://www.lasso-developpeur.net/us/...tab=db&lang=us
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  6. #6
    Join Date
    Dec 2003
    Posts
    20
    Hi !
    Thanks for ur reply. I used "mysql dbfirst < backup.sql " for importing data into the database. But it is giving the error like

    Can't create table '.dbfirst/Sys_Column.frm' (errno :150)

    I think this might be b'cos of referential integrity. While creating tables the base table must be created first and next the detailed table. But in the backup.sql file it is not in that order.
    How to solve this problem.Please tell me

    Regards
    Prasanthi

  7. #7
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    It seem that you are using the default mysqldump option
    That create table and then insert data.

    You should edit the script to have DDL script in one part and insert statements in other part
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  8. #8
    Join Date
    Dec 2003
    Posts
    20
    Hai!

    Thanks for ur reply.But i didn't understand the solution clearly. What do u mean by " edit the script to have DDL script in one part and insert statements in other part ". Explain that statement clearly.

    Waiting for ur quick reply.

    Regards
    Prasanthi

  9. #9
    Join Date
    May 2002
    Location
    chennai , tamil nadu , India
    Posts
    17

    mysql innodb backup and restore..mysqldumpa and import

    Hi Prasanthi

    take the dump as you would normally do using mysqldump

    open the dump file put this statement at the beginning

    SET FOREIGN_KEY_CHECKS=0;

    of the sql dump text file

    and import the same file as you would nomally import an sql dump file
    Chris, Developer, Chrisranjana.com,
    Ruby on Rails Developers,
    Php laravel Programmers,
    http://www.chrisranjana.com

Posting Permissions

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