Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    May 2006
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Emptying a Database...

    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.

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    use

    Code:
    mysqldump --no-data yourdatabasename > outputfile.sql
    that will recreate your database with the table structures only.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •