76

Re: [Release] Database Management Plugin

Hello

Have you any idea for backup my 'tiny' database wink

PunBB 1.2.14
Operating system: Linux
PHP: 5.1.6 - Show info
Accelerator: N/A (?? gzip works fine)
MySQL 5.0.26-log
Rows: 4186412
Size: 187.35 MB

I still can do this with MySQL-Front, but sometimes it exced time limit hmm
When I try to use this or DB Backup plugin, my server give me Internal Error hmm (about after 5 seconds)

Some datas from phpinfo()

max_execution_time 30s
max_input_time 600s
memory_limit 20M
safe_mode Off

mysql.connect_timeout 60s

YonasH's repository + Extensions Directory = PunBB Extensions Online Library (in progress....)

Away. I will be back soon.

Re: [Release] Database Management Plugin

As I said in your other post, I would suggest using mysqldump

78

Re: [Release] Database Management Plugin

yonash wrote:

Have you any idea for backup my 'tiny' database wink

solve: http://punbb.org/forums/viewtopic.php?id=14755

YonasH's repository + Extensions Directory = PunBB Extensions Online Library (in progress....)

Away. I will be back soon.

79 (edited by Vovochka 2007-02-17 21:44)

Re: [Release] Database Management Plugin

Connorhd, you have a bugs in Database management - v1.3
To fix them:

#
#---------[ 1. OPEN ]---------------------------------------------------
# 

AP_DB_management.php

#
#---------[ 2. FIND ]---------------------------------------------------
#

$return = chr($Val % 256);

#
#---------[ 3. REPLACE WITH ]-------------------------------------------------
#

$return .= chr($Val % 256);

#
#---------[ 4. FIND ]---------------------------------------------------
#

    if($do_gzip_compress)
    {
        @ob_start();

#
#---------[ 5. REPLACE WITH ]-------------------------------------------------
#

    $_SERVER['HTTP_ACCEPT_ENCODING'] = isset($_SERVER['HTTP_ACCEPT_ENCODING']) ? $_SERVER['HTTP_ACCEPT_ENCODING'] : '';
    if (!defined('PUN_DISABLE_BUFFERING') && $pun_config['o_gzip'] && extension_loaded('zlib') && (strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip') !== false || strpos($_SERVER['HTTP_ACCEPT_ENCODING'], 'deflate') !== false))
    {
        // if gzip is on in config, disable plugin gzip
        $do_gzip_compress = FALSE;
        header("Content-Type: application/x-gzip; name=\"punbb_db_backup." . gmdate("Y-m-d") . ".sql.gz\"");
        header("Content-disposition: attachment; filename=punbb_db_backup." . gmdate("Y-m-d") . ".sql.gz");
    }
    elseif($do_gzip_compress)
    {
        @ob_start();

Re: [Release] Database Management Plugin

Another usefull modification:

find:

    if(defined('PUN_DEBUG'))
    {
?>
    <div class="block">
    <h2 class="block2"><span>Restore complete</span></h2>

before, add:

    //regenrate all caches
    require_once PUN_ROOT.'include/cache.php';
    generate_config_cache();
    generate_bans_cache();
    generate_ranks_cache();
    generate_quickjump_cache();

81

Re: [Release] Database Management Plugin

Sorry but theres no instructions in the archive file, please guide me a lil, i've been searching in the portal, in the forum, in  documents and i didnt found anything..sorry if im wrong.

82

Re: [Release] Database Management Plugin

Instructions regarding how to do what?

83

Re: [Release] Database Management Plugin

like install

84

Re: [Release] Database Management Plugin

As the downloads page where this (and other useful plugins live) says:
http://punbb.informer.com/downloads.php

Administration plugins

Administration plugins are drop-in modules for the PunBB administration interface. Install them by simply decompressing the archive into the directory /plugins. Uninstall by deleting the extracted files and folders.

85

Re: [Release] Database Management Plugin

Thank you very much! smile Ill try tonight.