In MySQL and other SQL database servers, a equivalent to "clean" is a precaution in case there is an existing database that you want to replace. However, if the database does not exist, the restore just goes ahead as expected. In other words, it works both ways. Here's the MySQL use case: You make a regular data dumps and have it include the equivalent to clean. If you restore a database back to the same server, it would overwrite the existing database. However, if you restore the same dump on a new machine running MySQL, it would detect that the database is not there but continue on and restore the database. In pgsql, it failed when it did not detect a pre-existing database.
»
Reply
Search
Windows for Intel Macs
Todd Ogasawara's Windows for Intel Macs ($7.99USD published by O'Reilly Media) is for Intel Mac users running Bootcamp or Parallels who want to learn more about running Microsoft Windows XP on Mac. It also provides specific tips and hints for using Parallels Desktop for Mac.
In MySQL and other SQL
In MySQL and other SQL database servers, a equivalent to "clean" is a precaution in case there is an existing database that you want to replace. However, if the database does not exist, the restore just goes ahead as expected. In other words, it works both ways. Here's the MySQL use case: You make a regular data dumps and have it include the equivalent to clean. If you restore a database back to the same server, it would overwrite the existing database. However, if you restore the same dump on a new machine running MySQL, it would detect that the database is not there but continue on and restore the database. In pgsql, it failed when it did not detect a pre-existing database.