What is causing the issue then? I have copied the data to a new file, and recieved the same issue.

I am running a .sql file against my database to build the tables. However Once i reach the Create tbl_static i recieve the following error on one of the insert statements:

MySQL said:...

Thanks to both trudge and mwasif. this helped correct the issue

Hey I am working on an offline site. However for some reason i recently started getting pop ups when i attemtp to load my site. My site is not online, and I dont have any built in pop up, they are...

I am updating a site for a company. The site was at one time working, and has since been pulled offline. All the php, js and .sql files were sent to me and I should have just been able from the...

I could see where the font can play games, it appeared as though i was only inserting 12 objects but , '', was one of the 17 inserts

Sorry, the font makes it appear that way. Those are single quotes...as in:
'1', ' ', 0.00, ' ', 'tax2'
there is a space there, it just doesnt look like it. I am running mysql 5.0
here is the full...

I am relatively new to mysql. I am running 5.0, and updating a site for someone. There was a file called echeck.sql which i was to run in order to automate a build of the database and tables. However...

ok so i got the syntax correct and it started to run the .sql but i am still getting this error:
ERROR 1265 (01000) at line 894 in file: 'c:\echeck.sql' : Data truncated for column 'taxst2' at row 1...

ok, so here is what i type:
mysql echeck < c:/Program Files/Apache Software Foundation/Apache2.2/htdocs/admin/echeck.sql -uMYSQL-ROOT -p

where "root" is a valid user in my mysql. I recieve the...

from what i read, it looks like this .sql file that i have is the dump file created from mysql dump? is this correct? If so, how do I now restore the database using this file? ie: from command line,...

I am running version 5

I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a...

Whoa...did not look closely enough apparently haha sorry. thanks

No, I am using apache on my local machine. This site is temporarily offline. The .sql files i am importing are coming from my /htdocs folder

I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a...

K...obviously we could just make the files safety the users responsibility when it is accessed outside of our system. Now that i think of it that is kind of the way it should be in the first place

I am recently out of college and two friends and I have decided started creating a system for a law firm. One of our objectives is to create a file type for this system that is encrypted until a...