ImpEx from latin to UTF8

[S7rny]

Hello ,

i wont to impex my old database to a new database ..
my old database is latin1
my new database is utf8
please tell me how to put my info here and complete my work
php : 5.4.33
vsriosn my mysql is : 5.5.37-cll

<?php
if (!defined('IDIR')) { die; }

#################################################################### |;
# vBulletin  - Licence Number ....
# ---------------------------------------------------------------- # |;
# Copyright �2000�2014 vBulletin Solutions Inc. All Rights Reserved. |;
# This file may not be redistributed in whole or significant part. # |;
# ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
# http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
#################################################################### |;
# The following settings allow ImpEx to connect to the vBulletin 3
# database into which you will be importing data.

####
#
# TARGET - The target is the vBulletin database (where the  data is going to)
#
####

$impexconfig['target']['server']        = 'localhost';
$impexconfig['target']['user']            = 'username';
$impexconfig['target']['password']        = 'password';
$impexconfig['target']['database']        = 'vbulletin_forum';
$impexconfig['target']['tableprefix']    = '';

# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to true.
# If the source data is NOT stored in a database, set 'sourceexists' to false

$impexconfig['sourceexists']            = true;

####
#
# SOURCE - The source is the old forum database (where the  data is coming from)
#
####

# mysql / mssql
$impexconfig['source']['databasetype']    = 'mysql';  // mysql OR mssql
$impexconfig['source']['server']        = 'localhost';
$impexconfig['source']['user']            = 'username';
$impexconfig['source']['password']        = 'password';
$impexconfig['source']['database']        = 'source';
$impexconfig['source']['tableprefix']   = '';

####
#
# DUPLICATE CHECKING
# Where unique import id's are available ImpEx can check for duplicates with some
# Tier2 systems this will need to be set to false.
#
# yahoo_groups, YaBB 2.1, Ikonboard 3.1.5 (for attachments)
#
####

define('dupe_checking', false);

###############################################################################
####
#
# ADVANCED - For a standard import or a novice user leave the settings below.
#
####

// Advanced Target
$impexconfig['target']['databasetype']    = 'mysql';    // currently mysql only
$impexconfig['target']['charset']        = '';
$impexconfig['target']['persistent']    = false;     // (true/false) use mysql_pconnect

// Advanced Source
$impexconfig['source']['charset']        = '';
$impexconfig['source']['persistent']    = false;

# pagespeed is the second(s) wait before the page refreshes.

$impexconfig['system']['language']        = '/impex_language.php';
$impexconfig['system']['pagespeed']        = 1;

$impexconfig['system']['errorlogging']    = false;

define('impexdebug', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
define('shortoutput', false);
define('do_mysql_fetch_assoc', false);
define('step_through', false);
define('lowercase_table_names', false);
define('use_utf8_encode', false);
define('use_utf8_decode', true);
?>

[S7rny]

i wont to moved my old database to fresh database ,
Thank u

[BirdOPrey5]

Hello-

We do not support using Impex to move one VB install to another- you should run the upgrade script to upgrade any vBulletin version.

[S7rny]

can u please give a command to import the database via ssh as utf-8

[BirdOPrey5]

I am not aware of any such command. Doesn't mean one does not exist but it isn't within the realm of VB support.

[Zachery]

Why do you want to change the database encoding? Its not really recommended. Are you having a specific problem that you think requires you to?

[S7rny]

i wont to change it

[S7rny]

i do upgrade to vb5 from 3.8 but i got this error Action Required
Unexpected Text:
<?xml version="1.0" encoding="windows-1256"?> <b>API Error</b><br><b>Error:</b> Invalid route data<br>

[Zachery]

Why do you want to change from your current character encoding to UTF8?

[S7rny]

because my site is Arabic when some visitors goes to see some tags go ^&65uopk65-0- in the url
i wont to convert to short it and be good with SEO too , i try too many command in ssh but is failed

[S7rny]

I'm waiting

[S7rny]

can vBulletin make a tool to convert the database charset

[mbaghb]

i have the same problem.this problem is also in forum search because user enter an Arabic keyword in utf-8 codpage but my data are stored in 1256 codepage format and result not show currectly.
please note this problem clearly indicates in field sorting.

[S7rny]

i have a litlle problem ,

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
                        errorid bigint(20) unsigned NOT NULL auto_increment,
                        errortype varchar(10) NOT NULL default '',
                        classnumber varchar(3) NOT NULL default '',
                        importid bigint(20) NOT NULL default 0,
                        error varchar(250) default 'NULL',
                        remedy varchar(250) default 'NULL',
                        PRIMARY KEY (errorid)
                    ) TYPE=MyISAM

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

mysql error number: 1064

Date: Sunday 19th 2014f October 2014 08:41:55 AM
Database: ****_vb
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9 

[mbaghb]

i think this error occurred because you have error in sql command syntax . you should use ENGINE=MyISAM instead of TYPE=MyISAM .