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

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:

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
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

it should be: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)

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


sorry for my english.

thanks + greetings from Germany
Tom

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

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.

=

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

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

man mysqldump:

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


Tom