drizzledump --databases option does not appear to work

Bug #684434 reported by Patrick Crews
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Medium
Andrew Hutchings
7.0
Fix Released
Medium
Andrew Hutchings

Bug Description

When we attempt to use Drizzledump this way:
drizzledump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3...]

it appears that nothing is being migrated. The program is called and returns with no output, but neither of the two databases from my test are transferred.

If I attempt to migrate the databases individually --destination-database=db1...db1, everything works as expected.

To repeat, attempt to run the following:
./test-run --suite=mysql_migrate databases

You will observe that the test will fail due to the first expected database not being present in Drizzle.
drizzletest: At line 55: query 'SELECT * FROM $database1.t1' failed: 1146: Table 'drizzledump_migrate_test1.t1' doesn't exist

How we call drizzledump with this option.
../client/drizzledump --compact --host=127.0.0.1 --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --user=root --databases drizzledump_migrate_test1 drizzledump_migrate_test2

Related branches

Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
status: New → Confirmed
Changed in drizzle:
assignee: Andrew Hutchings (linuxjedi) → Patrick Crews (patrick-crews)
status: Confirmed → In Progress
Revision history for this message
Patrick Crews (patrick-crews) wrote :

There was an error in the test case - was reverifying.

After fixing the test I am still seeing this problem. The expected tables are on the MySQL server, but they are not making it to Drizzle. drizzledump runs silently when called.

../client/drizzledump --compact --host=127.0.0.1 --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --user=root --databases drizzledump_migrate_test1 drizzledump_migrate_test2

Changed in drizzle:
assignee: Patrick Crews (patrick-crews) → Andrew Hutchings (linuxjedi)
status: In Progress → Confirmed
Revision history for this message
Patrick Crews (patrick-crews) wrote :

The --all-databases option appears to work fine (all_databases test case from same test suite)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.