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"
<s.vanslyck(a)postpro.net> 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