well i backed up db for my forum running 3.0.8 then on new database for 3.5 (myphpadmin) i tried uploading database said no SQL query what am i doing wrong?
Announcement
Collapse
No announcement yet.
dont get it
Collapse
X
-
-
It could be a bad backup. The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. 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
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.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Then you may be out of luck. How large was your database and how large is the backup file?Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
The backup file is 36Mb? If so, that sounds about right.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Open your backup file and post the first 10 lines here.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Steve MacholOpen your backup file and post the first 10 lines here.PHP Code:DROP TABLE IF EXISTS access;
CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`accessmask` smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY `userid` (`userid`,`forumid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS adminhelp;
CREATE TABLE `adminhelp` (
`adminhelpid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`action` varchar(25) NOT NULL default '',
`optionname` varchar(25) NOT NULL default '',
Comment
-
Strange. That's definitely a valid query. How are you trying to restore this exactly?Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment