hi all,
I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in a same
database.Herethere was a problem in merging, There were some tables
which does´not change
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
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