Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Mysql Database Backup/restore Error, error with restoring backed up .sql file
jay2aust
post Jul 17 2005, 11:12 AM
Post #1


Newbie [Level 1]
*

Group: Members
Posts: 22
Joined: 15-July 05
Member No.: 9,453
hi there,

im just wondering if anyone can tell me what is wrong when im trying to restore my sql databsse (sorry if this is in the wrong section but i guess this is the only section that i think this will fit in)

QUOTE
SQL-query:

CREATE TABLE IF NOT EXISTS `e107_banlist` (
`banlist_ip` varchar( 100 ) NOT NULL default '',
`banlist_admin` smallint( 5 ) unsigned NOT NULL default '0',
`banlist_reason` tinytext NOT NULL ,
PRIMARY KEY ( `banlist_ip` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1


QUOTE
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 'DEFAULT CHARSET=latin1' at line 6


thanks

kenneth

(list)

Go to the top of the page
 
+Quote Post
xJedix
post Jul 17 2005, 05:51 PM
Post #2


Premium Member
********

Group: Members
Posts: 183
Joined: 27-June 05
From: Minnesota
Member No.: 8,734
Im kind of guessing from the error since I don't know that much about sql.... but if your error message is correct, the "DEFAULT CHARSET=latin1" part is incorrect.

Reasons for being incorrect. One possible reason is that the server doesn't have "latin1" charset. Another could be that the line of code is incorrect.

My suggestion would be to try taking out the "CHARSET = latin1" part and see if it works. Otherwise you could just manually create the table through mysqladmin.

Hope it helps smile.gif

(list)

Go to the top of the page
 
+Quote Post
jay2aust
post Jul 18 2005, 03:59 AM
Post #3


Newbie [Level 1]
*

Group: Members
Posts: 22
Joined: 15-July 05
Member No.: 9,453
QUOTE(xJedix @ Jul 18 2005, 01:51 AM)
Im kind of guessing from the error since I don't know that much about sql.... but if your error message is correct, the "DEFAULT CHARSET=latin1" part is incorrect.

Reasons for being incorrect.  One possible reason is that the server doesn't have "latin1" charset.  Another could be that the line of code is incorrect.

My suggestion would be to try taking out the "CHARSET = latin1" part and see if it works.  Otherwise you could just manually create the table through mysqladmin.

Hope it helps smile.gif
*



thanks for your reply.. i did take it out before but unfortunately it came up with a extreamly error after that so i thought i would post it here and maybe i should find out whats the defult char for trap17 server..

but anyway..thanks anyway... appreciate it

(list)

Go to the top of the page
 
+Quote Post
jay2aust
post Jul 19 2005, 07:32 AM
Post #4


Newbie [Level 1]
*

Group: Members
Posts: 22
Joined: 15-July 05
Member No.: 9,453
hmm..BUMP...do need someone to verify the problem if its possible..thanks

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · Hosted Members Area · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Mysql Downtimes...(39)
  2. File Upload Script In Java(5)
  3. Can You Add Images Into A Mysql Database?(21)
  4. Convert 500mb To 2 Mb With Any File Extension!(48)
  5. Simple C File Handling In Action(5)
  6. Psp Error- Tut On How To Fix(32)
  7. Make Your Own File Uploading Service.(39)
  8. Need To Shrink The File Size Of Web Image? - Photoshop Tricks(4)
  9. Mysql Won't Update(5)
  10. Error E74? (xbox 360)(12)
  11. Timer Command In Dos(5)
  12. Make A Moderately-secure Password System Using Javascript(10)
  13. Free Software For File Recovery(9)
  14. How To Create Pdf Files Using Free Tool(10)
  15. Copy A File And Rename It With Increment If Exist(6)
  1. Mysql Hacks(6)
  2. Getting Php Error On Oscommerce(3)
  3. Microsoft Infopath Sql Query(0)
  4. Php - Fetching Random Line From A Text File(0)
  5. Email Error Ends Up On Welsh Road Sign(1)
  6. How To Connect Mysql With Jsp ?(4)
  7. Beginning Php And Mysql: From Novice To Professional, Third Edition Review(1)
  8. Introducing Myself - Database Programmer Learning Web Design(4)
  9. My New Backup Solution(2)
  10. Incremental Backups(2)
  11. Somebody Uploaded A File Onto My Hosting Account [resolved](4)
  12. Free File Converter For Different Extension(4)
  13. Os X Mysql Problem(0)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 22nd November 2008 - 04:33 PM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation