Re: hi how to merge data of various sql files

2006-05-17 Thread Dilipkumar
Hi, In backup directory cat *.sql | mysql -u root -p database * and *Use import which is given below* * Dilipkumar wrote: HI, In this case if you want to import try to use force method. mysqlimport -u root -p *-i* databasename filename.sql _*(-i, --ignoreIf duplicate unique key wa

Re: hi how to merge data of various sql files

2006-05-17 Thread Dilipkumar
HI, In this case if you want to import try to use force method. mysqlimport -u root -p *-i* databasename filename.sql _*(-i, --ignoreIf duplicate unique key was found, keep old row)*_ VenuGopal Papasani wrote: hi all, I have got a problem.I have data entered in different machines in