[MediaWiki-l] Creating a fresh SQLite database for mediawiki

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