Connection options

[ifsnop]

Connection options

[ifsnop]

tl;dr Not yet, give me a couple of days to thing best way to do it.

Although the link you provide doesn't work, I get the idea. The --protocol option is only useful to force a different type of connection, for example, connecting to localhost by default makes the connection using a socket. If you want to connect using tcp, you then use --protocol=TCP.

Please see:
http://php.net/manual/en/ref.pdo-mysql.connection.php

When the host name is set to "localhost", then the connection to the server is made thru a domain socket.

mysqldmp-php passes the host option directly to the dsn option of the constructor.

https://github.com/ifsnop/mysqldump-php/blob/master/src/Ifsnop/Mysqldump/Mysqldump.php#L194

Unfortunately, there is no way to connect using a socket different from the default one with the current mysqldump-php code.

Changes needed to support connecting through a socket would probably made the next version of mysqldump-php incompatible with the current one. Last option is currently not supported.

mysql:host=localhost;dbname=testdb
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb

[pdewouters]

Ah, you're right - it was working when I posted. Anyway, the use case would be when the hostname is followed by a custom path : localhost:/tmp/mysql5, so yes like in your example :)

Right now, we're just parsing the host parameter for a : and use the part after it for the socket
https://github.com/humanmade/backupwordpress/blob/master/classes/class-backup.php#L805

Adds socket parameter to mysqldump
https://github.com/humanmade/backupwordpress/blob/master/classes/class-backup.php#L866

[ifsnop]

Looks like using a DSN string is the best way to handle connection strings to databases. In the end, PDO will take care of it without parsing.

[pdewouters]

makes sense

[ifsnop]

Please, take a look at the devel branch.

[ifsnop]

Everything should be fixed by now.

I will bump version to 2.0 because now the constructor takes a dsn string as a parameter, the same that is needed by PDO to create the connection, and everything is parsed from there. Also now the default filename name equals to stdout, to mimic mysqldump behavoiur.

I rewrote some parts of old code, but didn't tag it yet to 2.0. If more positive comments are made, I will be very happy to improve things.