Is it possible to download database with NO content?

Discussion in 'MySQL' started by yyyk9, Sep 4, 2008.

0
  1. #1
    I want to upload it to another database and create a new site.
     
    yyyk9, Sep 4, 2008 IP
  2. abhinavsmoudgil

    abhinavsmoudgil Peon

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Kindly mak your question clear as to what exactly do you want to do?
    did you mean that you have a database with some entries in it and all you want is that just the tables their columns etc are uploaded?
    Kindly make it clear........
     
    abhinavsmoudgil, Sep 4, 2008 IP
  3. Rulzar

    Rulzar Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    in SQL Server run

    create database dbnamehere

    and you have a blank db with no content.
     
    Rulzar, Sep 4, 2008 IP
  4. Affilit

    Affilit Peon

    Messages:
    70
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    "Scratches head" why not create an empty data bass on the site he wants it on?
    Other than than export and inport it.
     
    Affilit, Sep 4, 2008 IP
  5. vasago

    vasago Peon

    Messages:
    95
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #5
    For MySQL:

    Just create a backup of your current database. Depending on the tool you are using (MySQL Administrator or phpMyAdmin) you have different options. In the worst case you can open the created sql backup file after it's ready and manually delete all IMPORT statements there. Leave only the CREATE ones. This way you would get the database schema without any data and you can restore it on your new hosting..
     
    vasago, Sep 5, 2008 IP
  6. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #6
    i think, there should b some option in mysqldump using which no datas are selected duing the export of the database.
     
    maestria, Sep 7, 2008 IP
  7. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #7
    This command will export the database without data.
    mysqldump -d databasename > data.sql
    Code (markup):
     
    mwasif, Sep 8, 2008 IP