Discussion:
supress create database / use statement in dumps?
Reindl Harald
2013-06-17 12:24:16 UTC
Permalink
CREATE DATABASE IF NOT EXISTS `cms_demo` DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
USE `cms_demo`;

is there a way to skip the database-statements as default in dumps?

* you have a website with a database
* you create a clone of it
* you create a new database
* you take a dump
* you import the dump into the clone
* you do not want USE `origin` in the dump because you seelct the
new database and like to import the dump there without touching
the origin one on the same server
______________________________

this config does exactly the right except the db-statements
$cfg['Export']['sql_drop_database'] = false;
$cfg['Export']['sql_drop_table'] = true;
$cfg['Export']['sql_if_not_exists'] = true;
--
Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, HofmÃŒhlgasse 17
CTO / CISO / Software-Development
m: +43 (676) 40 221 40, p: +43 (1) 595 3999 33
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm
Marc Delisle
2013-06-17 16:20:12 UTC
Permalink
Post by Reindl Harald
CREATE DATABASE IF NOT EXISTS `cms_demo` DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
USE `cms_demo`;
is there a way to skip the database-statements as default in dumps?
Hi,
there is no such feature in 4.0.
--
Marc Delisle
http://infomarc.info
Loading...