[goaliemichael]

Hey all. I have a dump from an old phpbb forum in the form of MYSQL, I believe. I have all the files and would like them installed. I would be willing to pay someone appropriately to do so, assuming it is reasonable. I have already registered for a free host on here. If anybody can help please contact me at michael.e.hall@hotmail.com

[ShocK]

Just out of interest how big is the mysql database? And what about going into phpMyAdmin in the members area and clicking "import"?

[goaliemichael]

7.69 MB sound right? I hosted it on this site. To be quite honest, I do not know what I am doidng. I used to use a free host which has since went offline. I am former NAvy, but am totally outta my league when it comes to this stuff. All I know is very basic HTML. I am willing to pay a reasonable amount for help, assuming someone can get this back up and working. It is for a video game clan. I dont want to lose our history!

[ShocK]

Small forum then, should be a doddle, I'd try here if I was you - http://www.free-installations.info/

[goaliemichael]

apparently this host requires you to ftp it. Is that all I should have to do and it will work? Sounds way too easy.......

[Bad Karma[CORE]]

Just ftp'ing it won't be enough as certain files need to be changed (configuration file for example which needs to be updated with the new MySQL values) plus the database needs to be imported.

[goaliemichael]

thanks. I will try that free site the person above sent me to first. I can't believe our forum was that small though. we had thousands of members and ALOT of posts. maybe this isnt the whole file? or maybe it is just small compared to what ya'all normally see.

[Bad Karma[CORE]]

~8MB looks alright for a board with a few thousand posts (supposing the dump file is a compressed archive like tar.gz or zip).

[Passionless]

PHPMyAdmin Import's module has a restriction of ~2MB for importing (your DB dump). It's configured that way. If you dump file is uncompressed compress it and check if then it pass the restriction.

Or you can check if that restriction applies to Premium Hosting. If it's not the case, switch to Premium and import the dump.

You also can upload your dump file with any FTP client. Then with a PHP script import it.
You must perform a query such as:

"LOAD DATA LOCAL IN FILE "dump.sql" INTO "table_name"

Assuming you dump contains only one table, which is highly improbable. But a work around to this is locally importing and exporting into separated dumps each table.

But the best solution, which only applies if you want to spend some money, is to get a Premium account and connect to the MySQL server directly. Then you could do something like this:

mysqlimport -u user -p -h mysqlxx.000webhost.com dump.sql

Good luck.

[dema]

If you pay $ 0.99 discount Webmoney