vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Best way to restore a 300 mb database without ssh access (https://vborg.vbsupport.ru/showthread.php?t=114756)

hypnoticpimp 05-04-2006 03:26 PM
Best way to restore a 300 mb database without ssh access
 
My host doesnt allow ssh access . so we cant enter commands, to restore and uplaod the 300 mb database? are they any other option

Guest210212002 05-04-2006 11:29 PM
Your best bet is to upload your backup, call them up and have them do it. If they say they can't, tell them that you need SSH access because doing it via phpMySQLAdmin will undoubtedly time out.

If neither works, you need a new host.

Erwin 05-04-2006 11:59 PM
Use a third party program like phpmyadmin as suggested, or get a new host. SSH access is quite important for most things.

Ramsesx 05-05-2006 12:49 AM
I can recommend you Mysqldumper

tanyeri24 05-05-2006 02:56 AM
Quote:
Originally Posted by Ramsesx
I can recommend you Mysqldumper
I using this longtime, very good.

morrow 05-05-2006 03:34 AM
my db is around 65/mb and I searched high and low for the utility you're looking for. Just modify this file as needed and run from cgi-bin.

good luck.

Quote:
#!/bin/sh
#
# Edit this file and put correct string for following items
# MYSQLUSERNAME1&2 MYSQLPASSWORD1&2 mysqlXX1&2 DATABASE_NAME1&2
#
# Don't forget to set permission of 700 (not 755) to this script.
# You can do that with WebFTP, SiteTools, most FTP software, other utilities.
#

echo # Send text/plain Content-type header.
exec 2>&1 # Senf error output (stderr) to the browser

filename=${HOME:-${DOCUMENT_ROOT%/*}/cgi-bin/filename.sql} # ex.: dbbackup_2006-03-07.sql
#echo "Moving MySQL db"
# Dump DB
#/usr/local/bin/mysqldump --opt --no-create-db --user=xxx --password=xxx --host=xxx vbulletin > $filename

#echo "Data saved in $filename.
#Now importing to the destination DB"

# Restore (import)
/usr/local/bin/mysql --user=xxx --password=xxx --host=xxx xxx < $filename

echo 'Done'
Call the file whatever you want with a .cgi extension.

yj_enquirer 05-09-2006 08:00 PM
@morrow thanks for that info.. question is.. how would I run that .cgi file?

Danecookie 05-09-2006 09:09 PM
how many members/threads/posts/etc comes in your 300mb database?

Konstantinos 05-13-2006 08:03 PM
try this http://www.ozerov.de/bigdump.php it always works

vantage255 05-26-2006 10:58 PM
Right now I am doing backups by mounting a second drive array. Then I sync the 2. I unmount the drive array and if the primary ever dies, or I want to roll back, I just switch arrays.
Does your host allow you access to the raw table files..? I generaly have better luck simply backing those up and restoring them than using sql dumps.


All times are GMT. The time now is 10:34 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.01126 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
  • (2)bbcode_quote_printable
  • (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