>> Site Map >> Forums >> Installation 6x
Forum module - topics in forum:
Installation 6x - Discussions regarding PHP-Nuke Installation and Configuration.
Changed Host; need help uploading database please
OK,
please don't flame me! (Not that you guys do
)As mentioned in other posts, I've migrated hosts. The complete site, based on nuke plus extras, comprised of around 300 photo albums, 3,000 registered users, 12,000 page views per day AND a website roughly 1.8Gb in size
(I DID manage to optimise the images on my PC to under 600mb though!)I've managed to upload everything via FTP APART from the database.
I followed this excellent tutorial http://phpnuke-uk.net/modules.php?name=Forums&file=viewtopic&t=3351
but I have a problem. It states in myphpadmin maximum file size is 51,200kb.
My database is 236MB (IF I read it correctly)
So I go for the gzipped option- kicks in around 21mb (go figure?)
Problem is, myphpadmin times out after 300 seconds (I'm using ADSL)
Any ideas?
I'm going to see if I can do this over a faster conection from work.....
I can't open it in notepad (was looking at the copy and paste option )
I'm *almost* there.
Is there anyway I can ftp the database onto the server (via ftp) and run some sort of script to install the database?
Cheers for your help!
Andy
You could got for a the long winded approach of opening your DB download locally using notepad or something similar, then select blocks of data from notepad copy and paste it into phpmyadmin and manually import this will take a while but ultimatly will achieve your end goal.
However none of the above information applys if your host has set a limit on the size of your new DB
I don't think there is a limit- they were advised exactly the specs etc. of the site as it stood.....
I windered if somebody had a php script that could be run to insert the data into the database from a mysql file located locally on the server.......
(Like you have to sometimes for some applications, etc.)
Cheers.
Andy
PS. Notepad will not open the database due to it's size..... think I'll have to find a different application....
Edit Pad Pro
opens all of my DB's at the moment as for a script to import maybe someone else here could assist with that mate sorry 
thanks for the tip re. editpad pro- cool piece of software!
I managed to finally get the database uploaded, and the site back online.
One thing though; my stats appear not to be recording within nuke- page views per hour/day/ etc are all at 0.
Any ideas?
