vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Oh boy, need to get a backup uploaded (https://vborg.vbsupport.ru/showthread.php?t=323169)

Panzer Max 08-03-2016 04:57 PM

Oh boy, need to get a backup uploaded
 
So, we seem to have found the reason the inlinemod.php process has been occasionally hanging up, the boss says we have one moderator who according to the log, edits, moves, deletes and merges several threads a day. And now it appears one thread is corrupted, it will no longer appear when you look for it.

So, I downloaded a backup, forum.sql, from the back ups folder on the server, with FTP. This thing is nearly 6GB, so it took a while. It's also too big to open with any kind of text editor, so I cannot dig into it and copy the thread and posts that correspond to the topic....

If I could upload it into a test forum, then use phpmyadmin to export just the thread and posts, I could import them into the regular db, right?

Yes, the php has a size limit, I could try Bigdump, but the instructions say to upload big dump and the sql file to the server...that's what I don't understand. Which folder in the directory does the sql file belong?

Seven Skins 08-03-2016 05:28 PM

You can upload it to any folder ... ideally bigdump and sql file in the same folder as bigdump will see the file when you run bigdump script.

Panzer Max 08-04-2016 06:18 AM

Ok, I can try that, thanks

So, upload BD and the Mysql db to a test folder, and run BD and it will sort the single sql file into the tables structure?

RichieBoy67 08-05-2016 02:33 AM

Using ssh with Putty would be very much faster than using Bigdump if you have root access.


All times are GMT. The time now is 10:38 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.01492 seconds
  • Memory Usage 1,706KB
  • 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
  • (4)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