MysqlDump - file too small or missing

[psy]

Hello

I installed the MysqlDump module as I was having problems with the Backup module.  Basically I wanted to take a copy of the live system and restore it on my development system to do some offline work. 

During testing of the module, all went well on my development system (windows) but when I tried to take a backup of a small production site (unix) I received the following error message:

-- Linux MysqlDump 1.2.2 module [ --opt --verbose --default-character-set=latin1 --compatible=mysql40 ] prefix=cms_
-- Filesize : 116 bytes

ERROR : backups/backup-2006-09-30_21-15-57.sql MISSING or TOO SMALL

I was able to get around the problem by doing an export using phpmyadmin then using MysqlDump on my dev system to restore the database.

If there is a limit on the file size, what is it?  Otherwise can you suggest what I was doing wrong?

thx
psy

[websherpa]

I have the same problem.  In my case it's because the scriipt ios tryign to access the database via the localhost path, and NOT the custom path I set up in CMSMADE simple, the script seems to make the assumption that all our databases reside on teh same localhost path.

My kingdom (what little there is) for a fix to this excellent utility.

webSherpa

[Greg]

Anyone find a solution to this problem?  I am using MysqlDump 1.2.3 with CMSMS 1.0.6 and get the same error as above

-- FreeBSD MysqlDump 1.2.3 module [ --opt --verbose --compatible=mysql40 --default-character-set=latin1 ] prefix=cms_
-- Filesize : 118 bytes
ERROR : backups/backup-2007-05-21_14-34-48.sql MISSING or TOO SMALL

[Kaylen]

I have the same problem. I am using cms1.1 and  MySQlDump 1.2.3

Is there a solution for this problem yet?

[djkirstyjay]

I am having this problem with cms 1.1.2 and MySQLDump 1.2.3.

Is there a solution yet?

[cyberman]

Have you set write permission for folder /backup?

[djkirstyjay]

Yes I did. I set them to 777.

[cyberman]

What's you umask value?

[djkirstyjay]

How do I find out that?!

[cyberman]

Please look in admin panel to Site admin > global settings.

[djkirstyjay]

Ah! I knew it rang a bell somewhere... right... file creation mask (unmask) is 022

[cyberman]

Have you tried umask 002 or an empty field?

[dvanoss]

I'm still having this same problem. Permissions are set to 777 and unmask is 002. I can use PhpMyAdmin for MySQL dumps but this would be easier.

[cyberman]

Try to use mysqldumper (mysqldumper.de).

[blast2007]

Maybe your problem is related to PHP settings of your host provider.

If function "exec" is disabled on php.ini, module mysqldump won't work anymore.

Best regards
blast