[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