vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   have problem with my database ? (https://vborg.vbsupport.ru/showthread.php?t=222457)

Lynne 09-07-2009 02:51 AM

If you don't understand how to make sure your mysql user has the correct permissions to your database, you may want to put in a support ticket at vb.com so they can check that for you.

Medtech 09-07-2009 03:11 AM

why not just drop those tables in phpmyadmin? looks to me like they serve no purpose..

chennairam 09-07-2009 04:14 AM

Quote:

Originally Posted by Medtech (Post 1880889)
why not just drop those tables in phpmyadmin? looks to me like they serve no purpose..

I backup database From phpmyadmin


After import in New server

Lot of Thread missing

Users all Okey


Can you Tell me How to Drop the tables

blind-eddie 09-07-2009 04:30 AM

If you are not comfortable working within your database, I would recommend getting assistance from someone so you don't damage your database be dropping (deleting) the wrong tables.

It is rather easy to do, but wouldn't recommend it if your somewhat new working on databases...just my opinion.

Medtech 09-07-2009 04:54 AM

post cleared by me, could have been mistaken as spam

Marco van Herwaarden 09-07-2009 06:38 AM

PHPMyAdmin is not the most reliable way to make a backup.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

blind-eddie 09-08-2009 07:47 AM

His issue has nothing to do with permissions, they are set to all permissions.

I looked at Ram's database and found the following empty tables, all empty.
He says that this happened when he moved to another server & is moving again.

Quote:

cpsession (Table is empty)

http://outerzone.us/forum/imagehosti...5ecee79342.bmp
================================================== ===============


Quote:

20 tables named aaggregate_temp (All Empty)

http://outerzone.us/forum/imagehosti...5ee4a7be6f.bmp

================================================== ===============

Quote:

44 tables named taggregate_temp (All Empty)

http://outerzone.us/forum/imagehosti...5ef38a71e1.bmp
================================================== ===============

He has lost a bunch of info from the move & can't get it back, no backups from what I am understanding. He did say he had missing attachments & threads.

What issues will he have with his site without these tables? Can they just be removed?

Marco van Herwaarden 09-08-2009 07:55 AM

Those empty tables shold not cause any problems.

chennairam 09-08-2009 08:39 AM

actually i Try to Dedicated server to Shared Hostig Temporary

But while Get backup is 250Mb from dedicated server ... later i Import in Sharedhosting that database .... every thing Okey , users ,

But mail problem is Most of thead's not open

So i think imy database had problem

Unwanted table Create automatically

So blind-eddie Trying to Help me


All times are GMT. The time now is 05:56 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.02080 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
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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