<div>
It depends on your database dump file. E.g. using mysqldump, it is possible to request a &quot;drop database&quot; in the dump, using --add-drop-database<br />
So have a look at the beginning of your backup.sql and if you can see something like &quot;drop database ...&quot; then you don't have to explicitly drop it.<br />
<br />
As for creation, there's a similar option --no-create-db; unless invoked this way the &quot;create database&quot; will be present in the dump. Look for it.
</div>


It depends on your database dump file. E.g. using mysqldump, it is possible to request a "drop database" in the dump, using --add-drop-database
So have a look at the beginning of your backup.sql and if you can see something like "drop database ..." then you don't have to explicitly drop it.

As for creation, there's a similar option --no-create-db; unless invoked this way the "create database" will be present in the dump. Look for it.

<div>
<div class="content wysiwyg-content">
Hello,<br />
&nbsp; I have a database already created. Now, I would like to restore a backup copy. Does the commands MySQL -&lt;id&gt; -p &lt;database&gt; &lt;&nbsp;backup.sql delete the existing database and then create a new one or do I have to do the following<br />
<br />
1: delete the existing DB<br />
2: Create the database<br />
2: restore the backup<br />
<br />
Thanks for your help
</div>
</div>


Hello,
  I have a database already created. Now, I would like to restore a backup copy. Does the commands MySQL -<id> -p <database> < backup.sql delete the existing database and then create a new one or do I have to do the following

1: delete the existing DB
2: Create the database
2: restore the backup

Thanks for your help

restore mysql server question

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.