The Arcive of Official vBulletin Modifications Site.

D3WEY · #1 08-03-2003, 03:55 AM

i was able to get my admin to get on and authenticate me, and since the other thread was locked by a filburwhatever

anyway, that means he can help me....so...some help?
if u dont know what im talkin about, refer to https://vborg.vbsupport.ru/showthrea...749#post422749

thanks ^-^

Dark Mystic · #2 08-03-2003, 04:00 AM

Err, yes, we are having trouble(I'm the head admin a the forum he reffered to)...it seemed as though the only way to use the back-up is for all that telnet, complicated sh*t...is there an easier way?

*cough*..oh and d3wey you can try more then once on my cell :P *cough*

Erwin · #3 08-03-2003, 04:48 AM

If your database is backed up as an sql file, you can import it using phpMyAdmin.

The alternative is restoring using SSH. Try phpMyAdmin first.

Erwin · #4 08-03-2003, 04:50 AM

If your sql file is big, phpmyadmin may timeout. The most reliable restore is using SSH. Run this as root in the command line:

mysqldump --opt -uUSERNAME -pPASSWORD DATABASENAME > /DIRECTORY/BACKUP.sql

Replace the words in capital with your details.

vB does not include a restore feature because large databases cannot be restored due to timeouts - you have to do it using SSH,

D3WEY · #5 08-03-2003, 04:59 AM

Ok, ill check with dark mystic....im really hoping he has ssh, if he doesnt have it, where can you get it?

edit: oh, and thanks SO much dood, i thought everything would be lost...

D3WEY · #6 08-03-2003, 05:38 AM

Hey, i dunno if anyone is still checking this out.....

but,

Where in phpMyAdmin do I have to insert the command?

thanksa gain

D3WEY · #7 08-03-2003, 06:22 AM

Uh, also:

Do i need an empty database for the text file upload to work?...if so, then why are we getting Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Invalid Identifer @ 1
STR: 2.2.
SQL: 2.2.8|||New 1|||New 1|||New 1|||27|||20|||||||||{calbirthdaycolor}|||

<
SQL-query : 2.2.8|||New 1|||New 1|||New 1|||27|||20|||||||||{calbirthdaycolor}||| < MySQL said: You have an error in your SQL syntax near '2.2.8|||New 1|||New 1|||New 1|||27|||20|||<body>|||<body bgcolor="#414141" backg' at line 1'

sorry for the triple post >.< but no one has answered yet o.o

assassingod · #8 08-03-2003, 07:58 AM

You dont insert the command using phpmyadmin, you just upload the .sql file.

As Erwin said, if phpmyadmin times out, use SSH

Also, there was a hack released by N9ne (Called 'Main Control Panel') where you can upload .sql files.

(Btw, its filburt1)

Logician · #9 08-03-2003, 08:25 AM

The problems you are experiencing now explains why vbulletin does not have a default restore feature. Because of MYSQL & PHP restrictions you can not *always* have a reliable restore admin interface where you can click buttons and restore your database.

The only reliable method is telnet and this has nothing to do with vbulletin, it is a technical restriction.

If you have telnet access, there is tutorial in vb.com that explains you how you can restore you database via telnet. If you don't have telnet access, you can upload the file to your server and ask your hosting company to restore it for you.

PHPmyadmin solution may or may not work in your case. It is likely to NOT work especially if your db size is large or your hosts PHP/MYSQL settings for upload files are low or timeout duration is short etc.

Neither not having a friendly restore interface in vbulletin, nor your losing your database is fault of vb developers.

D3WEY · #10 08-03-2003, 08:45 AM

Hey assasingod...we dled maincontrol, i was at it...

i cant seem to get the path for the vbulletin.sql....

what format is this in? is it from where the MasterControl is? from http://www.whatever

sorry, we must seem like idiots, we just dont know this stuff...

thanks again

Quote:

Today at 01:58 AM assassingod said this in Post #8
You dont insert the command using phpmyadmin, you just upload the .sql file.

As Erwin said, if phpmyadmin times out, use SSH

Also, there was a hack released by N9ne (Called 'Main Control Panel') where you can upload .sql files.

(Btw, its filburt1)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04795 seconds Memory Usage 2,250KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!