How to make database dump before closing (mysql) testcontainer

[marceloverdijk]

I'm trying to create mysql dump before closing the container like below:

        val mysql = MySQLContainer<Nothing>("mysql:latest")
            .apply {
                withDatabaseName("testdb")
                withUsername("testuser")
                withPassword("testpass")
            }
        mysql.start()
        
        mysql.execInContainer("mysqldump -h${mysql.host} -P${mysql.firstMappedPort} -u${mysql.username} -p${mysql.password} ${mysql.databaseName} --result-file=testdb.sql")
        
        mysql.copyFileFromContainer("testdb.sql", "/somewhere/testdb.sql")

        mysql.stop()

However it gives me back:

OCI runtime exec failed: exec failed: container_linux.go:380: starting container process caused: exec: 
"mysqldump -hlocalhost -P53149 -utestuser -ptestpass testdb --result-file=testdb.sql":
executable file not found in $PATH: unknown

I also tried with

mysql.execInContainer("/usr/bin/mysqldump ... --result-file=testdb.sql")

but that gives:

OCI runtime exec failed: exec failed: container_linux.go:380: starting container process caused: exec: 
"/usr/bin/mysqldump -hlocalhost -P54250 -utestuser -ptestpass testdb --result-file=testdb.sql":
stat /usr/bin/mysqldump -hlocalhost -P54250 -utestuser -ptestpass testdb --result-file=testdb.sql:
no such file or directory: unknown

Is mysqldump part of testcontainers or should I call it differently?

[eddumelendez]

Sorry for the delay. You should run container.execInContainer("mysqldump", "-u", container.getUsername(), "--password=" + container.getPassword(), container.getDatabaseName(), "--result-file=dump.sql");. You don't need the random port because it is running in the mysql instance itself.

[marceloverdijk]

Thanks! I'm going to try this. You r feedback is appreciated.