Making an empty DB
 

I've been trying for a few days to make an empty .sql

After despairing at various sql GUI's and importing/exporing tables endlessly - and even trying a manual delete in EqAdmin (holding enter down for a VERY long time) - I have to accept that I have failed.

Can anyone more proficient with .sql export me the table structure without any data so I can source it in please? (I gather this is what db.sql is for, but this crashes out in EqAdmin with an incomplete structure)

Pneu

mysqldump -d <databasename> > emptydb.sql


If eq is your database..

mysqldump -d eq > somefile.sql

-d tells it not to dump data, so you'll just end up with the table structs..

Thanks Trumpcard! :P

Sadly, EqAdmin crashes when trying to read my empty structure so there must be something wrong with my database :(

I'm on another project for a few days now and christmas is looming, perhaps i'll sort this out on the christmas break.

Pneu