trying to copy my sql database

Dear,

I’m trying to backup the msql database of my alfresco stack but am unable to access it.
In linux when I type mysql he asks me to install mysql. Via the mysqldump this should be possible but I’m unable to access mysql.

Thanks for your help,
Kristof

Hi,

To use the bundled MySQL go to your current installation directory, and then cd to mysql/bin

Type

./mysql -u root -p

to connect to the server

Cheers

Hello Antonio,

Indeed this works perfectly with my password. To backup the mysql database however I need to use mysqldump.
Using the same logic I used ./mysqldump – u root – p … but I’m unable to get this to work. Can you help me with the right access to get a copy of the mysql database?

Kristof

Hi kristof,

Add to that line of code

-S ../tmp/mysql.sock

and it should work now. You just found a bug! :) We will try to fix it for the next release, thanks for reporting.

Cheers