vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Using a Vbulletin database backup from another forum for a new 3.8 (https://vborg.vbsupport.ru/showthread.php?t=224060)

Lynne 10-15-2009 07:16 PM

vbulletin uses the 'user' table, not a 'users' table.

The Ayatollah 10-15-2009 10:58 PM

Quote:

Originally Posted by Lynne (Post 1900524)
vbulletin uses the 'user' table, not a 'users' table.

Yes Ma'am. The only user appears there is the new admin

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

I opened the DB in a text editor, and it appears the User tables are not there. Looks like they weren't backed up. probably a timeout, although it sure seemed to have represented a complete back up though. I see the same thing in a couple of my other VBuletin DB backups too, and they're smaller

Lynne 10-16-2009 12:13 AM

There are several other tables listed in the database after the user table - are they there? You are trying an upgrade on this database, correct? You didn't accidentally do an install instead of an upgrade, did you (that would wipe the user table)?

The Ayatollah 10-16-2009 01:11 AM

Quote:

Originally Posted by Lynne (Post 1900659)
There are several other tables listed in the database after the user table - are they there? You are trying an upgrade on this database, correct? You didn't accidentally do an install instead of an upgrade, did you (that would wipe the user table)?

No; It clearly ends during the "insert post values".

Do you think I can still import some of it via impex or another way, or is it lost

Lynne 10-16-2009 01:23 AM

It stops after the post table (or during it)? That means you are even missing the thread table. I don't think you can do a thing with that database - you are missing all thread info and all user info.

The Ayatollah 10-16-2009 03:15 PM

Quote:

Originally Posted by Lynne (Post 1900694)
It stops after the post table (or during it)? That means you are even missing the thread table. I don't think you can do a thing with that database - you are missing all thread info and all user info.

Yeah, it's during it. As mentioned many of my backups initiated from other than the server ended up like that, and they aren't even as large. Just seems like they quit after a certain point, and usually prior to user tables. The Vbulletin back-up kind of indicated that it had completed though. Needless to say, I'm going to look into that for future use. But for now, the original plan is scrubbed. I may have another copy on my backup harddrive that's complete, but that's down the road for now. Thanks for your help Lynne

DeanLag 10-16-2009 04:01 PM

Do you still have access to the old database?
If you have SSH access, you can mysql newdatabase < backup_databse.sql

I sent you an email if you still can't figure it out and maybe I can have a look (:

The Ayatollah 10-19-2009 02:12 PM

Have discovered an interesting, but frightening thing,

It appears that my back-up drive and program are somewhat carniverous in a manner of speaking.Several files have befallen the same fate as my vbulletin backups, but I have been finding them in partiality on the back up drive. It may be that the remains I'm looking for are there, but the files have been separated. Another program, Paperport, has files missing from my hard drive, but have been located on the back up. I've got some investigating to do, but there most definately is some of the missing portions of the Vbulletin back-up on the external backup drive. Also, everyone may want to take particular note as to what their backup drive is actually backing up. I've already made some adjustments to include files I had thought already being backed up, but were not

Lynne 10-19-2009 02:45 PM

Quote:

Originally Posted by The Ayatollah (Post 1902097)
Also, everyone may want to take particular note as to what their backup drive is actually backing up. I've already made some adjustments to include files I had thought already being backed up, but were not

Very good advice. If you store attachments/avatars/profile pics/sig pics in the file system, then they are NOT backed up when you do a database backup!!!! You MUST back them up using an alternate method (I posted a cron job in the mods section that I use to backup those files for my site).

The Ayatollah 01-14-2012 04:28 PM

OK, so I have a complete database back up from the old forum now, but we have been using the new one for a couple years now. Here are a couple of questions:

The old one was .org, and the new one .info, is there a problem with this?

The old one has several users that have registered using the same name and email address.

There will be overlapping dates of use/posts since the old forum didn't quit accepting posts until a half year or more after the other one had started

Can these obstacles be overcome?

Ideally it would be best if I could have two separate parts of the forum for old and new stuff


All times are GMT. The time now is 07:50 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.01814 seconds
  • Memory Usage 1,737KB
  • 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
  • (4)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