vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=321700

Import SQL
by Manoel Júnior
03 Feb 2016 18:06

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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

I am using the following parameter to import the data:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

What should I do? Thanks

Manoel Júnior 04 Feb 2016 18:32

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 05 Feb 2016 08:35

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 05 Feb 2016 09:02

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 05 Feb 2016 09:29

Quote:

Originally Posted by Manoel Júnior (Post 2564261)
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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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 05 Feb 2016 09:56

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 06:11.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.