AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sequel pro cancel import3/15/2023 ![]() The automatic encoding detection could also be running into problems, and so tripping up the rest. We only support transparent import for the raw text, GZIP or BZIP2 compression. It sounds like it might be choking on the file itself. It sounds like it's not even getting that far for you - is that correct? I believe the pipe character should work, and a few simple imports I've just tested have worked fine.Īt what stage do you get the "unexpected error"? What should happen after you hit the import button on the file selection dialog is that it should read and parse the file until it has a hundred rows, and then show you the field mapping/table creation dialog (which is very powerful if not immediately obvious!). That is quite a large PSV, and it's possible that alone could be causing problems - CSV import should batch queries and attempt to keep memory use low, but that's quite a lot of rows :) Thanks, the learning curve is pretty steep. Any suggestions, even of other apps to use to work with such a file? Now I'm using it, I'm not certain I can work with a. I downloaded MySQL, made sure it was running, then found and set up Sequel Pro to use as the GUI, having never used MySQL or similar. First, I need to read in the file and possibly append data, and MySQL was recommended for these tasks. ![]() Having experience with SAS programming in the past, I planned on doing some analysis in R. I received a file from a client that is bigger than anything I would typically work with in Excel (this is ~28M rows). ![]() Please provide any additional information below. What version of MySQL are you connecting to on the server? Trying to connect locally. What version of OS X are you using? 10.6.8 What version of Sequel Pro are you using? 1.0.1 When using the CSV option and selecting the pipe in "fields terminated by" drop down on the import screen and any combination of the other drop down selections, I cannot import the file due to an "unexpected error" ![]()
0 Comments
Read More
Leave a Reply. |