Thanks, I'll go to a shell prompt and do it right.

The reason I added for XML is that the backup manual <https://www.mediawiki.org/wiki/Manual:Upgrading#Back_up_existing_files_and_the_database> says to take an xml backup too. The sql backup was taken by someone else, thru php, and I don't know if the settings he selected will allow a restore.


On 4/11/2015 11:31 AM, Jeremy Baron wrote:
On Apr 11, 2015 11:26, "Steve VanSlyck" <[email protected]> wrote:
I don't see anything wrong with this syntax:
But I am getting a complaint, "#1064 - 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 'mysqldump --user=LoginName
--password=MyPassword my_wiki' at line 1"
The example given was mysqldump --user=wikidb_user
--password=wikidb_userpassword wikidb --xml > file.xml

given where?

2 problems:
* you're executing that at a mysql prompt not a shell prompt. (mysqldump is
its own separate program)
* you should leave off the --xml and dump as SQL

-Jeremy
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply via email to