PDA

View Full Version : Making an empty DB


Pneu
12-13-2002, 11:35 AM
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

Trumpcard
12-13-2002, 11:59 AM
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..

Pneu
12-14-2002, 12:18 PM
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