http://www.andargor.com/

[Gilwen]

Does anyone know if there is a ms access or test file version of the mysql database that andargor has put together?

Thanks,

Gil

 

[andargor]

Does anyone know if there is a ms access or test file version of the mysql database that andargor has put together?

Actually, that's a very common request... Someone said they'd done it, but I'm not sure who.

What I could probably do is dump each table in a tab delimited file. Would that do it for you?

EDIT: I have a new version coming up.

Andargor

 

[John Morrow]

Does anyone know if there is a ms access or test file version of the mysql database that andargor has put together?

If you have Access 2002, get the XML version of the data and try "Get External Data" and then them "Import" with the file type as XML and see what you get.

The database is mostly in standard SQL and I've successfully loaded the data into a PostgreSQL database by making a change. Basically, you remove the database type specification (a MySQLism) near the end of the "CREATE TABLE" statement (and perhaps change a storage type or in the table definition if your database can't handle it) and it's pretty standard SQL. There is an SQL window in Access in Design mode. You can try some creative cutting and pasting if you know anything about SQL.

 

[Len]

If you have Access 2002, get the XML version of the data and try "Get External Data" and then them "Import" with the file type as XML and see what you get.

You get a bunch of tables named after HTML tags, and hundreds of errors.

 

[Gilwen]

Actually, that's a very common request... Someone said they'd done it, but I'm not sure who.

What I could probably do is dump each table in a tab delimited file. Would that do it for you?

EDIT: I have a new version coming up.

Andargor

I was finally successful at exporting the spells into a CSV file.
I think the program i was using to export was choking on the \n's in the longtext fields because i was only able to successfully export the fields that didn't contain the \n's. Next time I'll probably just replace the \n's with <BR>'s and see what happens.
Thanks for the offer to dump the tables though.

I look forward to the new version...any hints to as what changes there will be or what else it might contain?
Gil

 

[Gilwen]

If you have Access 2002, get the XML version of the data and try "Get External Data" and then them "Import" with the file type as XML and see what you get.

The database is mostly in standard SQL and I've successfully loaded the data into a PostgreSQL database by making a change. Basically, you remove the database type specification (a MySQLism) near the end of the "CREATE TABLE" statement (and perhaps change a storage type or in the table definition if your database can't handle it) and it's pretty standard SQL. There is an SQL window in Access in Design mode. You can try some creative cutting and pasting if you know anything about SQL.

I kinda did this, my tool was able to export the table as an XML file and then i imported that into excel but the strange thing is I had to format the longtext fields as zipcode to make them display correctly within excel...general or text formatting only displayed ########## all over the place. From the imported XML data I was able to save as a CSV and it was perfect.

Gil

 

[andargor]

New version is up (click on my sig). Basically a maintenance release, with several errors fixed. Also, domains are now included.

All that's really missing are races and templates, since I can't make up my mind on how to extract them.

Andargor

 

[Gilwen]

New version is up (click on my sig). Basically a maintenance release, with several errors fixed. Also, domains are now included.

All that's really missing are races and templates, since I can't make up my mind on how to extract them.

Andargor

Cool! thanks for the hard work...I know I get alot of use from the database!
BTW if anyone is needing an excel file dump of the database let me know.

Gil

 

[John Morrow]

You get a bunch of tables named after HTML tags, and hundreds of errors.

Well, that's a lot more useless than I imagined it would be...

 

[Janx]

Here's the simplest method I use (I do this stuff for a living):
mysqldump --flush-logs --add-drop-table --quick $1 >$1.sql

tweak the create table statements for compatibility with your database (minor differences)

replace \n with proper carriage returns for MS databases

check any needed padding for " ' and \ characters.

Once that's done, run the script on your flavor of database and you're rocking. I've done this to import databases from MySQL to SQL Server with no proplem. Access may be trickier, but then Access sucks.

CSVs and XML suck. I'd rather have the CREATE and INSERT statements anyday of the week when porting a database over. When doing databases, speak the language of databases.

What exactly does Andargor's site do? Haven't heard of it before?

Janx