Hi,
Is there a straightforward way to create a new sqlite database for
mediawiki, all ready for me to import data from an XML dump into? I
want this in order to easily populate fresh databases with data from
my mediawiki site, for easy testing of new stuff.
I expected a command like the following to work:
sqlite3 db.sqlite < maintenance/tables.sql
But there are lots of errors, starting with:
Error: near line 53: near "AUTO_INCREMENT": syntax error
Error: near line 130: no such table: main.user
Error: near line 131: no such table: main.user
Error: near line 132: near "(": syntax error
I know I can create a new database using the install.php script, but
that's overkill for me, and if possible I'd like to script the
creation of an appropriate table structure that I can then import a
database dump into.
Does anybody have any suggestions? Why doesn't the above command
work? Reading the code of how the install.php script works implies
to me that it's roughly how the tables are set up. Is there some
step I'm missing?
Or should I go about this a different way entirely?
Thanks in advance,
Nick White