DarkxPunk Posted February 3, 2015 Share Posted February 3, 2015 Hey everyone, Please correct me if I should not be posting these sort of issues, I notice most posts are related to syntax. Anyway lets get started. I have a fairly large database (approximately 65000 rows with 10 columns), it has been provided to me in a CSV format. At first I attempted to upload this database and kept having MySQL disappear (gone), I figured later that was related to my max packet size was too low, resolved that. Now I attempted to import it again, but I am always missing about 20/30 thousand rows (not in any particular location either), one instance I actually incurred an extra 60 thousand rows (which does not make sense so it must have been duplicating data). I am at this point where I am completely lost as to why this won't upload. In the past I have uploaded CSV files with maybe 6/7 columns and 1000/2000 rows, and never had or have issues, I know it is dramatically smaller in comparison, but I don't understand why MySQL can't handle it. Thanks for any help anyone can provide. Link to comment Share on other sites More sharing options...
justsomeguy Posted February 3, 2015 Share Posted February 3, 2015 How are you importing the file? Link to comment Share on other sites More sharing options...
DarkxPunk Posted February 3, 2015 Author Share Posted February 3, 2015 How are you importing the file?Phpmyadmin import function. Link to comment Share on other sites More sharing options...
justsomeguy Posted February 3, 2015 Share Posted February 3, 2015 If you're going through the GUI then I would suggest just making sure that all of the import options that they give you are correct for that file. You might want to split it up into multiple smaller files also. Link to comment Share on other sites More sharing options...
DarkxPunk Posted February 3, 2015 Author Share Posted February 3, 2015 That is the odd thing. I have at one point tried reducing the file by leaving only 10 000 then 5000 then 1000 but it made no difference with this specific database. Is it possible there is a character or line break that could be causing the issue? I will again try skimming the file, just to be sure, but thought I would bring my past experiences. Link to comment Share on other sites More sharing options...
justsomeguy Posted February 3, 2015 Share Posted February 3, 2015 I guess it's possible, but if there was an error with the data then you should be seeing the same result every time. Link to comment Share on other sites More sharing options...
DarkxPunk Posted February 3, 2015 Author Share Posted February 3, 2015 True... Well once I am done skimming again I will update this thread. Any ideas on possible explainations in the mean time are welcome. 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