Function load_db_opt

sql/sql_db.cc:544–640

*/

int load_db_opt(THD *thd, const char *path, Schema_specification_st *create)
{
  File file;
  char buf[256+DATABASE_COMMENT_MAXLEN];
  DBUG_ENTER("load_db_opt");
  int error= 0;
  size_t nbytes;
  myf utf8_flag= thd->get_utf8_flag();

  bzero((char*) create,sizeof(*create));

  /* Check if options for this database are already in the hash */
  if (!get_dbopt(thd, path, create))
  {
    if (!create->default_table_charset)
      error= -1;                                // db.opt did not exists
    goto err1;
  }

  /* Otherwise, load options from the .opt file */
  if ((file= mysql_file_open(key_file_dbopt,
                             path, O_RDONLY | O_SHARE, MYF(0))) < 0)
  {
    /*
      Create an empty entry, to avoid doing an extra file open for every create
      table.
    */
    put_dbopt(path, create);
    error= -1;
    goto err1;
  }

  IO_CACHE cache;
  if (init_io_cache(&cache, file, IO_SIZE, READ_CACHE, 0, 0, MYF(0)))
  {
    error= 1;
    goto err2;                                  // Not cached
  }

  while ((int) (nbytes= my_b_gets(&cache, (char*) buf, sizeof(buf))) > 0)
  {
    char *pos= buf+nbytes-1;
    /* Remove end space and control characters */
    while (pos > buf && !my_isgraph(&my_charset_latin1, pos[-1]))
      pos--;
    *pos=0;
    if ((pos= strchr(buf, '=')))
    {
      if (!strncmp(buf,"default-character-set", (pos-buf)))
      {
        /*
           Try character set name, and if it fails
           try collation name, probably it's an old
           4.1.0 db.opt file, which didn't have
           separate default-character-set and
           default-collation commands.
        */
        if (!(create->default_table_charset=