 | Unable to backup database! |  |
Posted: 07/04/2007 1:17 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
|

|
|
|
|
 |
Hello brother,
I hope you are fine.
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  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Unable to backup database! |  |
Posted: 07/07/2007 4:26 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
|

|
|
|
|
 |
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:
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Unable to backup database! |  |
Posted: 07/07/2007 5:27 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
|

|
|
|
|
 |
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
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  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Unable to backup database! |  |
Posted: 07/07/2007 6:32 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
|

|
|
|
|
 |
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...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Unable to backup database! |  |
Posted: 07/07/2007 6:49 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 3:59 AM
Location: UNITED ARAB EMIRATES
|

|
|
|
|
 |
Ahan... Okay. That's cool  |
|
|
 |
 |
| Back to Top |
|
|
 | Re: Unable to backup database! |  |
Posted: 07/07/2007 8:03 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 7:59 PM
Location: St Pete, FL
|

|
|
|
|
 |
Unless the database backup is corrupt, you should be able to restore just about anything from it, regardless of its initial size...
 |
|
|
 |
 |
| Back to Top |
|
|
 | Information |  |
|