Problem with backup DB. about cloudbackupbundle HOT 8 CLOSED

Can you try to remove the quotes in your mysql db_port ?

from cloudbackupbundle.

I create var_dump of backup command:

string(180) "mysqldump --host='127.0.0.1' --port='3306' --user='tim' --password='' db1 > G:\db1\app\cache\prod/backup/mysql/db1.sql"

Can you try to remove the quotes in your mysql db_port ?

@dizda, I try this in my parameters.yml, but I still have this error:

database_port: null

I found what this suffix appear in this line:

$this->auth = sprintf("--host='%s' --port='%d' --user='%s' --password='%s'"

from cloudbackupbundle.

You should leave the port, did you try like this?

database_port: 3306

from cloudbackupbundle.

Weird, the command looks correct

from cloudbackupbundle.

You should leave the port, did you try like this?

@dizda Yes, I try it. The same error.

I change this line with suffix:

$this->auth = sprintf("--host='%s' --port='%d' --user='%s' --password='%s'"

to this in MySQL.php file:

$this->auth = sprintf("--host=\"%s\" --port=\"%d\" --user=\"%s\" --password=\"%s\"",

And it seems to work for me.

from cloudbackupbundle.

Hmm weird, I think it's because mysqldump's behavior is different on Windows.

Well, can you send a PR to fix this bug? Thanks

from cloudbackupbundle.

Well, can you send a PR to fix this bug? Thanks

Ok, I try to do it. Thanks

from cloudbackupbundle.

Fixed

from cloudbackupbundle.