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.

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?

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.

Loud and clear!

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

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

Any update Paul ? :).
/server_root/backup/. Like mine is /home/username/backup/

Yep I'm using PHP 5.2.0 so far its working :)

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

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

[high]* projectego clicks install ;)[/high]

If I read ONE MORE POST about how to set the path correctly or receiving the

Error I'm going to explode!


Setting the correct path for Linux Distributions

Original Line

Quote:

$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:

Quote:

/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

Quote:

/srv/www/vhosts/mysite.com/

OR

Quote:

/srv/www/vhosts/mysite.com/httpdocs/

Depending on how your host has setup your account.


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


If you change the original line to something like

Quote:

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

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

Quote:

../../../

That means you have just gone back 3 directories.


From:

Quote:

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

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

Quote:

http://www.yoursite.com/

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


In paths, this would be going from:

Quote:

/srv/www/vhosts/mysite.com/httpdocs/forum/includes

To:

Quote:

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

Code:

---

/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:

Quote:

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

Quote:

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