pp5.31 - dbbackup / bug in adm-misc.php

jmar · August 8th, 2006, 04:36 AM

Hi,

i have problems to backup the pp database over acp
"adm-misc.php?admact=backup. " it tells me the following incorrect and dangerous! information:

Code:

Content visible to verified customers only.

Values for userX, passX, dbnameX are correct, i've checked it two times. the backupfolder rights are 0777

The backupscript creates for each db_table a sql-file with its tablename, but theres no sql-data in it. only a header text is in there, example: photos.sql-file

Code:

Content visible to verified customers only.

where does this Information come from? -> dbnameXphotos
whats this?-------------------------------^^^^^^^^^^ dbnametablename - there is a missing blank

cmd comes from adm-misc.php #1889 under the ADM-BACKUP part

Code:

Content visible to verified customers only.

it should be:

Code:

Content visible to verified customers only.

so, the mysqldump cmd is:
mysqldump --opt -h localhost -uuserX -ppassX dbnameXphotos > photos.sql

this create the error:
mysqldump: Got error: 1049: Unknown database 'dbnameXphotos' when selecting the database

About the check of filesize 0 byte: i´ve seen there is a check of filesize bigger 0byte, but this do not work, because each (from mysqldump) created sqlfile is always bigger than 0 bytes, because of the fileheader)

Code:

Content visible to verified customers only.

please, think about, you can't check on this way.

sorry for my english.

thanks + greetings from Germany
Tom

Chuck S · August 8th, 2006, 06:49 AM

The dump command we use works if you test it with ssh. You need to place the proper database name in there. This does not work on all servers hense it says check the files to ensure things where backed up. I see this issue with alot of mysql 4.0 databases

jmar · August 8th, 2006, 07:16 AM

Quote:

Originally Posted by Chuck S

The dump command we use works if you test it with ssh.

Hi Chuck,
i don't know which one you use, but the dump cmd in the script adm-misc.php from Photopost Ver. 5.31 doesn't work, it won't work with any mysql version, because its a syntax failure.

Code:

Content visible to verified customers only.

=

Code:

Content visible to verified customers only.

I explained it in first post. For fixing it should be:

Code:

Content visible to verified customers only.

For fixing the bug in check zero byte, the mysqldump cmd should be:

Code:

Content visible to verified customers only.

man mysqldump:

t|--no-create-info
Don't write table creation info.

Tom