vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   MySQL DB Error (https://vborg.vbsupport.ru/showthread.php?t=61600)

assassingod 02-15-2004 07:39 PM

Quote:

Originally Posted by X-Sector
I looked at my phpmyadmin.. there is no session/user tables in the database..

Awhile ago.. before my forum hacked, I just backed up my forum.. and now.. when my forum got hacked and l tried to restored it.. it has an error.

Hmm.. how do l fix the errors using by table prefix ?

Table prefixes wont help out, I was just wondering since that could cause the problem. Reupload your backup

X-Sector 02-15-2004 07:41 PM

I did reuploaded the back up a lots of times, still got the same error..

AN-net 02-15-2004 07:43 PM

hmmm.... if you have an sql file of your vb db you could manually insert the tables back in with an sql query.

X-Sector 02-15-2004 07:45 PM

Do you mean.. copy the session/user tables and run them in the phpmyadmin ?

AN-net 02-15-2004 07:50 PM

well if you had a .sql file of your db it would contain all the tables and their seperate datas in sql queries, so bascially all you do is copy and paste the sql query for your user and session tables and run them in phpmyadmin's query window;)

X-Sector 02-15-2004 07:53 PM

Thanks for the help..

How did it happened? why did there is no session/user tables ... in the database? just wondering.

AN-net 02-15-2004 08:01 PM

hmm not sure, probably since it was a backup done by cpanel while it was reuploading it skipped over it or it was never backed up in the first place or an error occured when reinserting those tables and it just continued on reuploading , not inserting those 2 tables. i would also go over to vbulletin.com and find the full list of tables your susposed to have(wana make sure your not missing any others)

X-Sector 02-15-2004 08:16 PM

Is there any other way to back up the MySQL database execpt via cpanel?

AN-net 02-15-2004 08:47 PM

yes, via admincp in vbulletin. import & maintenance->backup database
;)

X-Sector 02-15-2004 08:52 PM

Cool, thanks!


All times are GMT. The time now is 10:43 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.01013 seconds
  • Memory Usage 1,728KB
  • 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)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