View Full Version : Emptying a Database...

02-26-2007, 09:01 PM
Right, i have a database on my computer which i backup onto my pc a long time ago it's a massive DB for my standers (5mb) But, now i have a problem, of getting the db onto my host and emptying it i try to copy and paste as a sql query, but my comp specs are just to damn bad (Old computer) , and i can't upload (import) as on my host the max is only 2 mb. and my DB is 5 mb. Once it's emptied it will be fine..

Any suggestions...

P/s: Sorry if it's not well explained. ;), Was kind of in a rush.

02-26-2007, 11:06 PM

mysqldump --no-data yourdatabasename > outputfile.sql

that will recreate your database with the table structures only.