Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vB Database Backup Pro (Lite) for vb 3.6 Details »
vB Database Backup Pro (Lite) for vb 3.6
Mod Version: 2.12, by Paul M (Member) Paul M is offline
Developer Last Online: Jan 2018 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 3.6.x Rating: (41 votes - 4.66 average) Installs: 582
Released: 18 Sep 2006 Last Update: 10 Oct 2006 Downloads: 3334
Not Supported Auto-Template Additional Files Re-usable Code Translations  

This modification is no longer available or supported.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #196  
Old 05 Feb 2007, 10:36
[email protected] TrIn@dOr is offline
 
Join Date: Nov 2006
Hey Paul, in our site the script halt on "Database Backup" and stays there.

In the FTP, the new date dir is created, but the site is not closed and a sql file is not generated.

3.6.4
Reply With Quote
  #197  
Old 05 Feb 2007, 11:31
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Then you have a problem with your set-up.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #198  
Old 05 Feb 2007, 19:05
Reven Reven is offline
 
Join Date: Aug 2005
Real name: Sean
Originally Posted by TheFrienzNet View Post
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 172643155 bytes) in /usr/local/psa/home/vhosts/frienz-network.com/httpdocs/includes/mysqlbackup.php on line 534

Hmph.. I guess the memory exhausted?
PHP obviously ran out of memory. If you have access to php.ini then you can manually increase the allocated memory for PHP, but backups by nature will always be resource intensive.

