Reindl Harald
2013-06-17 12:24:16 UTC
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
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;
$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
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