Last modified: 2010-05-15 15:38:17 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T7328, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 5328 - Migration Database from MySQL 4.0.x to 5.0.x fails
Migration Database from MySQL 4.0.x to 5.0.x fails
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.5.x
PC Windows Server 2003
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-03-22 22:32 UTC by Thomas Schweikle
Modified: 2010-05-15 15:38 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Thomas Schweikle 2006-03-22 22:32:43 UTC
I have tried to migrate my mediawiki from MySQL 4.0.26 to MySQL
5.0.19. But this fails at two tables. I can import these to
MySQL 4.0.26, but not to MySQL 5.0.19:

DROP TABLE IF EXISTS `wiki-adm`.`cur`;
CREATE TABLE `wiki-adm`.`cur` (
  `cur_id` INT(8) NOT NULL,
  `cur_namespace` TINYINT(2) NOT NULL DEFAULT '0',
  `cur_title` VARCHAR(255) NOT NULL,
  `cur_text` MEDIUMTEXT NOT NULL,
  `cur_comment` TINYBLOB NOT NULL,
  `cur_user` INT(5) NOT NULL DEFAULT '0',
  `cur_user_text` VARCHAR(255) NOT NULL,
  `cur_timestamp` VARCHAR(14) NOT NULL,
  `cur_restrictions` TINYBLOB NOT NULL,
  `cur_counter` BIGINT(20) NOT NULL DEFAULT '0',
  `cur_is_redirect` TINYINT(1) NOT NULL DEFAULT '0',
  `cur_minor_edit` TINYINT(1) NOT NULL DEFAULT '0',
  `cur_is_new` TINYINT(1) NOT NULL DEFAULT '0',
  `cur_random` DOUBLE(0, 0) NOT NULL DEFAULT '0',
  `cur_touched` VARCHAR(14) NOT NULL,
  `inverse_timestamp` VARCHAR(14) NOT NULL,
  PRIMARY KEY (`cur_id`),
  UNIQUE INDEX `name_title` (`cur_namespace`, `cur_title`),
  INDEX `cur_title` (`cur_title`(20)),
  INDEX `cur_timestamp` (`cur_timestamp`),
  INDEX `cur_random` (`cur_random`),
  INDEX `name_title_timestamp` (`cur_namespace`, `cur_title`,
`inverse_timestamp`),
  INDEX `user_timestamp` (`cur_user`, `inverse_timestamp`),
  INDEX `usertext_timestamp` (`cur_user_text`, `inverse_timestamp`),
  INDEX `namespace_redirect_timestamp` (`cur_namespace`,
`cur_is_redirect`, `cur_timestamp`)
)
ENGINE = INNODB;

Leads to "Display width out of range for column 'cur_random'
(max=255)". In tune the table is only partly created (the column
"cur_random" is missing). The Table is useless for mediamiki.
Trying to access this database leads to various errors
about missing data or incorrect SQL statements (unknown column).

At the moment this makes it impossible to migrate from MySQL 4.0.x to 5.0.x
whithout breaking the whole existing wiki at my site.
Comment 1 Thomas Schweikle 2006-03-22 23:26:27 UTC
I have tried to export the database to an SQL-file, editing it to make the
missing tables being created compleately, but without success. I do have
complete tables now, but some entries are longer than 255 chars.

Here is what is output while importing the exported MySQL 4.0.26 database into
MySQL 5.0.19:


--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report                                             --
--                                                                            --
-- Title:   Summary Of The Migration Process                                  --
-- Date:    2006-03-23 00:20                                                  --
--------------------------------------------------------------------------------


1. Schema Migration
-------------------

  Number of migrated schemata: 1

  Schema Name:            wiki-adm
  - Tables:               32
  - Views:                0
  - Routines:             0
  - Routine Groups:       0
  - Synonyms:             0
  - Structured Types:     0
  - Sequences:            0

  Details:

  - Tables
      `wiki-adm`.`archive`
      --------------------
      `wiki-adm`.`blobs`
      ------------------
      `wiki-adm`.`brokenlinks`
      ------------------------
      `wiki-adm`.`categorylinks`
      --------------------------
      `wiki-adm`.`cur`
      ----------------
          Display width out of range for column 'cur_random' (max = 255)

      `wiki-adm`.`hitcounter`
      -----------------------
      `wiki-adm`.`image`
      ------------------
      `wiki-adm`.`imagelinks`
      -----------------------
      `wiki-adm`.`interwiki`
      ----------------------
      `wiki-adm`.`ipblocks`
      ---------------------
      `wiki-adm`.`links`
      ------------------
      `wiki-adm`.`linkscc`
      --------------------
      `wiki-adm`.`logging`
      --------------------
      `wiki-adm`.`math`
      -----------------
      `wiki-adm`.`objectcache`
      ------------------------
      `wiki-adm`.`oldimage`
      ---------------------
      `wiki-adm`.`page`
      -----------------
          Display width out of range for column 'page_random' (max = 255)

      `wiki-adm`.`pagelinks`
      ----------------------
      `wiki-adm`.`querycache`
      -----------------------
      `wiki-adm`.`recentchanges`
      --------------------------
      `wiki-adm`.`revision`
      ---------------------
      `wiki-adm`.`searchindex`
      ------------------------
      `wiki-adm`.`site_stats`
      -----------------------
      `wiki-adm`.`text`
      -----------------
      `wiki-adm`.`trackbacks`
      -----------------------
      `wiki-adm`.`transcache`
      -----------------------
      `wiki-adm`.`user`
      -----------------
      `wiki-adm`.`user_groups`
      ------------------------
      `wiki-adm`.`user_newtalk`
      -------------------------
      `wiki-adm`.`user_rights`
      ------------------------
      `wiki-adm`.`validate`
      ---------------------
      `wiki-adm`.`watchlist`
      ----------------------
  - Views
  - Routines
  - Routine Groups
  - Synonyms
  - Structured Types
  - Sequences


2. Data Bulk Transfer
---------------------

      `wiki-adm`.`archive`
      --------------------
          0 row(s) transfered.

      `wiki-adm`.`blobs`
      ------------------
          0 row(s) transfered.

      `wiki-adm`.`brokenlinks`
      ------------------------
          16 row(s) transfered.

      `wiki-adm`.`categorylinks`
      --------------------------
          0 row(s) transfered.

      `wiki-adm`.`cur`
      ----------------
          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
'MediaWiki default", "20050512095726", "", 0, "", "", "", 0, "20050512095726",
"7' at line 48
          0 row(s) transfered.

      `wiki-adm`.`hitcounter`
      -----------------------
          0 row(s) transfered.

      `wiki-adm`.`image`
      ------------------
          1 row(s) transfered.

      `wiki-adm`.`imagelinks`
      -----------------------
          1 row(s) transfered.

      `wiki-adm`.`interwiki`
      ----------------------
          Data truncation: Data too long for column 'iw_prefix' at row 98
          0 row(s) transfered.

      `wiki-adm`.`ipblocks`
      ---------------------
          0 row(s) transfered.

      `wiki-adm`.`links`
      ------------------
          110 row(s) transfered.

      `wiki-adm`.`linkscc`
      --------------------
          0 row(s) transfered.

      `wiki-adm`.`logging`
      --------------------
          1 row(s) transfered.

      `wiki-adm`.`math`
      -----------------
          0 row(s) transfered.

      `wiki-adm`.`objectcache`
      ------------------------
          65 row(s) transfered.

      `wiki-adm`.`oldimage`
      ---------------------
          0 row(s) transfered.

      `wiki-adm`.`page`
      -----------------
          Table 'wiki-adm.page' doesn't exist
          0 row(s) transfered.

      `wiki-adm`.`pagelinks`
      ----------------------
          Duplicate entry '999-0-Proxy' for key 1
          0 row(s) transfered.

      `wiki-adm`.`querycache`
      -----------------------
          0 row(s) transfered.

      `wiki-adm`.`recentchanges`
      --------------------------
          381 row(s) transfered.

      `wiki-adm`.`revision`
      ---------------------
          Incorrect integer value: '' for column 'rev_minor_edit' at row 1
          0 row(s) transfered.

      `wiki-adm`.`searchindex`
      ------------------------
          80 row(s) transfered.

      `wiki-adm`.`site_stats`
      -----------------------
          1 row(s) transfered.

      `wiki-adm`.`text`
      -----------------
          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
'MediaWiki default", "20050512095726", 0, "", ""),

                          (316, 8, "Anonymous", "Anon' at line 316
          Data truncation: Data too long for column 'old_text' at row 4
          0 row(s) transfered.

      `wiki-adm`.`trackbacks`
      -----------------------
          0 row(s) transfered.

      `wiki-adm`.`transcache`
      -----------------------
          0 row(s) transfered.

      `wiki-adm`.`user`
      -----------------
          4 row(s) transfered.

      `wiki-adm`.`user_groups`
      ------------------------
          4 row(s) transfered.

      `wiki-adm`.`user_newtalk`
      -------------------------
          0 row(s) transfered.

      `wiki-adm`.`user_rights`
      ------------------------
          4 row(s) transfered.

      `wiki-adm`.`validate`
      ---------------------
          0 row(s) transfered.

      `wiki-adm`.`watchlist`
      ----------------------
          0 row(s) transfered.


End of report.
--------------------------------------------------------------------------------
Comment 2 Brion Vibber 2006-03-23 00:02:12 UTC
We have no hope of reproducing this without knowing your upgrade procedure 
and some details of configuration.
Comment 3 Thomas Schweikle 2006-03-23 10:07:29 UTC
OK. Installation is as follows:

- Windows 2003 Server Enterprise
- IIS 6.0
- PHP 4.4.1
- PEAR 1.4.6
- Zend Engine 1.3.0
- Active Perl 5.8.7
- MySQL 4.0.26
- MediaWiki 1.5.7

Installation is compleately standard.
------------------------
Environment:
C:\Programme\php4>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
APR_ICONV_PATH=C:\Programme\Subversion\iconv
CLIENTNAME=ROSE
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SRV-KA-INT1
ComSpec=C:\WINDOWS\system32\cmd.exe
CVSNT=C:\Programme\CVSNT
CYGWIN=ntsec tty
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
HTTPS_PROXY=http://proxy:8080
HTTP_PROXY=http://proxy:8080
JAVA_HOME=C:\Progra~1\Java\jdk1.5.0_06
LOGONSERVER=\\SRV-KA-INT1
MIBDIRS=C:\Programme\php4\mibs
MYSQL_BIN=C:\Programme\MySQL\MySQL Server 5.0\bin
NUMBER_OF_PROCESSORS=4
OMPATH=C:\Program Files\Dell\OpenManage\oma\bin;C:\Program Files\Dell\OpenManage
\LU\bin;C:\Program Files\Dell\OpenManage\oldiags\bin
OS=Windows_NT
Path=C:\Program Files\Support Tools\;c:\cmd;C:\WINDOWS\system32;C:\WINDOWS;C:\WI
NDOWS\System32\Wbem;C:\Program Files\Dell\OpenManage\oma\bin;C:\Program Files\De
ll\OpenManage\LU\bin;C:\Program Files\Dell\OpenManage\oldiags\bin;C:\Program Fil
es\Dell\OpenManage\Array Manager;C:\Program Files\Microsoft SQL Server\80\Tools\
Binn\;C:\Programme\UPS\WorldShip\WorldShip;C:\Programme\Python23;C:\Programme\Pe
rl\bin\;C:\Programme\php4;C:\Programme\MySQL\MySQL Server 5.0\bin;C:\Programme\T
ools\bin;C:\Programme\CVSNT
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.VBS;.pyo;.pyc;.pyw;.py

PHPRC=C:\Programme\php4
PHP_PEAR_BIN_DIR=C:\Programme\php4
PHP_PEAR_DATA_DIR=C:\Programme\php4\pear\data
PHP_PEAR_DOC_DIR=C:\Programme\php4\pear\docs
PHP_PEAR_INSTALL_DIR=C:\Programme\php4\pear
PHP_PEAR_PHP_BIN=C:\Programme\php4\cli\php.exe
PHP_PEAR_SYSCONF_DIR=C:\Programme\php4
PHP_PEAR_TEST_DIR=C:\Programme\php4\pear\tests
PMTPMTPMT=@include_path@
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 3 Stepping 4, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0304
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=RDP-Tcp#16
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\3
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\3
TMPTMPTMPTMPT=@includ
USERDNSDOMAIN=WIBU.LOCAL
USERDOMAIN=WIBU
USERNAME=administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINDOWS

------------------------
PHP.INI:
[PHP]
engine = On
short_open_tag = On
asp_tags = Off
precision    =  12
y2k_compliance = On
output_buffering = On
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func=
serialize_precision = 100
allow_call_time_pass_reference = On
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =								
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
expose_php = On

max_execution_time = 30
max_input_time = 60
memory_limit = 16M

error_reporting = E_ALL & ~E_NOTICE
error_reporting = E_ALL & ~(E_NOTICE | E_USER_NOTICE | E_WARNING |
E_COMPILE_WARNING | E_CORE_WARNING | E_USER_WARNING) ; display all errors
display_errors = On
display_startup_errors = Off
log_errors = Off
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off

variables_order = "EGPCS"
register_globals = Off
register_argc_argv = On
post_max_size = 8M
gpc_order = "GPC"

magic_quotes_gpc = On
magic_quotes_runtime = Off    
magic_quotes_sybase = Off

auto_prepend_file =
auto_append_file =

default_mimetype = "text/html"
default_charset = "iso-8859-1"

include_path=".;C:\Programme\php4\pear;C:\Programme\jpgraph\src;D:\iis\intranet\includes;C:\Programme\php4\includes;"

doc_root =
user_dir =
extension_dir = "C:\Programme\php4\extensions"

enable_dl = Off
cgi.force_redirect = 0
fastcgi.impersonate = 1;

file_uploads = On
upload_tmp_dir = C:\Programme\php4\uploadtemp
upload_max_filesize = 2M

allow_url_fopen = On
default_socket_timeout = 60

;extension=php_bz2.dll
;extension=php_cpdf.dll
;extension=php_crack.dll
;extension=php_curl.dll
;extension=php_db.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_dbx.dll
;extension=php_domxml.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_hyperwave.dll
;extension=php_iconv.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_java.dll
;extension=php_ldap.dll
;extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pdf.dll
;extension=php_pgsql.dll
;extension=php_printer.dll
;extension=php_shmop.dll
extension=php_snmp.dll
extension=php_sockets.dll
;extension=php_sybase_ct.dll
;extension=php_w32api.dll
;extension=php_xmlrpc.dll
;extension=php_xslt.dll
;extension=php_yaz.dll
extension=php_zip.dll


[Syslog]
define_syslog_variables  = Off

[mail function]
SMTP = localhost
smtp_port = 25

;sendmail_from = me@example.com

[Java]
;java.class.path = .\php_java.jar
;java.home = c:\jdk
;java.library = c:\jdk\jre\bin\hotspot\jvm.dll 
;java.library.path = .\

[SQL]
sql.safe_mode = Off

[ODBC]
;odbc.default_db    =  Not yet implemented
;odbc.default_user  =  Not yet implemented
;odbc.default_pw    =  Not yet implemented
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1  
odbc.defaultlrl = 4096  
odbc.defaultbinmode = 1  

[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off

[mSQL]
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1

[PostgresSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off 
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0

[Sybase]
sybase.allow_persistent = On
sybase.max_persistent = -1
sybase.max_links = -1
sybase.min_error_severity = 10
sybase.min_message_severity = 10
sybase.compatability_mode = Off

[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10

[dbx]
dbx.colnames_case = "unchanged"

[bcmath]
bcmath.scale = 0

[browscap]
;browscap = "c:/Programme/php4/browscap.ini"

[Informix]
ifx.default_host =
ifx.default_user =
ifx.default_password =
ifx.allow_persistent = On
ifx.max_persistent = -1
ifx.max_links = -1
ifx.textasvarchar = 0
ifx.byteasvarchar = 0
ifx.charasvarchar = 0
ifx.blobinfile = 0
ifx.nullformat = 0

[Session]
session.save_handler = files
;session.save_path = /tmp
session.use_cookies = 1
;session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor     = 100
session.gc_maxlifetime = 1440
session.bug_compat_42 = 1
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 0
session.entropy_file =
;session.entropy_length = 16
;session.entropy_file = /dev/urandom
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
;mssql.connect_timeout = 5
;mssql.timeout = 60
;mssql.textlimit = 4096
;mssql.textsize = 4096
;mssql.batchsize = 0
;mssql.datetimeconvert = On
mssql.secure_connection = Off
;mssql.max_procs = 25

[Assertion]
;assert.active = On
;assert.warning = On
;assert.bail = Off
;assert.callback = 0
;assert.quiet_eval = 0

[Ingres II]
ingres.allow_persistent = On
ingres.max_persistent = -1
ingres.max_links = -1
ingres.default_database =
ingres.default_user =
ingres.default_password =

[Verisign Payflow Pro]
pfpro.defaulthost = "test-payflow.verisign.com"
pfpro.defaultport = 443
pfpro.defaulttimeout = 30
;pfpro.proxyaddress =
;pfpro.proxyport =
;pfpro.proxylogon =
;pfpro.proxypassword =

[Sockets]
sockets.use_system_read = On

[com]
;com.typelib_file = 
;com.allow_dcom = true
;com.autoregister_typelib = true
;com.autoregister_casesensitive = false
;com.autoregister_verbose = true

[Printer]
;printer.default_printer = ""

[mbstring]
;mbstring.language = Japanese
;mbstring.internal_encoding = EUC-JP
;mbstring.http_input = auto
;mbstring.http_output = SJIS
;mbstring.encoding_translation = Off
;mbstring.detect_order = auto
;mbstring.substitute_character = none;
;mbstring.func_overload = 0

[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.default_database = 
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
;fbsql.batchSize = 1000

[Crack]
;crack.default_dictionary = "c:\php\lib\cracklib_dict"

[exif]
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel    = UCS-2LE
;exif.encode_jis = 
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel    = JIS

------------------------
LocalSettings.php
<?php

# This file was automatically generated by the MediaWiki installer.
# If you make manual changes, please keep track in case you need to
# recreate them later.

$IP = "D:\\IIS\\wiki-admin";
ini_set( "include_path", ".;$IP;$IP/includes;$IP/languages" );
require_once( "includes/DefaultSettings.php" );

# If PHP's memory limit is very low, some operations may fail.
# ini_set( 'memory_limit', '20M' );

if ( $wgCommandLineMode ) {
	if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER ) ) {
		die( "This script must be run from the command line\n" );
	}
} elseif ( empty( $wgConfiguring ) ) {
	## Compress output if the browser supports it
	if( !ini_get( 'zlib.output_compression' ) ) @ob_start( 'ob_gzhandler' );
}

$wgSitename         = "WibuAdm";

$wgScriptPath	      = "";
$wgScript           = "$wgScriptPath/index.php";
$wgRedirectScript   = "$wgScriptPath/redirect.php";

## If using PHP as a CGI module, use the ugly URLs
#$wgArticlePath      = "$wgScript/$1";
$wgArticlePath      = "$wgScript?title=$1";

$wgStylePath        = "$wgScriptPath/skins";
$wgStyleDirectory   = "$IP/skins";
$wgLogo             = "$wgStylePath/common/images/logo_wibu.gif";

$wgUploadPath       = "$wgScriptPath/images";
$wgUploadDirectory  = "$IP/images";

$wgEmergencyContact = "administrator@local";
$wgPasswordSender	= "administrator@local";

$wgDBserver         = "localhost:3306";
$wgDBname           = "wiki-adm";
$wgDBuser           = "wiki-adm";
$wgDBpassword       = "********";
$wgDBprefix         = "";

## To allow SQL queries through the wiki's Special:Askaql page,
## uncomment the next lines. THIS IS VERY INSECURE. If you want
## to allow semipublic read-only SQL access for your sysops,
## you should define a MySQL user with limited privileges.
## See MySQL docs: http://www.mysql.com/doc/en/GRANT.html
#
# $wgAllowSysopQueries = true;
# $wgDBsqluser        = "sqluser";
# $wgDBsqlpassword    = "sqlpass";

# If you're on MySQL 3.x, this next line must be FALSE:
$wgDBmysql4 = $wgEnablePersistentLC = true;

## Shared memory settings
$wgUseMemCached = false;
$wgMemCachedServers = array();
#$wgUseTurckShm = function_exists( 'mmcache_get' ) && php_sapi_name() == 'apache';

## To enable image uploads, make sure the 'images' directory
## is writable, then uncomment this:
$wgDisableUploads		= false;
$wgUseImageResize		= false;
# $wgUseImageMagick = true;
# $wgImageMagickConvertCommand = "/usr/bin/convert";

## If you have the appropriate support software installed
## you can enable inline LaTeX equations:
# $wgUseTeX			= true;
$wgMathPath         = "{$wgUploadPath}/math";
$wgMathDirectory    = "{$wgUploadDirectory}/math";
$wgTmpDirectory     = "{$wgUploadDirectory}/tmp";

$wgLocalInterwiki   = $wgSitename;

$wgLanguageCode = "de";
$wgUseLatin1 = false;


$wgProxyKey = "171515af7e9439471d5372001ab23ac23a60b3cf49a0564f35bcfc7462ff2119";

## Default skin: you can change the default skin. Use the internal symbolic
## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook':
# $wgDefaultSkin = 'monobook';

## For attaching licensing metadata to pages, and displaying an
## appropriate copyright notice / icon. GNU Free Documentation
## License and Creative Commons licenses are supported so far.
# $wgEnableCreativeCommonsRdf = true;
$wgRightsPage = ""; # Set to the title of a wiki page that describes your
license/copyright
$wgRightsUrl = "";
$wgRightsText = "";
$wgRightsIcon = "";
# $wgRightsCode = ""; # Not yet used

# Only logged in users are allowed to edit
$wgWhitelistEdit = true;
?>

------------------------
MY.INI (for MySQL 4.0.26)
[client]
port=3306

[mysql]
#default-character-set=utf8

[mysqld]
port=3306
basedir="C:/Programme/MySQL/MySQL Server 4.0/"
datadir="D:/MySQL40"
max_connections=100
query_cache_size=0
innodb_data_home_dir="D:/MySQL40"

[WinMySQLAdmin]
Server="C:/Programme/MySQL/MySQL Server 4.0/bin/mysqld-nt.exe"

------------------------
MY.INI (for MySQL 5.0.19)
[client]
port=3308

[mysql]
default-character-set=utf8

[mysqld]
port=3308
basedir="C:/Programme/MySQL/MySQL Server 5.0/"
datadir="D:/MySQL50"
default-character-set=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=0
innodb_data_home_dir="D:/MySQL50"

[WinMySQLAdmin]
Server="C:/Programme/MySQL/MySQL Server 5.0/bin/mysqld.exe"

------------------------
Database export:
mysqldump --port=3306 --protocol=tcp --host=localhost \
  --add-drop-database --add-drop-table --user=root adm-wiki > adm-wiki.sql

------------------------
Database import:
mysql --port=3308 --protocol=tcp --host=localhost \
  --user=root < adm-wiki.sql

Comment 4 Brion Vibber 2007-01-17 12:02:28 UTC
Some old MySQL or mysqldump problem?

Closing this as INVALID...

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links