Originally Posted by Paul M
If you don't mind I'll think about borrowing this code and adding some extra options at some point (when I'm not so busy).
Sorry for not replying sooner. Yes, of course you can use the code.
Reply With Quote
  #199  
Old 05 Feb 2007, 20:28
oglsmm's Avatar
oglsmm oglsmm is offline
 
Join Date: May 2004
You can also create/edit the .htaccess file in your forum directory. Add the line:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If your host allows this you can boost the allowed memory.
__________________
vBulletin - 3.6.1
Reply With Quote
  #200  
Old 07 Feb 2007, 15:21
kontrabass kontrabass is offline
 
Join Date: Feb 2002
I really wish I could use this mod... Is there any chance of a MysqlHotCopy version of this? Or is there already something out there that I'm not finding?

With over 3.5 million post table records and no slave DB server, using mysqldump really isn't an option (downtime would be way too long).

Mysqlhotcopy can do the backup in 3 minutes, but I wish I could find a mod like this to shut down / open the boards automatically...
Reply With Quote
  #201  
Old 07 Feb 2007, 16:05
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Sorry, I have no idea what MysqlHotCopy even is.

I have no plans to make any changes to this in the near future, and any that do get made will be minor.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #202  
Old 16 Feb 2007, 07:18
Eagle Creek's Avatar
Eagle Creek Eagle Creek is offline
 
Join Date: Jan 2004
Why should I or should't I close down the forums?
Why should I or should't I lock the tables?

Does it make multiple backups? So when there's one in place, does it make a new one?
Can it backup to a FTP?
__________________
http://www.nucia.nl/forum/
The best way to kill malware; is to kill it together.
I love vBulletin http://www.vbulletin.org/forum/images/newsm/bunny.gif
Reply With Quote
  #203  
Old 16 Feb 2007, 11:56
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
1 & 2 - Your choice - there is no should or shouldn't.

3. Backups are date based, so each day you get a new copy, run it twice on the same day and one will overwrite the other.

4. No.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #204  
Old 16 Feb 2007, 13:24
Eagle Creek's Avatar
Eagle Creek Eagle Creek is offline
 
Join Date: Jan 2004
Loud and clear!

About the closing and locking: is there an advantage to do so?
__________________
http://www.nucia.nl/forum/
The best way to kill malware; is to kill it together.
I love vBulletin http://www.vbulletin.org/forum/images/newsm/bunny.gif
Reply With Quote
  #205  
Old 16 Feb 2007, 15:50
Sjakie Sjakie is offline
 
Join Date: Oct 2006
In the setting, should I use this location: /var/www/vhosts/mysite/httpdocs/dbbackup/ or from the root /dbbackup/

And does it also work with PHP 5

Last edited by Sjakie; 16 Feb 2007 at 15:57.
Reply With Quote
  #206  
Old 16 Feb 2007, 16:32
Mudvayne's Avatar
Mudvayne Mudvayne is offline
 
Join Date: Dec 2005
Real name: Mudvayne
Originally Posted by Paul M View Post
Originally Posted by Reven View Post
I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.
If you don't mind I'll think about borrowing this code and adding some extra options at some point (when I'm not so busy).
Any update Paul ? .
Originally Posted by Sjakie View Post
In the setting, should I use this location: /var/www/vhosts/mysite/httpdocs/dbbackup/ or from the root /dbbackup/

And does it also work with PHP 5
/server_root/backup/. Like mine is /home/username/backup/

Yep I'm using PHP 5.2.0 so far its working
Reply With Quote
  #207  
Old 16 Feb 2007, 17:25
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Icy View Post
Any update Paul ? .
No, it's very low on my list of things to do.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #208  
Old 18 Feb 2007, 13:30
patrice@patrice's Avatar
[email protected] patrice@patrice is offline
 
Join Date: Jan 2006
Very Sweet!

Thanks a bunch for this.

I originally had problems because I was timing out when it hit my postindex table, so I just removed that table from the backup list and it works like a charm now.

Thanks again!
Patrice
Reply With Quote
  #209  
Old 28 Feb 2007, 10:38
projectego's Avatar
projectego projectego is offline
 
Join Date: Feb 2006
Location: UK
Real name: Steve
/me clicks install
__________________
Reply With Quote
  #210  
Old 04 Mar 2007, 16:35
SkyCatcher's Avatar
SkyCatcher SkyCatcher is offline
 
Join Date: Feb 2003
Real name: Brian
If I read ONE MORE POST about how to set the path correctly or receiving the

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)
Error I'm going to explode!


Setting the correct path for Linux Distributions

Original Line
$backup['DUMP_PATH'] = '/path/to/backups/'; // Path to backups folder, with trailing slash
On Linux servers / is the most parent path (i.e. This is the base where everything starts).

You should know the path to your forums. Most people will have a shared hosting account so you need to contact your host (or look into the original email sent to you when you purchased your hosting) to get the path.

If you are on a shared hosting the path names will differ a little but in essense they are the same.

==========================================

A typical path, for example, for suse will be:

/srv/www/vhosts/mysite.com/httpdocs/forum
That is the PATH (not web directory) to your forum.



When you log in with FTP you will probably be at


/srv/www/vhosts/mysite.com/
OR



/srv/www/vhosts/mysite.com/httpdocs/
Depending on how your host has setup your account.


==================================


If you change the original line to something like
/mybackups
It's guaranteed to fail because you don't have access to that path unless you have root access to that server (unless you own it - you don't).

==========================================


So how do I actually know where to store the backup files?

You can use . or .. to change directories without knowing the actual path.

You know 100% that the script is in /forum/includes/ (or whatever your forum directory is called).

So let's take you back to YOUR parent base directory.

==========================================

../../../
That means you have just gone back 3 directories.


From:
To (remember you have an additional folder like httpdocs, hence 3)

==========================================


In paths, this would be going from:


/srv/www/vhosts/mysite.com/httpdocs/forum/includes
To:
/srv/www/vhosts/mysite.com/httpdocs/
So now you are at the base directory where you can upload files to the web.


==========================================


So use an FTP program and navigate to your base http folder where you can see the folder to upload files to the web where others can access them (httpdocs for example)


(Before)
Something similar to this...

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

now create a new folder called mybackups and CHMOD it to 777




(After)

/httpsdocs
/httpdocs
/mybackups(
This is the folder you created)
/cgi-bin
/test
/stats

==========================================

Now edit the config file and set the path to something like this:
../../../mybackups/


The script will automatically change directories and save your files there.

==========================================

If you get the "
(Could not open Destination SQL file for writing.)" Error you need to check to make sure it's set to 777. If you still get the error you may need to change
the path to:


../../mybackups/





AND create the folder mybackups inside the httpdocs folder (same directory where /forum is) and CHMOD that to 777.




/forum
/mybackups
(This is the folder you created)
/picturs
/whatever


============================
============================



Nice Hack. Installed and working with no problems. Thanks for this


Last edited by SkyCatcher; 04 Mar 2007 at 16:47.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 00:03.

Layout Options | Width: Wide Color: