Database restoring through ACP

Support for IntegraMOD 141

Moderator: Integra Moderator

Database restoring through ACP

PostAuthor: Hammer_of_War » Sun Feb 17, 2008 10:50 pm

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://bocgaming.net/forum

PHP Version:
MySQL Version:


What was done before the problem appeared?



What was done to try to solve the problem?




De.scription and Message

Okay so, these guys wanted to change hosts and they asked for me to move their stuff over. So I installed a fresh copy of 141 and attempted to do a database restore, but it keeps telling me no file was uploaded. So being the brilliant man that I am I tried going into phpmyadmin and uploading it there, but it didn't work because the file was too big. My question is there a limit to how big a database backup can be or is something else wrong? The current backup is about 11mb. Thanks for any help.
Last edited by Hammer_of_War on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Hammer_of_War
Newbie
Newbie
 
Posts: 2
Likes: 0 post
Liked in: 0 post
Joined: Sat Jan 05, 2008 8:51 pm
Cash on hand: 0.00

PostAuthor: tmotley » Mon Feb 18, 2008 2:11 pm

Others have had good success with Big Dump... find it via google search. It allows for restoring large databases.

I think mysqldumper works also...
Last edited by tmotley on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
tmotley
IntegraMODerators
IntegraMODerators
 
Posts: 524
Likes: 0 post
Liked in: 0 post
Joined: Mon Mar 27, 2006 3:56 am
Cash on hand: 0.00
Location: Missouri, USA

Re: Database restoring through ACP

PostAuthor: .QUACK.Major.Pain » Tue Feb 19, 2008 6:16 pm

All I ever did was create a new install and through phpmyadmin, I imported my backup to the database with no problems.
Last edited by .QUACK.Major.Pain on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

.QUACK.Major.Pain
Sr Integra Member
Sr Integra Member
 
Posts: 986
Likes: 0 post
Liked in: 0 post
Joined: Sat Jan 27, 2007 11:15 am
Cash on hand: 0.00

Re: Database restoring through ACP

PostAuthor: DjPorkchop » Wed Feb 20, 2008 9:37 am

I use big dump it is available here on this website and is rather easy to use.

I just moved a guys website to my server for him and the same thing happened. His DB was like 43 megs and it wouldnt dump for me in phpmyadmin, so I used big dump and in less than 3 minutes, I was up and fully operational. Nice little .script.
Last edited by DjPorkchop on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
"Don't gain the world and lose your soul, wisdom is better than silver and gold" -Bob Marley

If you build it, I can break it! ~ Whispered in the tone of the movie Field of Dreams.
User avatar
DjPorkchop
Administrator
Administrator
 
Posts: 1593
Likes: 136 posts
Liked in: 26 posts
Images: 12
Joined: Fri Apr 21, 2006 7:59 pm
Cash on hand: 1,575.25
Location: Illinois
IntegraMOD version: phpBB2x


Return to IntegraMOD 141

Who is online

Registered users: App360MonitorBot, Bing [Bot], Google [Bot]