Rather that trying ti install Apache on your PC it is far easier to install XAMPP (or similar) - all done, and configured, in a few minutes and it includes phpMyAdminClassicMan wrote:I had been following the many online tutorials to install a local web server (Apache) on my C:/ drive then to install phpMyAdmin there. As mentioned in my original post I had successfully installed 'Apache' there but just couldn't get phpMyAdmin to work even though I followed several tutorials.
robertJimA wrote: See this article for more info: Knowledge Base - Using Bigdump to restore large database dumps
Thanks! Actually, I continued reading and decided to try something else and have now been able to transfer my forums from one website to another with no problem!Lumpy Burgertushie wrote:the problem is not phpmyadmin but php itself.
the default upload filesize for php is 2MB. many hosts never get around to changing the default settings.
so, the answer to your question is go ahead and use bigdump just to be sure that is not the problem.robertJimA wrote: See this article for more info: Knowledge Base - Using Bigdump to restore large database dumps
After several unsuccessful attempts at moving the forum databases, I have FINALLY succeeded ... on my own.
For your future edification I will inform you how to do the same thing.
When finished, the destination forum will still need to have its parameters checked to make sure nothing is missing.
- In the source phpbb forum, perform a database backup by going into "ACP/Maintenance/Backup"
- Copy the resulting file from the source Forum/store folder to folder on your local system.
- Install phpbb on the destination website, create a database for the new forum, and SAVE THE CONFIG.PHP FILE! Then go into phpMyAdmin and DROP all tables.
- Using phpMyAdmin, select the destination database you just emptied and select IMPORT.
- Click on Browse next to "Location of the text file " and select the database file you just saved onto your local system.
- Click on "Go" in the lower right corner to import the database.
- Copy all forum files and folders from the source to the destination or you may lose some valuable data.
- Replace the just copied Config.php with the one you saved earlier and make sure all the database information, username, and password are correct.
Good points for a different host. Mine accepted the 4.7 MB database without an apparent hiccup. I will try to find out if anything is missing.Lumpy Burgertushie wrote:that's good. glad you got it worked out.
however, if your database is bigger than 2MB and your host has not changed the default php setting then phpmyadmin will error out because your import file will be too big.
also, there is no need to drop all the tables of your new phpbb database before you import.
the import process will drop them first before it imports the old tables.
also, using the built in backup in phpbb is not very good once your board gets a lot of posts/members. depending on the server, it may time out trying to make the backup and not give you an error message letting you know.
just a little FYI for whoever might come along.
robert