dev Posted December 4, 2006 Share Posted December 4, 2006 Hi i am totally new with mysql. I am using ms access for my forum but its getting heavier now with lot of user and topics. so now i am trying to use mysql. to do this i'v creater a .txt file through ms access option which gave me something like this "CAT_ID" "FORUM_ID" and so onNow i went to my remote webserver(win) and tried to import this .txt file then i got this following error. which reads:#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 "CAT_ID" "FORUM_ID" "TOPIC_ID" "REPLY_ID" "R_STATUS" "R_MAIL"Please help me solving this problem.With thanksdev Link to comment Share on other sites More sharing options...
jlhaslip Posted December 4, 2006 Share Posted December 4, 2006 What are you trying to do with the text file? Build tables? Import data? Link to comment Share on other sites More sharing options...
justsomeguy Posted December 4, 2006 Share Posted December 4, 2006 It sounds like you exported to a format like tab-separated and then tried to import it as SQL. Try to get access to export a SQL file instead of a tab-separated file. Link to comment Share on other sites More sharing options...
dev Posted December 4, 2006 Author Share Posted December 4, 2006 What are you trying to do with the text file? Build tables? Import data?yes i am trying to import data. my ms access have 17 tables within and each table have several numbers of sub tables. some have data and some are blank. this table has blank subtabs. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 4, 2006 Share Posted December 4, 2006 It sounds like you exported to a format like tab-separated and then tried to import it as SQL. Try to get access to export a SQL file instead of a tab-separated file. Link to comment Share on other sites More sharing options...
dev Posted December 4, 2006 Author Share Posted December 4, 2006 It sounds like you exported to a format like tab-separated and then tried to import it as SQL. Try to get access to export a SQL file instead of a tab-separated file.My sql remote server is telling me to import only txt file thats too less than 2,068kb Link to comment Share on other sites More sharing options...
justsomeguy Posted December 4, 2006 Share Posted December 4, 2006 Right. But the contents of those text files should be SQL statements, not delimited data. Are you using phpMyAdmin, or something else to administer the MySQL database? phpMyAdmin has an option for the format of the file, do you have any choices other then SQL? Link to comment Share on other sites More sharing options...
dev Posted December 4, 2006 Author Share Posted December 4, 2006 justsomeguyyes you are right, its phpmyadmin. it has sql statement. i am missing a lot of things. access was comfortable but i have to try mysql anyway. my ms access is about 2.6mb and i don't know how to proceed. please tell me step by step right from ms access --> creating sql files or compatible files for phpmyadmin. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 4, 2006 Share Posted December 4, 2006 Well, I don't use Access so I don't know the steps. But getting away from Access is the right decision. Access, although easy to work with, is a terrible database management system.This should help you:http://www.google.com/search?client=opera&...-8&oe=utf-8 Link to comment Share on other sites More sharing options...
dev Posted December 5, 2006 Author Share Posted December 5, 2006 Finally my problem is solved. i've downloaded mssccess to mysql converter and created sql dump file. this file have eveything equal to what ms access have. then i paste it in a query and its done.Now when my problem is solved it seems very easy. but i need to learn more about it. Thanks for helping me - justsomeguy and jlhaslip.Finally my problem is solved. i've downloaded mssccess to mysql converter and created sql dump file. this file have eveything equal to what ms access have. then i paste it in a query and its done.Now when my problem is solved it seems very easy. but i need to learn more about it. Thanks for helping me - justsomeguy and jlhaslip. Link to comment Share on other sites More sharing options...
justsomeguy Posted December 5, 2006 Share Posted December 5, 2006 Now when my problem is solved it seems very easy.Yeah, hindsight is 20/20. The thing to keep in mind is that pretty much all databases support the SQL language. So, if you can get one database to dump its database structure or data into a file that is a series of SQL INSERT or CREATE TABLE statements, then you can use that database dump to add the data or structure to any other database system that supports SQL. So the SQL language is pretty much the common go-between with all database systems. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now