https://bugs.koozali.org/show_bug.cgi?id=12368

            Bug ID: 12368
           Summary: automysqlbackup does not add CREATE DATABASE to dump
    Classification: Contribs
           Product: SME Contribs
           Version: 10.0
          Hardware: ---
                OS: ---
            Status: CONFIRMED
          Severity: normal
          Priority: P3
         Component: smeserver-automysqlbackup
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

When restoring DBs I noticed that the the dump did not contain a CREATE
DATABASE command.

If you mangle your DB and restore a backup to the existing DB you are OK but
not if you lose the entire DB and structure.

This variable should probably be set:

CONFIG_mysql_dump_create_database='yes'

We can then see this in the DB dumps:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `crm` /*!40100 DEFAULT CHARACTER SET
utf8 */;

USE `crm`;

Not sure if this should be set as default - I would expect so?

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/

Reply via email to