Importing database in phpMyAdmin

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
t2ffn
Registered User
Posts: 61
Joined: Tue Jun 02, 2009 7:44 pm
Location: Hull, England

Importing database in phpMyAdmin

Post by t2ffn »

I set up my forum a while back and it now pretty much runs itself, so I've been hands-off for a few months, and now am a bit rusty.

I want to make some changes so have made a backup of my files to use as a recent test board. The problem is, I cannot import the database sql file into phpMyAdmin. It has a max size of 2048KiB allocated, and my file is 2600KiB.

I have tried a few google results to edit my php config file but nothing ever changes in phpMyAdmin. The limit remains.

Could someone walk me through it as I'm struggling to do this.

I'm using phpMyAdmin 3.1.1

Thanks

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Importing database in phpMyAdmin

Post by ric323 »

Use bigdump.php as described here: Transferring Your Board to a New Host or Domain
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

Locked

Return to “[3.0.x] Support Forum”