Geeklog Forums

I have tried to get my site to make a backup, bud I get this error.


I have looked in the forum for help but I can't find it.

I have tried to edit the line $_DB_mysqldump_path in the config.php file. In my phpinfo I can see some path to the mysql but I can get it to work.

This is from my phpinfo file.



I hope somebody can help me. I don't now if it can help you to see my phpinfo.

Sorry I forgot to say that I have another script that can make at backup of my mysql, and it works fine.

None of those are the paths. Usually, it is something like /usr/bin/mysqldump

If that isn't it, ask your provider.

Okay I tray that

For those of you that use Windows NT Servers, you may try this:

// optional settings for making database backups from within Geeklog
$_CONF['allow_mysqldump'] = 1; // 1 = on, 0 = off
$_DB_mysqldump_path = 'C:/mysql/bin/mysqldump.exe'; // path to mysqldump binary
$_CONF['mysqldump_options'] = '-Q'; // additional options for mysqldump

Notice the full path and EXE program on the same line. This is for a typical MySQL install dir, edit your paths accordingly.

Hi - Searching the forums says there is no answer to the following DB Backup problem apart from changing hosting services

This is the message I receive

Incorrect path or mysqldump utility not executable.
Check $_DB_mysqldump_path definition in config.php.
Variable currently defined as: /usr/bin/mysqldump

This is the reply from my hosting srvice at hostbreeze.com

Dear Customer,

That path is off limits to customers and I don't believe there is a hosting company that does allow it. If you need full access for stuff like that I advise upgrading to a dedicated server.

Any other suggestions please

thanks
laurie

For backups, Geeklog uses the mysqldump utility, which is part of a standard MySQL install. If your hosting service does not give you access to that utility, then you can't use Geeklog's backup function, I'm afraid.

As an alternative, I'd recommend phpMyAdmin as that has a backup function built in that does not rely on mysqldump.

Btw, many hosting services, mine included, do allow access to mysqldump, even on normal shared hosting accounts.

bye, Dirk

Hi Dirk

Thanks for the confirmation

BTW - which host do you use / run ?

I also use moodle and many hosts restrict the use of the chat facility moodle uses?

regards
laurie