Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

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.

[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.

[Eagle Creek]

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?

[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.

[Eagle Creek]

Loud and clear!

About the closing and locking: is there an advantage to do so?

[Sjakie]

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

[Mudvayne]

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).

Any update Paul ? .

Originally Posted by Sjakie

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

[Paul M]

Originally Posted by Icy

Any update Paul ? .

No, it's very low on my list of things to do.

[patrice@patrice]

Thanks a bunch for this. :up:

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

[projectego]

[high]* projectego clicks install [/high]

[SkyCatcher]

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:

http://www.yoursite.com/forum/includes

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

http://www.yoursite.com/

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


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...

/httpsdocs
/httpdocs - This is the folder (or similar) that I mean
/cgi-bin
/test
/stats

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