Option `structureOnly` not works as expected anymore

[Koc]

I have next configuration for Magento2 setup:

Config

<?xml version="1.0" encoding="UTF-8"?>
<phpbu xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:noNamespaceSchemaLocation="http://schema.phpbu.de/6.0/phpbu.xsd">
    <adapters>
        <adapter type="env" name="env" />
    </adapters>
    <backups>
        <backup name="abc">
            <source type="mysqldump">
                <option name="host" value="adapter:env:MYSQL_HOST" />
                <option name="port" value="adapter:env:MYSQL_PORT" />
                <option name="databases" value="adapter:env:MYSQL_DATABASE" />
                <option name="user" value="adapter:env:MYSQL_USER" />
                <option name="password" value="adapter:env:MYSQL_PASSWORD" />
                <option name="structureOnly"                        value="session,report_viewed_product_index,customer_visitor,search_query,report_event,report_viewed_product_aggregated_monthly,report_viewed_product_aggregated_yearly,report_viewed_product_aggregated_daily" />
            </source>

            <target dirname="dumps"
                    filename="abc-mage-%Y%m%d-%H%i.sql"
                    compress="gzip" />

            <sync type="amazons3">
                <option name="key" value="adapter:env:AWS_KEY" />
                <option name="secret" value="adapter:env:AWS_SECRET" />
                <option name="endpoint" value="adapter:env:AWS_ENDPOINT" />
                <option name="bucket" value="adapter:env:AWS_BUCKET" />
                <option name="region" value="adapter:env:AWS_REGION" />
                <option name="useMultiPartUpload" value="true" />
                <option name="path" value="adapter:env:AWS_PATH" />
            </sync>
            <cleanup type="stepwise">
                <option name="daysToKeepDaily" value="40" />
                <option name="weeksToKeepWeekly" value="30" />
                <option name="monthToKeepMonthly" value="12" />
            </cleanup>
        </backup>
    </backups>
</phpbu>

The problem is that in fact option structureOnly enables structure only for all tables (not only mentioned). I'm pretty sure that this option works fine few years ago.

As you can see from the screenshoot from s3 - first 2 files was created with provided config, and 3rd - with commented option

[sebastianfeldmann]

What MySQL version are you using?

What structureOnly does is, it creates two mysqldump commands. One where it only dumps the structure and then one with the data where it ignores alle the structureOnly tables.

mysqldump --all-databases --no-data && mysqldump --all-databases --ignore-table='foo' --ignore-table='bar' --skip-add-drop-table --no-create-db --no-create-info

You can check the behavior by running phpbu --debug and make sure that both commands are executed.

[Koc]

I'm using Mysql (percona) 5.7.44-48.

Will try to debug it with corresponding flag

[Koc]

Here result with debug flag :

phpbu 6.0.30 by Sebastian Feldmann and contributors.

backup: [mysqldump] *******************************************************
("/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --no-data && "/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --ignore-table='session' --ignore-table='report_viewed_product_index' --ignore-table='customer_visitor' --ignore-table='search_query' --ignore-table='report_event' --ignore-table='report_viewed_product_aggregated_monthly' --ignore-table='report_viewed_product_aggregated_yearly' --ignore-table='report_viewed_product_aggregated_daily' --skip-add-drop-table --no-create-db --no-create-info) | "/usr/bin/gzip" > /home/phpbu/dumps/project-mage-20250702-2143.sql.gz
ok

sync: [amazons3] **********************************************************
upload: done
ok

cleanup: [stepwise] *******************************************************
ok

Time: 1 second, Memory: 22.00MB

OK (1 backup, 0 checks, 0 crypts, 1 sync, 1 cleanup)

And uncommented config:

                <option name="structureOnly"
                        value="session,report_viewed_product_index,customer_visitor,search_query,report_event,report_viewed_product_aggregated_monthly,report_viewed_product_aggregated_yearly,report_viewed_product_aggregated_daily" />

And it dumps only structure for all tables. Don't know, is it related, but I'm using Docker.

[sebastianfeldmann]

Can you try to run the command manually and see if it fails or even run the two mysqldump commands seperately.

("/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --no-data && "/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --ignore-table='session' --ignore-table='report_viewed_product_index' --ignore-table='customer_visitor' --ignore-table='search_query' --ignore-table='report_event' --ignore-table='report_viewed_product_aggregated_monthly' --ignore-table='report_viewed_product_aggregated_yearly' --ignore-table='report_viewed_product_aggregated_daily' --skip-add-drop-table --no-create-db --no-create-info) | "/usr/bin/gzip" > /home/phpbu/dumps/project-mage-20250702-2143.sql.gz

Seperately:

"/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --no-dat

"/usr/bin/mysqldump" --user='project' --password='******' --host='mysql' --port='3306' 'project' --ignore-table='session' --ignore-table='report_viewed_product_index' --ignore-table='customer_visitor' --ignore-table='search_query' --ignore-table='report_event' --ignore-table='report_viewed_product_aggregated_monthly' --ignore-table='report_viewed_product_aggregated_yearly' --ignore-table='report_viewed_product_aggregated_daily' --skip-add-drop-table --no-create-db --no-create-info

[Koc]

Sorry for the late response. Here what I have:

 "/usr/bin/mysqldump" --user='aaaa' --password='bbbb' --host='mysql' --port='3306' 'cccc' --ignore-table='session' --ignore-table='report_viewed_product_index' --ignore-table='customer_visitor' --ignore-table='search_query' --ignore-table='report_event' --ignore-table='report_viewed_product_aggregated_monthly' --ignore-table='report_viewed_product_aggregated_yearly' --ignore-table='report_viewed_product_aggregated_daily' --skip-add-drop-table --no-create-db --no-create-info


Illegal use of option --ignore-table=<database>.<table>

phpbu@62b087d70aa6:~$ mysql --version
mysql from 11.8.2-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using  EditLine wrapper

I will try to install percona-based client (like I'm using on the server)

[sebastianfeldmann]

Try to prefix the tables with the database name --ignore-table='mydb.session'