this is a mypunbb issue but can someone answer my question please? (Page 1 of 2)

It'll work.
Just install punbb, edit the config manually so that it points to the correct db, load your backup, and that should be it.

used the mypunbb database back up plugin to get the data base  but it seems to be missing tables

File: /home/pilch73/public_html/include/functions.php
Line: 45

PunBB reported: Unable to fetch user information

Database reported: Table 'pilch73_pilc.users' doesn't exist (Errno: 1146)

god knows im a total amateur,can get a blank databse to work on the new server but once i try puttting that database o n it goes boobs up so to speak

not sure what to post so i could msn you it if you dont mind ,so i don't embarras myself

pilch73@hotmail.com

I just took a look at the dump
Change $db_prefix to 'hucknalltownfc_'

And you did import the tables into the database plich73_1sql, right?

You have to answer my question
The database your PunBB is using is named plich73_1sql. It can't find the tables you imported (I'm assuming you did import them ). Since I have a copy of the dump and can see the prefixes are right, that means you imported the SQL dump was not imported into the database.

Did you try uploading it through phpMyAdmin?

That's because your dump is too large to do that way

Here's what you should do:
0. (I forgot to add this before ) Install a fresh copy of PunBB
1. Upload the dump to the fresh copy's website in the plugins folder. Call it backup.sql
2. Download the DB Management plugin
3. Open the code up, find

elseif ( isset($_POST['restore_start']) ) {
    // Restore SQL Dump
    //
    // Handle the file upload ....
    // If no file was uploaded report an error...
    //
    $backup_file_name = (!empty($HTTP_POST_FILES['backup_file']['name'])) ? $HTTP_POST_FILES['backup_file']['name'] : "";
    $backup_file_tmpname = ($HTTP_POST_FILES['backup_file']['tmp_name'] != "none") ? $HTTP_POST_FILES['backup_file']['tmp_name'] : "";
    $backup_file_type = (!empty($HTTP_POST_FILES['backup_file']['type'])) ? $HTTP_POST_FILES['backup_file']['type'] : "";
    if($backup_file_tmpname == "" || $backup_file_name == "")
    {
        message('No file was uploaed or the upload failed, the database was not restored');
    }
    if( preg_match("/^(text\/[a-zA-Z]+)|(application\/(x\-)?gzip(\-compressed)?)|(application\/octet-stream)$/is", $backup_file_type) )
    {
        if( preg_match("/\.gz$/is",$backup_file_name) )
        {
            $do_gzip_compress = FALSE;
            $phpver = phpversion();
            if($phpver >= "4.0")
            {
                if(extension_loaded("zlib"))
                {
                    $do_gzip_compress = TRUE;
                }
            }
            if($do_gzip_compress)
            {
                $gz_ptr = gzopen($backup_file_tmpname, 'rb');
                $sql_query = "";
                while( !gzeof($gz_ptr) )
                {
                    $sql_query .= gzgets($gz_ptr, 100000);
                }
            }
            else
            {
                message('Sorry the database could not be restored');
            }
        }
        else
        {
            $sql_query = fread(fopen($backup_file_tmpname, 'r'), filesize($backup_file_tmpname));
        }
    }
    else
    {
        message('Error the file name or file format caused an error, the database was not restored');
    }

Replace with

elseif ( isset($_POST['restore_start']) ) {
    $sql_query = fread(fopen('backup.sql', 'r'), filesize('backup.sql'));

3. Upload the plugin, go to the plugin's page and hit the Restore button. It might take a while, but it should restore

What went wrong?

Did you upload the backup to the same folder as the plugin?

Warning: fopen(backup.sql): failed to open stream: No such file or directory in /home/pilch73/public_html/plugins/AP_DB_management.php on line 496

Warning: filesize(): Stat failed for backup.sql (errno=2 - No such file or directory) in /home/pilch73/public_html/plugins/AP_DB_management.php on line 496

Warning: fread(): supplied argument is not a valid stream resource in /home/pilch73/public_html/plugins/AP_DB_management.php on line 496