enterprise-support team mailing list archive

[Bart Verwilst <bart@xxxxxxxxxxx>]

Public bug reported:

Scenario:

I want to restore table testdb.mytable to testdb2, in order to have a
separate copy. Database testdb2 exists, but table mytable doesn't exist
yet.

myloader -B testdb2 -s testdb.mytable -d . -o

Expected behaviour:

- Table testdb2.mytable is created from the schema.sql file corresponding to testdb.mytable
- Data is imported into testdb2.mytable

Seen behaviour:

** (myloader:23885): CRITICAL **: Error restoring testdb2.mytable from
file testdb.mytable.sql.gz: Table 'testdb2.mytable' doesn't exist

Which means I have to import the schema manually first.

** Affects: mydumper
     Importance: Undecided
         Status: New

** Description changed:

  Scenario:
  
  I want to restore table testdb.mytable to testdb2, in order to have a
  separate copy. Database testdb2 exists, but table mytable doesn't exist
  yet.
  
  myloader -B testdb2 -s testdb.mytable -d . -o
  
  Expected behaviour:
  
  - Table testdb2.mytable is created from the schema.sql file corresponding to testdb.mytable
  - Data is imported into testdb2.mytable
  
  Seen behaviour:
  
  ** (myloader:23885): CRITICAL **: Error restoring testdb2.mytable from
- file test.mytable.sql.gz: Table 'testdb2.mytable' doesn't exist
+ file testdb.mytable.sql.gz: Table 'testdb2.mytable' doesn't exist
  
  Which means I have to import the schema manually first.

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1514892

Title:
  Table 'x.y' doesn't exist

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1514892/+subscriptions