phpBB restoring

[Waffles]

okay so i have a forum on  site A, It uses phpBB 2.0.22       I can create a full back up thats about 15-16 megs. Now i installed phpBB forums 2.0.22 on site B. I cannot restore with the 15-16meg file because it times out during restore.  I read a few things and people are saying to install phpMyAdmin and do it that way. Well i called my host for site B and that told me that i cant install that on my site due to restrictions because of the package i purchased.   So i hung up on them and did some more searching. I found that "bigdump.php" is a good file to use to do the same thing.

Now heres what ive done so far. Both site A and B are using same version of phpBB.  I created a restore folder on Site B, edited and dropped the bigdump.php file and then dropped my backup file into the same folder. Following this i opened that php via Firefox and it loads and sees the backup file. I click start restore and it looks like its working 100%, refreshes and gives me a progress bar on hwo far along the restore it. It gets to 100% and says things are good to go. Then going to site B forums i see that NOTHING restored.  After that I make two folders backed up both Site A and B files via FTP to those folders keeping them separate.  I then take Site A's files and overwrite Site B's files and edit the config.php to the domain for Site B.  So all the files on B are exactly the same as A. I refresh the forums and still..... nothing restored. It still looks like a fresh install of phpBB.  I completely dont understand why any of these methods wont work.

Does anyone have any ideas?     To sum that up i want to back up Site A  and restore it to Site B.  The backup file it too big to restore via Admin options on the forum. I cannot install phpMyAdmin, and even coping all files to Site B doesnt update/restore anything.

Thanks for the help

Waffles

[Mongoose]

Does your host give you access to an SQL server or just some space for hosting files?

[Jakestaby]

Does your host give you access to an SQL server or just some space for hosting files?

Same thing I was going to ask.  Probably different username/password in your phpBB config files.

[Waffles]

im not sure  about the SQL server im guessing that do.

I found that when i create a database it does have phpMyAdmin. So i went into that under the database that stored phpBB2 and then i have a big list of tables on the left.. i  guess im supposed to pick one then click SQL tab, then uncheck something  load the backup file and click go.  I've clicked on a bunch of different tables and followed those steps and i still cannot get it to restore. Also MyAdmin only allows a 8-9meg backup file maximum so when i try with  a gzipped file, i see the progress bar goes up for say 5-8 minutes then it refreshes  and it still didnt work. What one do i click on to restore to? If i dont click on any tables i dont get a SQL tab to click on and so then i cant restore.  So even with phpMyAdmin on there i still cant get it to restore.. i must be doing something wrong.  The full backup uncompressed is 15 megs, and i dont have access or the know how to break up the back up files so they are smaller. I really dont understand why its soo hard just to restore  from one forums to another  that are the same versions.

[Waffles]

no luck?    How can i restore a 15.3 meg backup SQL file to a different hosted same version phpBB site?

[Labyrinthine]

Try breaking the file in to pieces or find a client that will do it for you. Most extremely large uploads are done this way.

[Waffles]

I completely understand the file it too big. I dont know how to split up the .sql file after it is made, and i dont have access to phpMyAdmin on the other forums to make incremental backup files. Do you know a way to split it after i made a full back up?  I saw some sites saying use bigdump.php. And i tried that and everything seemed to work, but then i refresh the forums on the site and nothing restored.

[Latro]

I've heard you can do it by hand.. (open in a text editor) and split the sql statements up yourself.  JUST be sure to split them at line ends.

[Waffles]

doesnt matter where?    theres so much txt in there lol

and it just knows how to restore whatever sections? Like im not 100% sure where to split it so i dont split in the middle of something even if its at the end of a line.. Ill try it anyways lol  worth a shot

So i split it up  it worked out to be 6 meg 9 meg and .2 meg lol  but even with the 6 meg file, when i try to use that to restore i get "error 500" lol i dont get it.. Why isnt this simple

[Latro]

I think for phpmyadmin uploads it has to be smaller than 2mb each.

[Waffles]

phpMyAdmin said (Max: 8,192KB)

I split up the file at the beginning and end of like sections of table.. but this one middle section doesnt end  so the middle part ends up being 9 megs anyways..  frickin annoying

[BigSea_Turtle]

Hey i had the same problem a couple months ago, and after hours of searching i found the solution: (look at "Restore Database")

http://www.phpbb.com/kb/article/how-to-move-a-phpbb-20x-board-to-a-new-server/?sid=1758e76bc96b814632c4970995e17709

It's like a script that allows u to upload the backup, doesn't matter the size.. even if is 2000gb

[Latro]

Welcome BigSea_Turtle  and thanks for the tip it looks like we've been running out of ideas for Waffles.

I think he tried bigdump and couldn't get it working... 

Waffles, when you tried it, did you follow the same steps outlined in the link above?