vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   SSH databse backup (https://vborg.vbsupport.ru/showthread.php?t=56472)

lasto 08-25-2003 12:15 PM
SSH databse backup
 
anyone know of a tutourial as i aint got a clue how to do this and phpmyadmin crashes out after 1.5 megs

NTLDR 08-25-2003 12:20 PM
Backup:

Code:
mysqldump --opt -uUSERNAME -p DATABASE-NAME > /path/to/backup.sql
Restore:

Code:
mysql -uUSERNAME -p DATABASE-NAME < /path/to/restore.sql
Change USERNAME to your MySQL username, and DATABASE-NAME to the name of the DB to backup/restore allong with a valid path and filename.

filburt1 08-25-2003 12:50 PM
<a href="http://www.vbulletin.com/manual/movingservers.html" target="_blank">http://www.vbulletin.com/manual/movingservers.html</a> (basically what NTLDR said, though)

lasto 08-25-2003 12:54 PM
cheers NTLD and filburt is much appreciated as been messing on this all morning thinkin phpmyadmin was messed up

Ive now suzzed it using the hack that is in beta shame they may not work on vb3 when it is finally released though.

Thanks for help though :)

filburt1 08-25-2003 01:04 PM
FWIW, phpMyAdmin and any PHP-based method is extremely unreliable. I never did understand why Jelsoft included a link in the admin CP to make backups...and as a result I believe they added a warning to the link that is in vB3. SSH, Telnet, or via your host are the most reliable ways. :)


All times are GMT. The time now is 06: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.01749 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete