View Single Post
  #1  
Old 02-24-2008, 11:40 AM
Guest210212002
Guest
 
Posts: n/a
Default Friendly reminder: backup, backup, backup.

You know you're out there, Mr. I-Just-Install-Plugins-At-Will guy. When you install something, anything, back up your db first!. It's rarely the hack's fault when your tables crash. This morning I installed one of Paul's mods, and my mysql service timed out in the middle of it. This isn't Paul's fault, or the hack - it's just bad luck.

Fortunately, an hour later and a couple of cups of coffee and my site's good to go because I am a total fanatic for backing up. If you have SSH access, it's one command. Make a shell script. Stick this in it:

Code:
# Site Backup
mysqldump --opt -Q -u username -ppassword dbname > /path/to/your/backups/db-`date --iso-8601`.sql
Run it, and it'll make a datestamped backup of your DB. Then install your product. If it's a clean install, just remove the file. The process is quick and painless, and will no doubt save you hours of frustrating table repairs, angry vb.org PM's to boofo for no reason*, and grey hairs.

So before you click that Import Product link, do yourself a favor and back your stuff up!.

*that's what I do, anyway

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

Also, don't post things in the wrong forum like I just did. You'll feel silly.

(Moved now )
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01204 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete