[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Dumping drupal databases
From:       Reindl Harald <h.reindl () thelounge ! net>
Date:       2012-10-31 16:08:05
Message-ID: 50914CE5.8020800 () thelounge ! net
[Download RAW message or body]


Am 31.10.2012 16:34, schrieb Tim Johnson:
> * Johan De Meersman <vegivamp@tuxera.be> [121031 07:10]:
>   
>> Given the different location of the datafiles and assuming the
>> actual drupal does work, I'm starting to suspect that whatever
>> installer you used created a second instance of mysql. Your drupal
>> configfile should hold the necessary data to connect to it.
> 
>   You are correct. Running on 3307. (from settings.php) But even
>   loging into that instance was not showing me the drupal
>   databases - so I was stumped! I would guess that was because the
>   3307 instance was using the system-wide my.cnf instead of the
>   drupal my.cnf. I could not see from documentation how to invoke
>   mysql or mysqldump with a specific my.cnf.
>   See my response to your other email.
>   thanks Johan

you MUST NOT use "localhost" if you want to connect to
a different mysqld-port because "localhost" is unix-socket

mysql -h 127.0.0.1 --port=3307 -u <username> -p


["signature.asc" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]