Page 1 of 2

MysqlDump - file too small or missing

Posted: Sat Sep 30, 2006 11:29 am
by 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

Re: MysqlDump - file too small or missing

Posted: Tue Oct 31, 2006 7:36 pm
by 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

Re: MysqlDump - file too small or missing

Posted: Mon May 21, 2007 7:38 pm
by 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

Re: MysqlDump - file too small or missing

Posted: Wed Aug 22, 2007 3:55 pm
by Kaylen
I have the same problem. I am using cms1.1 and  MySQlDump 1.2.3

Is there a solution for this problem yet?

Re: MysqlDump - file too small or missing

Posted: Sat Sep 08, 2007 7:43 pm
by djkirstyjay
I am having this problem with cms 1.1.2 and MySQLDump 1.2.3.

Is there a solution yet?

Re: MysqlDump - file too small or missing

Posted: Sun Sep 09, 2007 5:29 pm
by cyberman
Have you set write permission for folder /backup?

Re: MysqlDump - file too small or missing

Posted: Mon Sep 10, 2007 1:03 pm
by djkirstyjay
Yes I did. I set them to 777.

Re: MysqlDump - file too small or missing

Posted: Thu Sep 13, 2007 3:12 pm
by cyberman
What's you umask value?

Re: MysqlDump - file too small or missing

Posted: Thu Sep 13, 2007 3:34 pm
by djkirstyjay
How do I find out that?!

Re: MysqlDump - file too small or missing

Posted: Thu Sep 13, 2007 8:27 pm
by cyberman
Please look in admin panel to Site admin > global settings.

Re: MysqlDump - file too small or missing

Posted: Fri Sep 14, 2007 2:59 pm
by djkirstyjay
Ah! I knew it rang a bell somewhere... right... file creation mask (unmask) is 022

Re: MysqlDump - file too small or missing

Posted: Fri Sep 14, 2007 3:48 pm
by cyberman
Have you tried umask 002 or an empty field?

Re: MysqlDump - file too small or missing

Posted: Thu Feb 21, 2008 10:35 pm
by 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.

Re: MysqlDump - file too small or missing

Posted: Fri Feb 22, 2008 3:47 am
by cyberman
Try to use mysqldumper (mysqldumper.de).

Re: MysqlDump - file too small or missing

Posted: Fri Feb 22, 2008 9:29 am
by 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