Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 01 Sep 2016, 20:51
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Restoring attachments

Hello,

Here is the scenario.

A client has deleted his entire file system. I have a back up of the file system but the back was made before attachments were moved from the database to the file system.

Counters were never updated and the database was never repaired so in theory those attachments should still be on that database as overhead? Right?

Is there any way to switch back from serving the attachments from the file system to the database at this point?

Yes, ouch.. deleting an entire file system is not good.

Thanks!
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #2  
Old 01 Sep 2016, 21:43
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Shouldn't the "Move attachments from database to filesystem" operation work just fine in this scenario?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 01 Sep 2016, 21:50
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
I am trying to go the other way. The site is set to serve from the file system but those files have been deleted. They are still in the database though.

I know, it is very confusing. lol

--------------- Added 01 Sep 2016 at 22:01 ---------------

Actually I think that worked. I just ran the process and it looks like the attachments were still there. Glad I did not update those tables!

--------------- Added 01 Sep 2016 at 22:29 ---------------

So I just ran into something unbelievable. My client had godaddy transfer his site to a new server and they did not move the database. I did not even know until I went into phpadmin and found that there were no databases there..

Unbelievable. I do not think Godaddy looks at the config at all...They just move the files.

--------------- Added 02 Sep 2016 at 00:55 ---------------

Looks like those attachments are gone after all..
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #4  
Old 02 Sep 2016, 10:57
muffel muffel is offline
 
Join Date: Mar 2007
I have also a question, with is similar with this...
We have a forum, where all attachments are in the database.

I want to download all attachments in our forum to a special folder on the server... where I also can then see, from which user this attachment is. Is there a workaround for this?

Thank you!
Reply With Quote
  #5  
Old 02 Sep 2016, 21:14
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
muffel, you should post a new thread about your question since what you want is totally different from the OP's post.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #6  
Old 03 Sep 2016, 07:07
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
I answered my own question anyways. I basically wanted to know if it was possible to restore data from mysql overhead and it does not look possible.

--------------- Added 03 Sep 2016 at 07:08 ---------------

Originally Posted by muffel View Post
I have also a question, with is similar with this...
We have a forum, where all attachments are in the database.

I want to download all attachments in our forum to a special folder on the server... where I also can then see, from which user this attachment is. Is there a workaround for this?

Thank you!
If you serve your attachments from the file system they should already be in a folder.

If your files are in the database then move them to a new directory in your file system.
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
Reply



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

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 14:22.

Layout Options | Width: Wide Color: