A request for help

[oleg-karow]

I have xampp with phpbb2 installed on my xp pro . I have a backup of my old forum wich is about 850 mbs and contains more than 8600 posts from me = my lifes work and need to mount it . I know that xampp has a limit of 132 mbs but have been told by several phpbb experts that it is possible . I was told to change the php.ini file in two places wich i did to ---->

memory_limit = 2G
post_max_size = 1G

And i have been useing bigdump.php . The process starts but only goes up to 7% = 57.73 mbs and then it stops and i get a white screen . When i look at my phpbb2 the front page of my forum is there but if i click on a section there is nothing there . I watched the whole thing in the task manager and there is a task called HTPD.EXE wich takes up 99% of the power of the computer and uses up to 529 ks of memory and a second HTPD:EXE that uses non of the CPU power but 42 kbs of memory and then bigdump crashes . I have altered the bigdump.php file exactly how the makes says and the phpbb experts say .
When i try to do it with the comand line that they gave me ---->

C:\xampp\mysql\bin\mysql.exe -u root phpbb_ < "C:\xampp\htdocs\phpbb2\dump\phpbb_db_backup.sql"

i get this ---->

ERROR 1049 <42000>: unknown database ´phpbb_`

The config.php file contains this --->

config.php

$dbhost = 'localhost';
$dbname = 'phpbb2';
$dbuser = 'root';
$dbpasswd = '';

In bigdump.php ihave ---->

$linespersession = 3000;
$delaypersession = 300;

$db_connection_charset = 'utf8';

Please can someone help me . Thank you .

[JonB]

Since your file is now local, you could likely use the mysql command line to restore the database.

http://viralpatel.net/blogs/2009/01/mys ... mmand.html

just a thought.

[oleg-karow]

Thanks for the info . I had a look at the link and i havent got a clue how to do that . Can anyone explain to me in esay steps please ?

It seems to me that the problem is with http.exe so the next questions are would it interfere with this solution to? And is there any settings i could change that would stop http.exe from stoping things again ?

[JonB]

OK -

First, a question:
Your MySQL database is on a machine that is in your location (or your want it to be) right?

The purpose of bigdump is to get backups/downloads doen through a browser. You don't need a browser to import your database (that's what that .sql file you have is is -- a series of SQL statements). Its just a big text file that is already right where it belongs -- on your machine! You can open it with a text editor (not notepad) and you will see... So this has nothing to do with bigdump.php, the Apache httpd.exe or any of that, this is a MySQL restoration.

your friends gave you the right syntax.

this page has a better explanation:

http://www.velikan.net/import-sql-dump- ... -database/

The scenario: server crashes and you got mysql dump file stored on your hard drive. First you install mySQL database - then create database, database user and database password and then use next command line:

your command line:

C:\xampp\mysql\bin\mysql.exe -u root phpbb_ < "C:\xampp\htdocs\phpbb2\dump\phpbb_db_backup.sql"

provided that phpbb_db_backup.sql file is already in htdocs\phpbb2\dump\

make sure your new database has the same name, user name and password as your old system.

As to the right order in which to reinstall your forum, I can't say, as I'm only expert with YaBB. Normally, you install the software, and then restore the backup. If that is also the case with phpBB2, then if you have installed the bulletin board, you are likely ready to restore the data.

[oleg-karow]

Thanks .