Find the answer to your Linux question:
Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    mysql * < dumpfile.sql overwrite or update?


    when i mysql * < dumpfile.sql

    it will completelly replace all existing data and tables in database or its some update method? - Open, free and uncensorable websites, using Bitcoin cryptography and BitTorrent network

  2. #2
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    "mysql *" sounds wrong.
    Other than that, the mysql client will execute the sql statements of dumpfile.sql.
    So what happens depends of the contents of that file.
    You must always face the curtain with a bow.

  3. #3
    Linux Engineer docbop's Avatar
    Join Date
    Nov 2009
    Woodshed, CA
    I agreee with Irithori the * is not needed. Whatever is in the dumpfile will replace the same currently in mysql. The dumpfile is a text file so you can read it and see what its going to do.

  4. $spacer_open

Posting Permissions

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