phpBB-TweakS
The easiest way to 'tweak' your phpBB!
  
Advanced Search
    
 
Home Downloads FAQ Register FAQ Memberlist Usergroups Ranks
  Log in to check your private messages Log in  
   
 

Please help us to develop!

 
It appears you are using a browser that is not based on Internet Explorer, this means you are not viewing the web as good as you should be. Other browsers might try to immitate Internet Explorer, but none can parse the web as it should like Internet Explorer can. So view the web as it was meant to be with Avant Browser!
         

phpBB-TweakS Forum Index phpBB Security Security daily backup
Display posts from previous:   
Half Thread Topic  Fully Thread Topic  Download Topic
      All times are GMT - 5 Hours  
Post new topic  Reply to topic

Sat Jan 13, 2007 6:16 pm
Author Message
Cool stand Cool
Site Supporter
Site Supporter


Joined: 22 Feb 2006
Posts: 20
Words Posted: 2,227
Average Post: 111.35
Post subject: Security daily backup Reply with quote
I have been running the security code and the daily backup for over a year now and I decided to test the backup by restoring my forum to a test data base. The restore reveals that I have not backed up the complete data base. I use bigDump to upload and import the sql backup. At completion there are 51 fields in the DB where I actually have 74 total. The 54th one being "phpbb_words".

All my backups tend to be 6112KB. Is my ISP killing my dump?

I found the line in phpbb_security.php:
system("mysqldump -u". $dbuser ." -p". $dbpasswd ." ". $dbname ." > ". (($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : $HTTP_SERVER_VARS['DOCUMENT_ROOT']) . $board_config['script_path'] . $backup_folder ."/". $backup_file ."-". date('Y-m-d') .".sql", $fp);

To my limited knowledge this should dump the whole database. I used phpMyAdmin to "Export" the database and that works with a total file size of 6323KB. The basic backup from the phpBB2 admin panel doesn't bother with any mod fields (only those with "phpbb_").

Any thoughts on why the backup is not complete? Is there any way to verify a backup with out actually restoring it to a test DB?

Cheers,
Stan

ps: I found a simple mod for the phpBB2 admin utility that does a complete backup of the DB. Backing up the database with out the mod fields isn't too helpful. After the mod, my phpBB admin, manual backup file size was 9428KB and appears to have everything. But I still don't know wht the daily backup from the security mod truncates at 6112KB.
Post #1
      Back To Top  

Mon Jan 15, 2007 12:58 pm
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
If it doesn't do a complete backup, its timing out. Typically that can be cured by raising the memory limit.
Post #2
      Back To Top  

Tue Jan 23, 2007 11:13 am
Author Message
Cool stand Cool
Site Supporter
Site Supporter


Joined: 22 Feb 2006
Posts: 20
Words Posted: 2,227
Average Post: 111.35
Post subject: Reply with quote
OK, I looked for where I raise the "memory limit" and flamed out.

Where does one raise the memory limit?

Stan D.
Post #3
      Back To Top  

Wed Jan 24, 2007 5:34 am
Author Message
aUsTiN
Webmaster
Webmaster


Usa Georgia

Joined: 05 Jan 2005
Posts: 3684
Words Posted: 144,671
Average Post: 39.27
Location: USA
Post subject: Reply with quote
If you have access to the php.ini its there. If you dont, you'll have to ask your host.
Post #4
      Back To Top  

 
         

Post new topic  Reply to topic

phpBB-TweakS Forum Index phpBB Security Security daily backup
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

      Back To Top  

Page 1 of 1
Jump to:  
 
Protected by phpBB Security © phpBB-TweakS
phpBB Security Has Blocked 3,237 Exploit Attempts.

· Archive · Sitemap: Index · Sitemap: Forums · Sitemap: Topics · Sitemap: Posts ·

:: [ Load Time: 3.1 Seconds ] :: [ 29 Queries ] :: [ 560 Page(s) Viewed Today ] ::
:: [ Todays Queries: 16,582 ] :: [ Highest Load: 1,396,429 Queries On May. 08, 2007 ] ::
:: [ SQL Load: 60% Time: 1.9 ] :: [ PHP Load: 40% Time: 1.2 ] :: [ Debug: On ] :: [ GZIP: Enabled ] ::
:: The server last rebooted 80 days, 15 hours, 56 minutes, 56 seconds ago. ::
The phpBB[Network]!
       


This page has been viewed 4,927,631 times, last viewed: Sat Sep 06, 2008 12:27 am.
Powered by phpBB 2.0.* © 2001, 2002 phpBB Group
Avalanche style by What Is Real © 2004