The database schema is described in maintenance/tables.sql.

In your mysqldump command, the host argument has to specify a server running a MySQL server (to which you must have access). You've specified a HTTP URL. Assuming you can connect to the MySQL server at wikinition.common-culture.net, you should instead use:

mysqldump --host=wikinition.common-culture.net --user=foo -- password=bar dbname

Of course, the username and password here refer to those for the _MySQL account_, which is entirely separate from any wiki accounts.

Cheers,

-Patrick

On 11 Mar 2006, at 19:07, Franz wrote:

Franz schrieb:

...

I own the WikiSysop-Account of this wiki: http://wikinition.common-culture.net/index.php/Hauptseite

I would like to make a Back-Up of it.

I've got this command: mysqldump --host=hostname --user=username --password=userpassword --opt name-of-database

I've put in: mysqldump --host="http://wikinition.common-culture.net/index.php/ Hauptseite" --user="WikiSysop" --password="mypwd" --opt all-databases

nothing happens. I get a message how to use mysqldump. Any help?

Does maybe someone know a site where all surrounding structurs of wiki are described? how to acces them. I've got primary interest for the databases. _______________________________________________ Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l

If you use --opt all-databases, you'ld better use root as user with mysqldump. The dbuser created during install/config of mediawiki hasn't the rights to use other databases. And wikisysop is prolly not your dbuser, default mediawiki uses wikiuser (Correct me if I'am wrong list). You can always look in LocalSettings.php for the db user and db pass. Greetz Peter

On 3/12/06, Franz franzlinux@gmx.de wrote:

Patrick Collison schrieb:

...

The database schema is described in maintenance/tables.sql.

In your mysqldump command, the host argument has to specify a server running a MySQL server (to which you must have access). You've specified a HTTP URL. Assuming you can connect to the MySQL server at wikinition.common-culture.net, you should instead use:

mysqldump --host=wikinition.common-culture.net --user=foo -- password=bar dbname

Of course, the username and password here refer to those for the _MySQL account_, which is entirely separate from any wiki accounts.

thank you so far. I think the problem is the _MySQL account_

Somebody else set up the wiki for me.

---

Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l

-- I have plenty of common sense, I just choose to ignore it. --- Calvin