vb.org Archive - BigDump Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)

- - BigDump Error (https://vborg.vbsupport.ru/showthread.php?t=174508)

Spybot S&D

03-29-2008 03:37 PM

BigDump Error

Well, we just switched hosts. I downloaded the old database using phpMyAdmin, like i've done in the past (We've switched a few times now). I set up the BigDump script, and tried to run it. Here's what I got:

Code:

Error at the line 27: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;



Query: --

--

--

--

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

PRIMARY KEY (`userid`,`forumid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;



MySQL: Table 'access' already exists

Help Please?

WEBDosser

03-29-2008 03:53 PM

use phpMyAdmin to empty the database.. then try again.

Spybot S&D

03-29-2008 04:15 PM

Ok, I deleted the DB and the users, then added a new one. Here's my new error:

Code:

Stopped at the line 471.



At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

snakes1100

03-29-2008 04:55 PM

You should read the FAQ as it states in the message, the issue is the amount of dump lines are exceeded.

Jase2

03-29-2008 11:57 PM

Ask your host to see if they can grant you shell access. If not, then you will need to manually break down the sql file into smaller pieces, or even ask your host to increase the timeout limit on phpMyAdmin.

Regards Jason :)

All times are GMT. The time now is 03:53 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01362 seconds Memory Usage 1,711KB 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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: