Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2010, 10:23 PM
jkcerda jkcerda is offline
 
Join Date: Mar 2008
Posts: 425
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database

how can I replace ONE database with another?

can I just mess with the config file to use the new DB?
do I need to do anything to a downloaded DB in order for this to work?

trying to get my test forum working with my back up DB.

if you used WAMP before, WHERE is the DB that gets created located?

thanks.

--------------- Added [DATE]1284854848[/DATE] at [TIME]1284854848[/TIME] ---------------

any help here?
getting this error

MySQL says:
Variable 'character_set_client' can't be set to the value of 'NULL'

Error in Query:


Quote:
/*!40101 SET character_set_client = @saved_cs_client */; -> Variable 'character_set_client' can't be set to the value of 'NULL'
using bigdump
Reply With Quote
  #2  
Old 09-19-2010, 03:33 PM
ctweb's Avatar
ctweb ctweb is offline
 
Join Date: Apr 2006
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Most probably "@saved_cs_client" variable isn't defined.

Remove that SET character_set_client line from the SQL/query and try..

As for your earlier question, it's best to create a new db, and change the config details. If you overwrite your existing database, then you wont have a backup in case something goes wrong..

If you have the option to create a new DB, go for it.. On WAMP, do you have phpmyadmin installed? It's one of the best ways to administer your databases.. There are other windows based tools too.. phpmyadmin is web based though..
Reply With Quote
  #3  
Old 09-19-2010, 04:03 PM
jkcerda jkcerda is offline
 
Join Date: Mar 2008
Posts: 425
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ctweb View Post
Most probably "@saved_cs_client" variable isn't defined.

Remove that SET character_set_client line from the SQL/query and try..

As for your earlier question, it's best to create a new db, and change the config details. If you overwrite your existing database, then you wont have a backup in case something goes wrong..

If you have the option to create a new DB, go for it.. On WAMP, do you have phpmyadmin installed? It's one of the best ways to administer your databases.. There are other windows based tools too.. phpmyadmin is web based though..
it was easier than that. I tried a few utilities, I used the same dumper to make a back up on my live DB as I did to restore my test DBon my laptop, THAT, worked, guessing the dumper was not recognizing or had trouble with the compression of the DB backups I had.

anyways, its working now, thanks for your help.
Reply With Quote
  #4  
Old 09-19-2010, 04:42 PM
ctweb's Avatar
ctweb ctweb is offline
 
Join Date: Apr 2006
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No worries.. Glad you got it working..
Reply With Quote
  #5  
Old 09-19-2010, 04:43 PM
jkcerda jkcerda is offline
 
Join Date: Mar 2008
Posts: 425
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ctweb View Post
No worries.. Glad you got it working..
pretty happy, all the noobs like myself should have a test board IMHO,
Reply With Quote
  #6  
Old 10-01-2011, 10:40 AM
ARSamo ARSamo is offline
 
Join Date: Aug 2009
Posts: 56
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am also facing the same problem......., plz suggest me what can i do.....
Reply With Quote
  #7  
Old 10-01-2011, 10:55 AM
Agathadaimon Agathadaimon is offline
 
Join Date: Mar 2010
Location: T?RKİYE
Posts: 120
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ARSamo View Post
I am also facing the same problem......., plz suggest me what can i do.....
Receive an error when loading backup?
Reply With Quote
Reply


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 09:30 AM.


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.10824 seconds
  • Memory Usage 2,219KB
  • Queries Executed 11 (?)
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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete