Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Reload this Page Help need for database
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 10-03-2009, 03:23 AM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help need for database
Hi,
I am moving my forum to new server and all files is shift but I don't move the database then I try to do that I have this error please help me how can move my database
PHP Code:
I am tried to pull a backup and get the following notice.

[ ! ] *************************************************************** [ ! ]
[ ! ] WARNING: Your account is TOO LARGE (Over 4gb) for cPanel backups. Please contact support. [ ! ]
[ ! ] *************************************************************** [ ! ] 
Reply With Quote
  #2  
Old 10-03-2009, 03:33 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Take a look at these pages in the manual regarding creating backups (and importing backups):

Backing Up The Database via SSH/Telnet or
Backing Up The Database via phpMyAdmin

Restoring The Database via SSH/Telnet or
Restoring The Database via phpMyAdmin

If you don't have shell access, some people have also reported success with these scripts:
MySQLDumper
MySQLHotxcopy
Bigdump
Reply With Quote
  #3  
Old 10-03-2009, 05:50 AM
WEBDosser's Avatar
WEBDosser WEBDosser is offline
 
Join Date: Oct 2001
Location: @ MyPC
Posts: 824
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i would imagine the 4gb is mostly images so before the move i would suggest you change the attachments to file storage instead of database, then your mysql should not be so large.

wD
Reply With Quote
  #4  
Old 10-03-2009, 04:05 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by WEBDosser View Post
i would imagine the 4gb is mostly images so before the move i would suggest you change the attachments to file storage instead of database, then your mysql should not be so large.

wD
Thank you friend ...I am doing to do that but have this error
PHP Code:
Parse error: syntax error, unexpected $end, expecting ',' or ';' in /home/my name/public_html/admincp/attachment.php on line 580 
Reply With Quote
  #5  
Old 10-03-2009, 05:07 PM
WEBDosser's Avatar
WEBDosser WEBDosser is offline
 
Join Date: Oct 2001
Location: @ MyPC
Posts: 824
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
make sure you have setup the attachments dir correctly and given it chmod 0777
Reply With Quote
  #6  
Old 10-03-2009, 05:22 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by WEBDosser View Post
make sure you have setup the attachments dir correctly and given it chmod 0777
Please guide me were to make that dir on server
Reply With Quote
  #7  
Old 10-03-2009, 06:50 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You can make it any place in your FTP.

/home/my name/attachments
or
/home/my name/public_html/attachments
Reply With Quote
  #8  
Old 10-03-2009, 07:05 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by snakes1100 View Post
You can make it any place in your FTP.

/home/my name/attachments
or
/home/my name/public_html/attachments
I do that all then I click on the Attachment Storage Type in Admin Cp but I can't see any option for more Information Please see the Image
Note: the SAFE_MODE for my site is already disable
Attachment 105037
Reply With Quote
  #9  
Old 10-03-2009, 07:13 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Getting a blank page says you have other issues, use THIS LINK to solve the blank page issue.
Reply With Quote
  #10  
Old 10-03-2009, 09:17 PM
ITDarasgah's Avatar
ITDarasgah ITDarasgah is offline
 
Join Date: Mar 2009
Location: Pakistan
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by snakes1100 View Post
Getting a blank page says you have other issues, use THIS LINK to solve the blank page issue.
Thank you so much....now its done.
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 01:38 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08715 seconds
  • Memory Usage 2,277KB
  • Queries Executed 12 (?)
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
  • (2)bbcode_php
  • (4)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_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