pp5.31 - dbbackup / bug in adm-misc.php
i have problems to backup the pp database over acp
"adm-misc.php?admact=backup. " it tells me the following incorrect and dangerous! information:
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
whats this?-------------------------------^^^^^^^^^^ dbnametablename - there is a missing blank
cmd comes from adm-misc.php #1889 under the ADM-BACKUP part
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)
sorry for my english.
thanks + greetings from Germany
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
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.
For fixing the bug in check zero byte, the mysqldump cmd should be:
Don't write table creation info.
|All times are GMT -5. The time now is 10:02 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0