...

View Full Version : Emptying a Database...



johay
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.

guelphdad
02-27-2007, 12:06 AM
use


mysqldump --no-data yourdatabasename > outputfile.sql


that will recreate your database with the table structures only.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum