vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Backup (https://vborg.vbsupport.ru/showthread.php?t=161931)

lolzers 11-04-2007 07:36 PM

Database Backup
 
I have read the guide on how to add the database backup, but my phpMyAdmin doesnt seem to have the same functions as the one in the guide does.

Could anyone type out a how to for me? Thank you in advance!

Lynne 11-04-2007 07:40 PM

It might help if you tell people what version of phpMyAdmin you are using. And also, which guide did you read that is incorrect for you? Also, do you have shell access? That's an easy way to add the backup - instructions in the vbulletin manual.

lolzers 11-04-2007 11:11 PM

I have gone into the correct database in phpMyAdmin, I have clicked SQL. There is no browse button. I am using phpMyAdmin Version: 2.11.0. The guide I used: http://www.vbulletin.com/docs/html/m...yadmin_restore - The screenshot of what my phpMyAdmin looks like when I click SQL:

http://www.tehupload.com/9349265181.png

Lynne 11-04-2007 11:35 PM

Hmmm, I go into mine and I have the Browse box on the bottom (as well as the option to Drop after the Operations button). It's almost like you don't have some privileges set to allow you to do it. Someone else will have to help with this since I really don't know what to suggest.

lolzers 11-05-2007 12:05 AM

Alright, hopefully ill get some help on this.

Brandon Sheley 11-05-2007 12:15 AM

Automatic Database Back-up

This is what I use :)

lolzers 11-05-2007 12:18 AM

I have my database backed up, I want to add the database.sql to a different database now.

Will this do it?

Marco van Herwaarden 11-05-2007 06:00 AM

If your phpMyAdmin is not the same as on the screenshots, consult your host for instructions.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

rpainter 11-05-2007 12:54 PM

I use MySQLDumper, and love it.

lolzers 11-05-2007 07:19 PM

I have some questions about MuSQLDumper -

On installation, what do I put for hostname?


All times are GMT. The time now is 01:05 AM.

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.01143 seconds
  • Memory Usage 1,726KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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