Log in Register FAQ Memberlist Search Welcome to RCF - WHF Forum Index
alt : test.swf
Welcome to RCF - WHF
4fx3.gif 
calendar_open_closeCalendar 
Unable to backup database!
Post new topic   Reply to topic View previous topic :: View next topic
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support Add To Bookmarks
Unable to backup database!
PostPosted: 07/04/2007 1:17 PM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
unitedACa.gif
Hello brother,

I hope you are fine.  dontknow
I got a problem which is that when I go to ACP these days and click Backup database and tries to download either with Gzip or without Gzip it doesn't download and after waiting for a long time it gives NETWORK ERROR issue which means timeout only.

When I go to ACP, General Admin, Configuration, Enable GZip Compression and selects the option YES and save settings so on next page and in forum index page some error comes which I think is not letting me make the backups. I keep off or on, in both ways I am unable to download database backups.

How can I download the same phpbb Forum Database from Cpanel? Any alternative  dontknow
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Unable to backup database!
PostPosted: 07/07/2007 4:26 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
peace.gif
Your entire server seems to be down.  I can't access your site through my browser nor SmartFtp and I can't access your Host CPanel either...

The easiest and probably best way to do this is through phpMyAdmin...

phpMyAdmin - Exporting a Database

In phpMyAdmin, select your current Live database in the left panel:



Click on the Export tab in the right panel:



Make sure SQL is selected and you can press Select All to make sure all tables are included:



Then in SQL Options, you would want to make sure that the following are selected.  You can also select Add Drop Table if there is a chance tha tthe tables in the destintation database already exist and you want to replace them...



Then at the bottom, make sure the Save as File and zipped or gzipped options are selected.  Zipped doesn't work correctly in my phpMyAdmin setup, so you may have to play around with the settings until you find one that works for you...



Then press the Go button at the bottom right and your Database backup should start in a few moments.  It may take a while to start if your database is large.  It is possible that neither zipped nor gzipped will work, so you may be forced to use Noen for the compression, which would make the download file much, much larger...

Next you will be given the Save As window where you can select the Destination for the Exported database backup.  Choose a destination that you can easily find and make sure there is enough space on the drive to handle the new backup file:



headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Re: Unable to backup database!
PostPosted: 07/07/2007 5:27 AM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
unitedACa.gif
Thanks a lot brother.

I just downloaded in gzip format and it's 33 MB of size! and when one day it will be more than 52 MB than how I will import through phpmyAdmin because we can import only maximum of 51-52 MB of file from there.

There must be some way yeah dontknow

And I want to ask you 1 thing more that does this backup contains members also in it? Or there is any other way to make backup of members database   dontknow
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Unable to backup database!
PostPosted: 07/07/2007 6:32 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
peace.gif
If the database backup file gets too large to import, you can break it into smaller pieces and import each piece separately.  You would need to use a good text editor to split the file since most text editors can't handle a file that large.  I use UltraEdit to split the sql files when necessary...

The database backup would include all of your data, including your phpbb_users table unless you only created a partial backup of your database...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
Re: Unable to backup database!
PostPosted: 07/07/2007 6:49 AM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
unitedACa.gif
Ahan... Okay. That's cool  Applause  Applause  Applause
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Unable to backup database!
PostPosted: 07/07/2007 8:03 AM Reply with quote
Site Admin
Nightrider
Site Admin
Posts 30757
Word Cnt. 2,628,690
BDay Jul 28
Sign Leo
Sex Sex:Male
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
peace.gif
Unless the database backup is corrupt, you should be able to restore just about anything from it, regardless of its initial size...

headbang
Back to Top
View all pictures posted by this userView user's profile Find all posts by Nightrider Send private message   AIM Address Yahoo Messenger Phoogle Map ICQ Number
 Post new topic  Reply to topic
Information
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
All times are GMT - 5 Hours

Page 1 of 1


Add To Bookmarks

 
  
  


  Google

Powered by phpBB © 2001, 2005 phpBB Group

Page generation time: 0.1264s (PHP: 41% - SQL: 59%) - SQL queries: 45 - GZIP disabled - Debug on