Switching from Database to File System for attachments

[Kirk Y]

The only reliable method of backing up is via Secure Shell (SSH) or Telnet.

Read more here: http://www.vbulletin.com/docs/html/m...atabase_backup

This modification might also interest you: https://vborg.vbsupport.ru/showthread.php?t=126925

[Brandon Sheley]

I've been using this mod
Automatic Database Back-up

Wonder what the differences are between the two ?

[DieselMinded]

Well this didnt go good at all .....

Well I decided to Go ahead and Do the Attachments From Database to File System Thing....

Created Folder on the Server Chmoded it to 777 , Made a 10MB txt back up of the database via phpmyadmin ,

Went in to attachments , Ect...ect....

Trieds 300 per cycle and it errored out

then tried 100 Same result

then 1 and it got a VB DB error and it whiped out my database Whole site GONE

I ran to phpmyadmin to upload the back up and no go it wouldnt let me sign in , Cause of errors the members were getting something to do with max connections , The Server people told me they would upload the database back up from last night (Backed up nightly) , I said ok But they said they cant cause they cant log in either ,,, OH MY GOD !!!!!!!!!!, They told me that blah blah blah 3 DAYS !!!!!!!!

I kept trying to log in and finnaly i got in as i cant upload a 10MB file if i tried i was looking for a way to just snag the attachments table and over write it ... in the mean time the site started working again all by its self ,,,WTF ?

FYI if you ever can not log into mysql cause of massive errors you can try this........

Quote:
This is also a server/host issue. The server has maxed out the number of MySQL connections your host allows you to have. You can try turning persistent connections off in your config.php:

// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;

But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.
Can i download all the attachments from phmyadmin then upload them to my attachments folder ? How do i make VB call for the attachments from the folder insted of the database and how do i make it start saving in the attachments insted of database I need some help with this as Trial and error is not cutting it , My database back up txt file is over 10MB i cant upload 10MB what am i suppose to do if the site crases ,,, Revert to the hosts back up thats every night ? then its a waste for me to back up before updates as i couldnt upload the back up if i wanted to.


My Sites still messed up Real Slow Ect..... HELP

How do i do this !!!!!!!!!

Can I download all attachments then upload to the attachments folder then click switch to file system?

[theOZer]

Referencing Kirk Y's Post #4:
I've read the vB manual of moving attachments to the filesystem. I know how to work with SSH and/or FTP, how to create directories, but, I can't wrap my mind around "good practice to create it above public_html". Just where IS "above public_html"? Is it above the / root directory shown when I run FTP? Is it when in SSH I'm in my htdocs folder? It's the 777 folder privileges that has me very concerned about where to create an attachment directory.
Also, Has anyone incorporated using .htaccess in the attachment folder? If so, how to do you "make that work"?

[Kirk Y]

Above public_html is your root directory; when you login to your ftp you should normally see a "public_html" folder amongst several others -- depending on your server and configuration. Anything above public_html is inaccessible through the browser, so your attachments are safe from being directly executed; ie: mysite.com/attachments/image.gif.

[theOZer]

Thank you, Kirk Y, for your prompt response and help.
____________________
08/25/07 Postscript -
Moving my file attachments to the filesystem worked like a charm. vBulletin Rules!
I followed the vBulletin Manual Moving Attachments to the Filesystem instructions.
Here's how I "found" my attachment file path, which is asked for in your attachment movement install:
Log in thru SSH, then enter pwd to see your filesystem location, your path.
Here's an attachment file path example:
/kxndxn/homepages/xx/dxxxxxxx/htdocs/your_attachment_directory_name