You didn't search in the Knowledge BaseMrGibbonz wrote:Hi,
I did a search but couldn't seem to find a solution for big database transfers specifically.
My database is approximately 1gb in size. I was wondering how I should go about uploading a large phpbb2 database like this to my new server? I'm aware the procedure changes when the database grows to a certain size due to timeout issues.
Hope someone can help and thank-you for your time.
My apologies for not looking there.ric323 wrote: You didn't search in the Knowledge Base
Code: Select all
$filename = ''; // Specify the dump filename to suppress the file selection dialog $csv_insert_table = ''; // Destination table for CSV files $ajax = true; // AJAX mode: import will be done without refreshing the website $linespersession = 3000; // Lines to be executed per one import session $delaypersession = 0; // You can specify a sleep time in milliseconds after each session
No i'm downloading it in .sql format as shown in the screenshot in the guide.Lumpy Burgertushie wrote:are you gzipping the database when you export it?
I'll try what you suggested now but which sessions tables should I leave out as I have four of them? I'm not sure what search tables you mean either as i have three of those. Heres all the tables in the database...Lumpy Burgertushie wrote: You will have to recreate those tables later and to get the data back;
You can rebuild the search tables later and the sessions tables will just start over and everyone will just have to log in the next time they visit.
you could have left the shoutbox one, but it will be fine.MrGibbonz wrote:I've left the following tables out of the export and am downloading now...
Hope these are the correct ones?