Go Back   Computer Forums > Web Design | Website Development > Web Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 08-11-2006, 01:03 PM   #1
Baseband Member
 
Join Date: Dec 2004
Posts: 90
Send a message via AIM to Nimandir
Default Importing SQL Database Backup Problem

Okay, I've been running a forum for almost a year now. It has always been slow, so I was thinking of moving some of the articles over to a new forum. While I was installing this new forum, that I was going to tinker with, I made a mistake and went to delete the database for it. Well, I deleted the wrong database and lost the database for my functional forum

I have a backup copy of the database for August 8th, but I'm having problems uploading it. I created a new database with the same name as the old one. When I clicked to import the backup, I got this message:


Quote:
Error

SQL query:

--
-- Table structure for table `phpbb_force_read_users`
--
CREATE TABLE phpbb_force_read_users(
user varchar( 255 ) NOT NULL default '',
READ int( 1 ) NOT NULL default '0',
time int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'read int(1) NOT NULL default '0',
time int(10) NOT NULL defau

The forum I'm trying to upload the backup for is an Integramod forum (integramod2.com). Also, if it helps, my host is using MySQL version 4.0.27-standard. I've already asked on the Integramod website with no results.
__________________

__________________
"We are the knights who say...NI!"
Nimandir is offline   Reply With Quote
Old 08-11-2006, 03:43 PM   #2
Baseband Member
 
Join Date: Jul 2006
Posts: 53
Default Re: Importing SQL Database Backup Problem

It might have something to do with the fact that READ is a reserved word in MySQL. I will keep working on it and see if I can figure something out...
__________________

falcon1 is offline   Reply With Quote
Old 08-12-2006, 04:55 PM   #3
Daemon Poster
 
reece296's Avatar
 
Join Date: Aug 2005
Posts: 593
Send a message via MSN to reece296 Send a message via Yahoo to reece296
Default Re: Importing SQL Database Backup Problem

Post on www.phpbb.com/phpBB the official support forum
reece296 is offline   Reply With Quote
Old 08-13-2006, 12:00 AM   #4
Baseband Member
 
Join Date: Dec 2004
Posts: 90
Send a message via AIM to Nimandir
Default Re: Importing SQL Database Backup Problem

Thanks, I got the answer on the phpbb forum.

I had to change this:

Quote:
CREATE TABLE phpbb_force_read_users(
user varchar( 255 ) NOT NULL default '',
READ int( 1 ) NOT NULL default '0',
time int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;

To this:
Quote:
CREATE TABLE phpbb_force_read_users(
`user` varchar( 255 ) NOT NULL default '',
`READ` int( 1 ) NOT NULL default '0',
`time` int( 10 ) NOT NULL default '0'
) TYPE = MYISAM ;
__________________
"We are the knights who say...NI!"
Nimandir is offline   Reply With Quote
Old 08-19-2006, 07:42 PM   #5
Golden Master
 
Join Date: Apr 2006
Posts: 7,534
Default Re: Importing SQL Database Backup Problem

Glad you found an answer to your problem.
LA061 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 12:32 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0