dont get it

[sleepyk]

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?

[Zachery]

Chances are its just too big.

[sleepyk]

Chances are its just too big.

36mb then how can i move my whole database is only way to install? because i wanted to get everything setup 1st

[Steve Machol]

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.

[sleepyk]

what if i dont have either?

[Steve Machol]

Then you may be out of luck. How large was your database and how large is the backup file?

[sleepyk]

Then you may be out of luck. How large was your database and how large is the backup file?

saved as 36mb Threads: 2,053, Posts: 12,243, Members: 559 is my stats does 36 mb sound right?

[Steve Machol]

The backup file is 36Mb? If so, that sounds about right.

[sleepyk]

then why would it say no sql query? btw i uploaded installed then uploaded to database then i get this error on my 3.5 Fatal error: Please upgrade to vBulletin 3.5.0 or greater in /includes/init.php on line 169

[Mr_Butter]

The Fatal Error might be fixed by disabling TurkMMCache

As for the no sql query....same happened to me today. EXTREMELY annoying.

[sleepyk]

The Fatal Error might be fixed by disabling TurkMMCache

As for the no sql query....same happened to me today. EXTREMELY annoying.

how to prevent?

[Mr_Butter]

How to prevent the "no sql query"?

I dont think there is a way. As I type this I am attempting at doing it through SSH. It is either doing it effing slowly, or not doing it at all.....

[Steve Machol]

Open your backup file and post the first 10 lines here.

[sleepyk]

Open your backup file and post the first 10 lines here.

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 '', 

thats 1st 10

[Steve Machol]

Strange. That's definitely a valid query. How are you trying to restore this exactly?