Help! i can't insert a large text file into my MYSQL database using sqlbuddy.

374 views
Skip to first unread message

Sly

unread,
Mar 25, 2013, 9:54:45 PM3/25/13
to sql-...@googlegroups.com
I am kinda new to PHP, and SQL, as such i believe i might be doing something wrong. I have created my website and i have designed my database (MYSQL). I haven't had any problem with SQLbuddy until today when i tried to insert a TEXT datatype into a row in my MYSQL database.
*I am using wamp server version 2.2, mysql version 5-5-24, and sqlbuddy version 1.3.3.
* I created the column using this command: "ALTER TABLE table_name     ADD COLUMN column_name TEXT NOT NULL;"   (pls note here i have used "table_name" and "column_name"  instead of the actual names i used). Now i am curious to know if there is anything wrong with my use of the "TEXT" datatype in the above statement.
*After creating this column, i now tried to enter my hand-written text using this command: "INSERT INTO table_name(column_name)   VALUES(' here i typed a text with about 5000 characters '); "

I realised that when i try to insert a small text (about 500 characters), the text is smoothly inserted into the database without any problem, but when i try to fit in a larger text it gives me this error message "There was an error receiving data from the server" Now i have no idea what this  is about. i have spent 12 hours today on this single problem....i have tried using a larger datatype such as "longtext " but i still get the same message when i try to insert a larger text in the database.

I have been using sqlbuddy since i started my study and i have come to like it, that is why i am reluctant to try out some other program. Any imediate response would be greatly apreciated. Thanks for your time and excuse the poor grammar...i am just frustrated!
Reply all
Reply to author
Forward
0 new messages