PDA

View Full Version : see *is angry* vbulletin trouble, i am now authenticated

D3WEY
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/showthread.php?s=&postid=422749#post422749

thanks ^-^
Dark Mystic
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
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
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
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
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
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
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
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
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



Today at 01:58 AM assassingod said this in Post #8 (https://vborg.vbsupport.ru/showthread.php?postid=422789#post422789)
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)
Dark Mystic
08-03-2003, 05:25 PM
Ok, we've solved this problem. I got one of the technicians to restore our forum with the back-up...Thanks for all the help, this can be locked now.
Erwin
08-04-2003, 06:17 AM
Closed as requested.