vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   sql backup made easy (https://vborg.vbsupport.ru/showthread.php?t=105633)

redspider 01-18-2006 12:33 PM

sql backup made easy
 
Just wanted to share a note with others. After trying to backup sql with putty, and having NO luck using the software because of not knowing how to use the commands or server shh were not working and given me an error no socket found message. I than tried with mysql panel and the data transfered was incomplete.

I found a program or script called mysqldump from an open source and is was free.
I backed up my sql and tranfered it to the new server, it was easy and I did not need to be a guru to use it

here the link if other want to use it :
click

FleaBag 01-18-2006 12:48 PM

Taking a look at this now. My current server is unreliable and old - I have a new one ready but I cannot dump my database as it is over 200mb in size. Hoping this works!

redspider 01-18-2006 01:07 PM

for me work well and did not time out is like burning a cd with under buffer protection LOL.

maroulis 01-18-2006 01:42 PM

Quote:

Originally Posted by redspider
I backed up my sql and tranfered it to the new server, it was easy and I did not need to be a guru to use it here the link if other want to use it :
click

I think it's easier to learn how to use PHPMyAdmin to do SQL dump than read GERMAN :)

redspider 01-18-2006 01:43 PM

sorry english version click

FleaBag 01-18-2006 03:55 PM

I saw the English version... ;)

phpMyAdmin does not work, it times out also - this is why I need to try this software - else my site is stuck on a dying server forever.

Guest210212002 01-18-2006 04:05 PM

I have a howto written for pretty much this exact thing. :) Check my sig.

https://vborg.vbsupport.ru/showthread.php?p=875820

redspider 01-18-2006 05:47 PM

Quote:

Originally Posted by FleaBag
I saw the English version... ;)

phpMyAdmin does not work, it times out also - this is why I need to try this software - else my site is stuck on a dying server forever.

I was getting error with putty and I did some search then I found mysqldumber and work awsome I already transfer my sql from one server to another no lost of data .

filburt1 01-18-2006 06:10 PM

mysqldump is a built-in MySQL program. I have it make daily automatic backups of my site's database via a cron job, completely transparently.

FleaBag 01-18-2006 10:44 PM

SSH doesn't seem to allow me to restore for some reason. Hence why I've reverted to PHP scripts. I'm doing a test dump using it now... Fingers crossed eh!


All times are GMT. The time now is 04:47 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.00995 seconds
  • Memory Usage 1,729KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete