Last modified: 2010-05-15 15:38:17 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.
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. --------------------------------------------------------------------------------
We have no hope of reproducing this without knowing your upgrade procedure and some details of configuration.
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
Some old MySQL or mysqldump problem? Closing this as INVALID...
