You can choose to use MySQL 5 as well, when creating a new db. When I
was on 1&1 (albeit UK; same I guess) I just created a new wiki so I
don't know about im/exporting. When I moved to
hostgator.com after six
awful months with 1&1, hostgator transferred and imported everything
for me, free. Not that that helps with your situation...
On 24/04/07, rex <rex(a)nosyntax.com> wrote:
I'm moving a wiki from one of my systems to
1and1.com. A number of
people have successfully installed Mediawiki there, so it's possible.
1) I uploaded and untarred Mediawiki 1.9.3.
2) I created .htaccess in the top-level wiki directory containing the line:
AddType x-mapp-php5 .php
(added because 1and1 uses PHP4 by default)
4) Clicking on
http://mydomain.com/mywiki/config
* PHP 5.2.1 installed
* Found database drivers for: MySQL
* PHP server API is cgi; using ugly URLs (index.php?title=Page_Title)
* Have XML / Latin1-UTF-8 conversion support.
* PHP's memory_limit is 40M. If this is too low, installation may fail!
* Have zlib support; enabling output compression.
* Couldn't find Turck MMCache, eAccelerator or APC. Object caching
functions cannot be used.
* GNU diff3 not found.
* Found GD graphics library built-in, image thumbnailing will be enabled
if you enable uploads.
* Installation directory: /homepages/123/d123456/htdocs/fbwiki
* Script URI path: /fbwiki
* Environment checked. You can install MediaWiki.
Filling in the fields and clicking on 'Install Mediawiki!' results in:
Generating configuration file...
# Database type: MySQL
# Loading class: DatabaseMysql
# Attempting to connect to database server as dbo123456...success.
# Connected to 4.0.27-standard-log
# Database db123456 exists
# There are already MediaWiki tables in this database. Checking if updates
are needed...
[...]
Deleting old default messages...A database query syntax error has occurred.
The last attempted database query was:
"(SQL query hidden)"
from within function "RecentChange::save".
MySQL returned error "1048: Column 'rc_id' cannot be null
(db123.perfora.net)"
The MySQL database was exported from a machine running MySQL 5.0.18
using the command:
mysqldump -u root -pxxxx --compatible=mysql40 wikidb > dumpfile.sql
The '--compatible=mysql40' argument is necessary because 1and1 uses
MySQL 4.x
Any hints on fixing this error would be appreciated. 1and1 has
phpMyAdmin installed, and I can also interact with the database via
MySQL commands from the shell command line.
Thanks,
-rex
--
"We are too soon old, and too late smart."
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
--
Gary Kirk