i got a backup db but it has errors on line 1! sql experts??

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
JulieJesta
Registered User
Posts: 116
Joined: Mon Oct 16, 2006 8:39 am
Location: England
Contact:

i got a backup db but it has errors on line 1! sql experts??

Post by JulieJesta »

hi, below is a bit from my backup file that the host sent to me. it will not upload. it keeps showing error messages relating to line 1. i kinda need help. please ;-) line 1 doesnt help me. in the .sql file its a massive long line, on here its a little line? appologises if its too much code, but i dont know what relevant.

Code: Select all

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `web28-ptime` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `web28-ptime`;

--
-- Table structure for table `phpbb_auth_access`
--

DROP TABLE IF EXISTS `phpbb_auth_access`;
CREATE TABLE `phpbb_auth_access` (
  `group_id` mediumint(8) NOT NULL,
  `forum_id` smallint(5) unsigned NOT NULL,
  `auth_view` tinyint(1) NOT NULL,
  `auth_read` tinyint(1) NOT NULL,
  `auth_post` tinyint(1) NOT NULL,
  `auth_reply` tinyint(1) NOT NULL,
  `auth_edit` tinyint(1) NOT NULL,
  `auth_delete` tinyint(1) NOT NULL,
  `auth_sticky` tinyint(1) NOT NULL,
  `auth_announce` tinyint(1) NOT NULL,
  `auth_vote` tinyint(1) NOT NULL,
  `auth_pollcreate` tinyint(1) NOT NULL,
  `auth_attachments` tinyint(1) NOT NULL,
  `auth_mod` tinyint(1) NOT NULL,
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phpbb_auth_access`
--

LOCK TABLES `phpbb_auth_access` WRITE;
/*!40000 ALTER TABLE `phpbb_auth_access` DISABLE KEYS */;
INSERT INTO `phpbb_auth_access` VALUES (93,25,0,1,1,1,1,1,1,0,1,1,0,0),(33,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,9,0,0,0,0,0,0,0,0,0,0,0,1),(208,10,0,0,0,0,0,0,0,0,0,0,0,1),(208,16,0,0,0,0,0,0,0,0,0,0,0,1),(208,41,0,0,0,0,0,0,0,0,0,0,0,1),(179,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,22,0,0,0,0,0,0,0,0,0,0,0,1),(208,6,0,0,0,0,0,0,0,0,0,0,0,1),(41,25,0,1,1,1,1,1,1,0,1,1,0,0),(156,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,14,0,0,0,0,0,0,0,0,0,0,0,1),(208,25,0,0,0,0,0,0,0,0,0,0,0,1),(106,25,0,1,1,1,1,1,1,0,1,1,0,0),(174,25,0,1,1,1,1,1,1,0,1,1,0,0),(138,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,39,0,0,0,0,0,0,0,0,0,0,0,1),(208,17,0,0,0,0,0,0,0,0,0,0,0,1),(208,20,0,0,0,0,0,0,0,0,0,0,0,1),(208,28,0,0,0,0,0,0,0,0,0,0,0,1),(208,29,0,0,0,0,0,0,0,0,0,0,0,1),(208,31,0,0,0,0,0,0,0,0,0,0,0,1),(208,32,0,0,0,0,0,0,0,0,0,0,0,1),(208,33,0,0,0,0,0,0,0,0,0,0,0,1),(208,35,0,0,0,0,0,0,0,0,0,0,0,1),(56,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,40,0,0,0,0,0,0,0,0,0,0,0,1),(208,26,0,0,0,0,0,0,0,0,0,0,0,1),(208,47,0,0,0,0,0,0,0,0,0,0,0,1),(208,45,0,0,0,0,0,0,0,0,0,0,0,1),(208,46,0,0,0,0,0,0,0,0,0,0,0,1),(208,51,0,0,0,0,0,0,0,0,0,0,0,1),(208,53,0,0,0,0,0,0,0,0,0,0,0,1),(113,25,0,1,1,1,1,1,1,0,1,1,0,0),(234,25,0,1,1,1,1,1,1,0,1,1,0,0),(73,25,0,1,1,1,1,1,1,0,1,1,0,0),(60,25,0,1,1,1,1,1,1,0,1,1,0,0),(137,25,0,1,1,1,1,1,1,0,1,1,0,0),(47,25,0,1,1,1,1,1,1,0,1,1,0,0),(140,25,0,1,1,1,1,1,1,0,1,1,0,0),(74,25,0,1,1,1,1,1,1,0,1,1,0,0),(208,52,0,0,0,0,0,0,0,0,0,0,0,1),(96,25,0,1,1,1,1,1,1,0,1,1,0,0),(185,25,0,1,1,1,1,1,1,0,1,1,0,0),(540,25,0,1,1,1,1,1,1,0,1,1,0,0),(553,25,0,1,1,1,1,1,1,0,1,1,0,0);
/*!40000 ALTER TABLE `phpbb_auth_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phpbb_banlist`
--

DROP TABLE IF EXISTS `phpbb_banlist`;
CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL,
  `ban_ip` varchar(8) NOT NULL,
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) ENGINE=MyISAM AUTO_INCREMENT=160 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phpbb_ban
Julie, Mum to 1 boy, 1 boyfriend, and many fluffy pets. :)
http://www.parentstime.co.uk
dkurz
Registered User
Posts: 91
Joined: Wed Mar 17, 2004 10:03 pm
Location: NJ
Contact:

Re: i got a backup db but it has errors on line 1! sql experts??

Post by dkurz »

Do you have the entire backup? If so simply delete everything in the beginning of the .sql up till the beginning of this line:

Code: Select all

--
-- Table structure for table `phpbb_auth_access`
--
Upload the rest and it should work. If it doesn't post back here so we can see if there are other issues in the .sql file.
Locked

Return to “2.0.x Support Forum”