Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page how can i free attachment field in database
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 09-15-2008, 12:13 AM
booktoweb booktoweb is offline
 
Join Date: Oct 2005
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default how can i free attachment field in database
how can i free attachment field in database

when i want to move attachment from file to database
i stopped it after its finished
it working now from files
but i want to free attachment field ( its size now 199 mb )
Reply With Quote
  #2  
Old 09-15-2008, 05:40 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Where you moving from the file system to the database, or the other way around - you aren't really clear.
Reply With Quote
  #3  
Old 09-15-2008, 07:39 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I think the attachments have just been moved from the database to the file system and now they want to clear the attachments table.
Reply With Quote
  #4  
Old 09-16-2008, 09:59 AM
booktoweb booktoweb is offline
 
Join Date: Oct 2005
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i moved attachment to file system
but its table in database still big

i want to clear it from files data
Reply With Quote
  #5  
Old 09-16-2008, 12:23 PM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Look in the attachment table - is the field "filedata" (or something like that) empty for every row?
Reply With Quote
  #6  
Old 09-20-2008, 09:33 AM
booktoweb booktoweb is offline
 
Join Date: Oct 2005
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
no its not empty i many tables
Reply With Quote
  #7  
Old 09-20-2008, 02:27 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You moved the attachments from the database to the file system and all is working just fine now (right?) but you are wanting to make the attachment table smaller after the move (did you make the move in order to make the database smaller?)?

After the move, did you run Optimize on the attachment table? That will make the size smaller. (admin cp > maintenance > repair/optimize tables > select attachment > Continue)
Reply With Quote
  #8  
Old 09-20-2008, 04:10 PM
booktoweb booktoweb is offline
 
Join Date: Oct 2005
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i tried ti moving attachment to database
but after moving 3000 files its stop and database error arrived to me
so i let it in file system ( its working fine now from file system )

but attachment table after this contains many files ( that moved before error occurred )

Quote:
did you run Optimize on the attachment table? That will make the size smaller. (admin cp > maintenance > repair/optimize tables > select attachment > Continue)
i do this from admincp
and from cpanel

but its size still 199.33 mb
Reply With Quote
  #9  
Old 09-20-2008, 05:19 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It would have been helpful to see what the database error was. Does you host have a limit on how much data is allowed in the database? After you got the error, did you try again?
Reply With Quote
  #10  
Old 09-20-2008, 06:37 PM
booktoweb booktoweb is offline
 
Join Date: Oct 2005
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i have 3.5 gb of database
i don't wont to transfer it to database
i just want to clear data that merged with database

there aren't any tools to do this

after transfer attachments from database to file system
what's query happen to clear database from old data ?
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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
Forum Jump


All times are GMT. The time now is 06:41 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04121 seconds
  • Memory Usage 2,248KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete