pt-online-schema-change lacks feature of adding the "DATA DIRECTORY" to a new table

[Daniel Guzmán Burgos]

pt-osc only accepts changes that can be done with an ALTER TABLE. To move a table to a different directory, one must need to execute the full CREATE TABLE ... DATA DIRECTORY = /new/path

In order to do so, a new parameter can be added: --new-partition = /new/path

Code change can be something like:

if ( $o->get('new-partition') ) {
    my $ady = " DATA DIRECTORY = '". $o->get('new-partition')."'";
    $sql = $sql.${ady};
}

[Carlos Salguero (carlos-salguero)]

Thanks for your patch.
I've merged your code: https://github.com/percona/percona-toolkit/pull/143

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-714