Access violation error while importing .sql file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
softsolvers
Forum Commoner
Posts: 75
Joined: Fri Feb 13, 2004 4:26 am
Location: India

Access violation error while importing .sql file

Post by softsolvers »

Hello friends,
Each time i am importing the .sql file ,i get the alert box with message
"access violation error at address 00000..."
Why is it so,is there is problem eith the installation in mysql front or some file error is there.
Why this error occurs plz suggest me[/list]
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

i would guess it i a program error? Maybe try a reinstall.

Mark
User avatar
softsolvers
Forum Commoner
Posts: 75
Joined: Fri Feb 13, 2004 4:26 am
Location: India

Post by softsolvers »

can you seggest that what this error means,bcoz sometimes i can import the tables and some times it shows errors.
TheBentinel.com
Forum Contributor
Posts: 282
Joined: Wed Mar 10, 2004 1:52 pm
Location: Columbus, Ohio

Re: Access violation error while importing .sql file

Post by TheBentinel.com »

softsolvers wrote:Each time i am importing the .sql file ,i get the alert box with message
"access violation error at address 00000..."
Sometimes you'll get this kind of error when an application expects a regular text file and you feed it a double-byte. If you drop to a DOS prompt and type:
debug filename [where "filename" is the name of your .sql file]
d

The d command (for display) will show you the byte-for-byte listing of the first 100 bytes or so. If it looks like it's using 2 bytes for each character, that could easily be your problem.

I really don't know how to fix it, though. I think Notepad will maintain the double-byte stuff, not sure how to strip it.
Post Reply