[mysqldef] How can use SSL/TLS?

[shiroemons]

I am trying to see if I can connect to PlanetScale (MySQL8).

$ mysqldef --version 
v0.11.40
$ mysqldef -h example.psdb.cloud -u username -ppassword database_name > schema.sql
2022/03/07 00:25:22 Error on DumpDDLs: Error 1105: unknown error: Code: UNAVAILABLE
server does not allow insecure connections, client must use SSL/TLS

How can use SSL/TLS?

refs: Connecting to PlanetScale securely

[k0kubun]

I implemented a relevant feature in v0.11.42. Could you try it again with v0.11.42?

[shiroemons]

I tried, but got another error.

$ mysqldef --version
v0.11.44
$ mysqldef -h example.psdb.cloud -u username -ppassword database_name > schema.sql
2022/03/11 02:05:38 Failed to read '-': stdin is not piped

[k0kubun]

Please try mysqldef -h example.psdb.cloud -u username -ppassword database_name < schema.sql instead.

[shiroemons]

@k0kubun

Thank you! It worked!

$ mysqldef -h example.psdb.cloud -u username -ppassword database_name < schema.sql
-- Apply --
CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) DEFAULT 'hoge',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

I forgot to give the export option...

$ mysqldef -h example.psdb.cloud -u username -ppassword database_name --export > schema.sql

The export worked too!