Hello,
I want to come back to the (safe) upgrading problem.
To upgrade a Wiki Brion Vibber wrote :
1) Back up your database
2) Grab the current code and put it in place of your old code
3) Follow the upgrade instructions.
In fact, I am unable to pass the first point :
Back up your database
I have not access directly to the database (which is on the access
provider site and I cannot use mysqldump commands) I can only manage the
database through phpMyadmin which is definitely not reliable.
This is the reason why we need the following procedure to upgrade.
1. Save the information stored in the database using a specific
Mediawiki tool.
2. Grab the current code and put it in place of your old code.
3. Import the information previously stored in the database using a
specific Mediawiki tool.
--------------------------------------------------------------------
As an example of the way phpMyadmin is working :
I just tried to export and import a small MySql database using
phpMyadmin with XML format.
I got the following error message:
Error
There seems to be an error in your SQL query. The MySQL server error
output below, if there is any, may also help you in diagnosing the
problem
ERROR: Unknown Punctuation String @ 1
STR: <?
SQL: <?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 2.11.3
-
http://www.phpmyadmin.net
-
- Host: framesproject.sql.free.fr
- Generation Time: Nov 08, 2008 at 04:18 PM
- Server version: 5.0.67
- PHP Version: 5.2.5
-->
<!--
- Database: 'framesproject'
-->
---------
this seems to mean that phpMyadmin is NOT able to read back the XML it has written.
And by experience I know that using the SQL format is hazardous.
Best regards
Francois Colonna