View Full Version : Emptying a Database...

02-26-2007, 10: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-27-2007, 12:06 AM

mysqldump --no-data yourdatabasename > outputfile.sql

that will recreate your database with the table structures only.