[mudman]

Hi all,

Firstly I found a nice program called Access2Mysql it allows you to make an Access mdb file from the host MSQL very nice I must say.

Since i know nothing about MSQL it was very nice to see all the tables laid out in Access so that I could easily see and edit them.

I edited a few minor things and then exported and boom there was a new (in this case did not want to overwrite eq database) in the database tab. in mysql


First question:

- Now that, that database is added to mysql host , this database would be active correct., I.E all i have to do is refer to this database in the DB.INI file in eqemu 312 database? I.E.

database=eq change this to database=eqtest ? for example?

-also: can mysql database be dropped is this just a sample db?


Ok seccond question:

I look at all these tables like faction table, name filters, guild, books ect. I am wondering why not just delete some of these tables and clean out the database a bit maybe less Link Deaths and less problems? For example who really cares about tradeskillrecipe table when you can summon anything.


Last question.
Making spawns
the following tables.

spawn2
spawnentry
spawngroup are all that are needed to work with right?

is there a simple system to working with these three tables? ie what relationship ect?


Thanks for the help
Mudman

Defender server