1
smdcom
MySQL PHP Backup Module

anyone.. please try this module i integrate it for XOOPS 2.x

The module has Backup / Restore / Delete / Download sections for MySQL db.

MySQL PHP Backup

note: /dump directory must be 777

give ur comment here... thanks!


2
sbkiller
Re: MySQL PHP Backup Module
  • 2004/9/15 10:33

  • sbkiller

  • Just can't stay away

  • Posts: 461

  • Since: 2004/6/9 2


Let me give a try!

3
JasonMR
Re: MySQL PHP Backup Module
  • 2004/9/15 11:26

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


I am also testing your module.

Here is a PHPdebugging message (I had to shorten the actuall print out)

Quote:

Warning [PHP]: fopen(/home/jayro/public_html/jason/modules/mysqlbackup/admin/dbinfo.php): failed to open stream: Permission denied in file modules/mysqlbackup/admin/main.php line 47
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 48
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 49
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 50
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 51
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 52
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 53
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 58
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 58
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 58

Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 58
.
.
.
over hundret repetitions of this line
.
.
.
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 62
Warning [PHP]: fwrite(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 63
Warning [PHP]: fclose(): supplied argument is not a valid stream resource in file modules/mysqlbackup/admin/main.php line 64
Warning [PHP]: chmod(): No such file or directory in file modules/mysqlbackup/admin/main.php line 65
Warning [PHP]: main(dbinfo.php): failed to open stream: No such file or directory in file modules/mysqlbackup/admin/main.php line 66
Warning [PHP]: main(): Failed opening 'dbinfo.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in file modules/mysqlbackup/admin/main.php line 66
Notice [PHP]: Undefined variable: numtables in file modules/mysqlbackup/admin/main.php line 80
Notice [PHP]: Undefined variable: table0 in file modules/mysqlbackup/admin/main.php line 86


These are the issues I have encountered:
- all tables where marked to be backedup, only first table actually gets backed up
- when I try to download backup, using the interface provided, I get a 403 (no permission) error, although directory and file are set to 777
- when completing a task on admin/main.php, it takes one back to admin/index.php. It would be nice, if it would return to admin/main.php, and the user wouldn't have to reenter all database info. As this will be especially unnverving, if one where to use the benefit of your module design, which allows for table selection

MySQL debugger gives me no print out.


So much for now.

BTW: there exists already a backup module. I still have the zip file, which you can download from backup.zip (as I can't find a link to a download or information page).
The code might interest you.
Update: just in case I have also uploaded the following files (I haven't tested any of these though!):
xoops2-mod_dbtools_v1_1.zip
xoops2-mod_eskuel.zip
http:jason.jayro.net/uploads/xoops2-mod_sqldump.zip]xoops2-mod_sqldump.zip

4
JasonMR
Re: MySQL PHP Backup Module
  • 2004/9/15 11:45

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


I have been able to resolve the problem of using the admin/main.php interface for downloading the backup.

In your downloadable zip file, you have a <b><i>.htaccess</i></b> file, which needs to be deleted, as it prevents access.

Further I have noticed:
- It will only backup the first row, if all boxes are ticked
- any row below the first, will not be backed up; if i just try to backup the table given in the second row, as in ticking that box, and pressing backup, leads to a file with the following content:
Quote:

# Table backup from MySql PHP Backup
# AB Webservices 1999-2004
# www.absoft-my.com/pondok
# Integrated For XOOPS by SMD (http://www.xoopsmalaysia.org)
# Creation date: 15-Sep-2004 06:14
# Database: NAME_OF_MY_MYSQLDB

# Valid end of backup from MySql PHP Backup


I don't feel comfortable trying out your restore feature. Especially as the module hasn't been able to create a successfull backup.

Sorry, thats all the help I can offer at the moment. Hope it helps.

Login

Who's Online

232 user(s) are online (162 user(s) are browsing Support Forums)


Members: 0


Guests: 232


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits