Tim,
Your proposal to use buffered query worked. Thanks for that.
Now I am running into the following problem:
2017-06-28 22:49:58: Migrating image table to image_temp...
PHP Fatal error: Call to undefined function wfGetMimeMagic() in
/var/www/html/mediawiki/mediawiki-1.5.8/maintenance/FiveUpgrade.inc on line 709
-- Geert
-----Original Message-----
From: MediaWiki-l [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Tim
Starling
Sent: Monday, June 26, 2017 1:12 AM
To: mediawiki-l(a)lists.wikimedia.org
Subject: Re: [MediaWiki-l] Error converting MediaWiki database from 1.4.5 to 1.5.8
On 26/06/17 01:54, Geert Van Pamel wrote:
I try to convert a MediaWiki database from 1.4.5 to
1.5.8 (yes I know
I am a bit late. but up to now the database has perfectly served me ever since 2005). We
now want to migrate to a new Linux server, so we want to upgrade to the latest available
version.
Well done running 1.4 for so long, you are very special.
PHP Notice: mysql_query(): Function called without
first fetching all
rows from a previous unbuffered query in
/var/www/html/bike/includes/Database.php on line 349
We eventually stopped using unbuffered queries, because of issues like this. You can
either figure out why mysql_query() is being called and fix it, or you can convert the
query to a buffered query. A buffered query means trying to fit the entire result into
memory, which is more feasible on 2017 hardware than 2005 hardware!
You will need enough memory to fit the largest table into memory, not including the
"old" table since it is renamed not copied.
diff --git a/includes/Database.php b/includes/Database.php index 06c4b61..d99f8ce 100644
--- a/includes/Database.php
+++ b/includes/Database.php
@@ -359,7 +359,7 @@ class Database {
* @param string $sql SQL query.
*/
function doQuery( $sql ) {
- if( $this->bufferResults() ) {
+ if( true || $this->bufferResults() ) {
$ret = mysql_query( $sql, $this->mConn );
} else {
$ret = mysql_unbuffered_query( $sql, $this->mConn );
After you've upgraded, please run
ALTER TABLE <table name> CONVERT TO CHARACTER SET binary;
on all your tables, to avoid having UTF-8 stored as latin1, which can easily cause
corrupted backups.
-- Tim Starling
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l