HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   daily backups of websites are empty. (http://www.howtoforge.com/forums/showthread.php?t=61660)

oliware 30th April 2013 10:30

daily backups of websites are empty.
 
The daily backup of all my websites are failing. The database files are empty.

I can restore all files, but the mysqldump is empty.

fe: db_c1devoogdt_wp_2013-04-28_22-32.sql.gz has a size of 58 bytes, when I unzip the file, size is 0.

How can I determine what is wrong?

I have a lot of entries like this in my cron.log:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

But where can I find where it gets his password ?

till 30th April 2013 10:56

Set the correct mysql root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

oliware 30th April 2013 11:00

when I manually login with that password, I can logon, but...
A typically buggie thing, my password is something like this:

<?php

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = 'abcd20C&';

?>

Can it be that the & is causing problems ?

till 30th April 2013 11:04

Yes, better use a password that does not contain chars that get interpreted on the shell as operators.

oliware 30th April 2013 11:15

indeed that was the problem, this shouldn't happen anymore anno 2013


All times are GMT +2. The time now is 04:14.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.