Find the answer to your Linux question:
Results 1 to 3 of 3
Hello, when i mysql * < dumpfile.sql it will completelly replace all existing data and tables in database or its some update method?...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User postcd's Avatar
    Join Date
    Apr 2011
    Posts
    333

    mysql * < dumpfile.sql overwrite or update?


    Hello,

    when i mysql * < dumpfile.sql

    it will completelly replace all existing data and tables in database or its some update method?
    "Avoid the Gates of Hell. Use Linux affordable VPS."

  2. #2
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,410
    "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
    Location
    Woodshed, CA
    Posts
    947
    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
    $spacer_close

Posting Permissions

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