vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   BACKUP problems (https://vborg.vbsupport.ru/showthread.php?t=171205)

skipper-denmark 02-22-2008 09:33 PM

BACKUP problems
 
due the size of my DB, i can't take backup from the control panel, there is a time out

i try to do it from the phpadm controlpanel and that has a lot on choices, that I am not sure on,

the CP saids that my db Size i 204 but the file i get i 380mb
??

how can i test that the backup is OK?

please help

this is how it's looks
https://vborg.vbsupport.ru/external/2008/02/11.jpg

snakes1100 02-22-2008 09:45 PM

You should not be doing backups thru phpmyadmin.

The best way to backup your database is to use ssh.

mysqldump --opt -u -p dbname > /path/to/save/it/at/dbname.sql

skipper-denmark 02-22-2008 10:38 PM

thanks for the tip, but

sorry i am not into what ssh is, it seen that it kryptated program, but what program?

is was recommended this http://webyog.com/en/downloads.php

from host, but i can't get it to work.

is there a plugin that can be installed in vbulletin that can do it SAFE

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

i found PuTTY, but where to write what and where do i run the

mysqldump --opt -u -p dbname > /path/to/save/it/at/dbname.sql

and is the path to my computer og to the filesystem at my host?

I am realy far away from home

snakes1100 02-23-2008 11:29 AM

Putty

1. Enter your domain name or ip in the following box: "hostname or ip address"

2. click "open" at the bottom

3. You will be prompted for the user name and password to log into the server, if you dont have ssh access to the server it will fail at this point.

4. You will need the username & passwd from your config.php file or have the root username & passwd for the mysql server.

5. Enter the mysql command mysql --opt -uroot -p dbname > /path/to/save/dbname.sql and hit enter, it will prompt for your passwd for whatever usename you entered.

skipper-denmark 02-23-2008 11:47 AM

hi snakes

dead on nr 2, but have put up extern db access, have to wait 2 hours to try

regarding

Enter the
Quote:

mysql command mysql --opt -uroot -p dbname > /path/to/save/dbname.sql and hit enter, it will prompt for your passwd for whatever usename you entered.
it the program saving on the host or on my own computer.?

thanks for helping

snakes1100 02-23-2008 12:07 PM

on the server.

save it to your vhost account, where you ftp in at ie..

path to -> /home/username/


All times are GMT. The time now is 10:10 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.01975 seconds
  • Memory Usage 1,720KB
  • 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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