[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

[omiossec]

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

[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

[pingu8613]

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

[omiossec]

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

[prasanthik83]

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

[omiossec]

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

[prasanthik83]

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

[chrisranjana]

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