Import SQL

[Manoel J?nior]

I'm trying to do an import of data from a database with characters in UTF8, but when it arrives at the stage of import tagtext encounter problem below:

ERROR 1062 (23000) at line 2949923: Duplicate entry 'voc' for key 'tagtext'

I realized that words are accented characters, this would be the case, "voc?"

I am using the following parameter to import the data:

[root@host backup]# mysql -u myuser -p --default_character_set utf8 mydatabase < Forum-02-02-2016-Full-Backup.sql

What should I do? Thanks

[Manoel J?nior]

Sorry to ask this kind of help around here, but unfortunately the vb.com is dead, no one put any more and no one answers any more.

Here it is much more active, if anyone knows and can help with this question please help me.

[RichieBoy67]

Can you please elaborate what you are trying to do? Are you importing into a full database?

What is the character set of the new database?

[Manoel J?nior]

Originally Posted by RichieBoy67

Can you please elaborate what you are trying to do? Are you importing into a full database?

What is the character set of the new database?

Thanks Richie,

I'm trying to do a full import my database.

Collation of the original database: latin1_swedish_ci
Collation destination database: latin1_swedish_ci

I imported my database by phpMyAdmin and I'm trying to import from the command line because the phpMyAdmin is taking too long causing timeout.

My database has 2GB

[RichieBoy67]

Originally Posted by Manoel J?nior

Thanks Richie,

I'm trying to do a full import my database.

Collation of the original database: latin1_swedish_ci
Collation destination database: latin1_swedish_ci

I imported my database by phpMyAdmin and I'm trying to import from the command line because the phpMyAdmin is taking too long causing timeout.

My database has 2GB

ok but I think you use this

PHP Code:

mysql -uUSERNAME -pPASSWORD DATABASE < Yourbackup.sql 


Make sure you have an empty database. The error you are getting says "Duplicate Entry". If you had already tried importing using Phpadmin you should start over and clear it before importing again.

[Manoel J?nior]

I've done that, when giving error I clean the base and try again, but always the same problem.

I've taken the collation option in the import as you showed, but always the same mistake. It's a clean installation