PDA

View Full Version : BigDump Error


Spybot S&D
03-29-2008, 03:37 PM
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:

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:

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 :)