vb.org Archive - Import SQL

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Import SQL (https://vborg.vbsupport.ru/showthread.php?t=321700)

Manoel J?nior

02-03-2016 05:06 PM

Import SQL

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:

Code:

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:

Code:

[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

02-04-2016 05:32 PM

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

02-05-2016 07:35 AM

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

02-05-2016 08:02 AM

Quote:

Originally Posted by RichieBoy67 (Post 2564259)

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

02-05-2016 08:29 AM

Quote:

Originally Posted by Manoel J?nior (Post 2564261)

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

02-05-2016 08:56 AM

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

All times are GMT. The time now is 07:59 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01714 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: