vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database moved issue (https://vborg.vbsupport.ru/showthread.php?t=174578)

parabat 03-30-2008 11:20 AM
Database moved issue
 
I have recently moved my database to a new server. I exported it using phpadmin and then imported it again using a shell.
What I have noticed since then is that there are a few attachments missing. I rechecked my old database on the old server and noticed that for some reason the database did not export although there were not errors.
Now I have two databases of varying size.
So my question is this.. Is it at all possible to create a difference between the two databases and only import the information that is missing?

-PB

Dismounted 03-30-2008 11:44 AM
Do you have your attachments stored in the file system or the database?

parabat 03-31-2008 05:49 AM
Quote:
Originally Posted by Dismounted (Post 1478236)
Do you have your attachments stored in the file system or the database?
The database. But I will change that once I get this resolved.

-PB

SEOvB 03-31-2008 05:55 AM
You could delete all the stuff you dont want reimported on old DB, and then use the impex to reimport the stuff you left out to the new DB.

probably not a very effeicent way, but it'd work :D

Marco van Herwaarden 03-31-2008 08:16 AM
That would not work with ImpEx i guess. ImpEx needs to also import the posts that these attachments belong to. It can not attach them to the posts that are already in the new database.


All times are GMT. The time now is 07:00 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.01012 seconds
  • Memory Usage 1,712KB
  • 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
  • (5)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