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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-02-2008, 02:07 PM
fedorama fedorama is offline
 
Join Date: Jun 2008
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default ** Noob Query - Back-ups **

Hi, I'm a noob , and don't come from an IT/Programming back-ground, but more than make up for it in adaptability and logic.

I'm a layman with an analytical mind , and I'll tell ya what I understand and what exact part I don't.

I have a domain and the forums installed directly in public_html.

I want to back-up using SSH - I have an SSH client on my Mac , I have enabled access, and successfully tested accessing my server via SSH.

I read the vBulletin sheet on backing up via SSH/Telnet, and it seems like a simple one line command and PRESTO ! = This is the command -

mysqldump --opt -Q -u dbusername -p databasename > backupname.sql

And for backing up in another directory -

mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql

So there are 3 variables - the database username, database name, and backup name, plus entering the db password to authenticate.

Am I logically following this correctly at this point > OK !

Say my db username is 'iceman25' and my db name is 'iceman25_vb', then in my SSH client I would enter -

mysqldump --opt -Q -u iceman25 -p iceman25_vb > backupname.sql

Is the above correct - now my most important question and sticking point - the backup databse.

Can I enter say "iceman25_backup.sql" for the back-up destination, click enter, enter db password, and everthing starts backing up ?

Or does a folder have to be created through FTP or something.

The same thing regarding backing to a different directory - should a folder be created manually, then when I'm in the SSH client I enter the back-up name, or is a directory created by using the above command ?

Your patience and attention is greatly appreciated fellows !

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

Anyone ?

Anybody ?

Somebody ?

* deafening silence after the echo **
Reply With Quote
 


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 10:20 PM.


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.04461 seconds
  • Memory Usage 2,283KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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