Search found 77 matches

by Not a lot of thought
Mon May 29, 2017 6:46 pm
Forum: Databases
Topic: Lost Connection to MySQL DB Thru Livecode
Replies: 9
Views: 2959

Re: Lost Connection to MySQL DB Thru Livecode

I am using a cloud database through Amazon Web Services. I've already checked and had Amazon check their side. They don't show any connectivity issues and I can run it through MySQL Workbench just fine, I just can't get it to run through livecode.
by Not a lot of thought
Mon May 29, 2017 1:43 pm
Forum: Databases
Topic: Lost Connection to MySQL DB Thru Livecode
Replies: 9
Views: 2959

Lost Connection to MySQL DB Thru Livecode

I've been struggling with lost connections on long queries going back to a MySQL database. The database connection is fine (from the database side); internet connection is good, but for some reason Livecode only lets the DB query run for about a minute before it records revdberr,Lost connection to M...
by Not a lot of thought
Mon May 29, 2017 1:14 pm
Forum: Talking LiveCode
Topic: Filling Out Data Grid With Tab Delimited Data Problem
Replies: 2
Views: 1092

Re: Filling Out Data Grid With Tab Delimited Data Problem

....I figured it out. The lockmessages function was turned to true before the "set dgtext" line which was preventing the line from executing properly. I'm not sure if I'm saying this correctly, but after a few hours of going through each line of code that was the problem. I turned the lockmessages o...
by Not a lot of thought
Sun May 28, 2017 11:55 pm
Forum: Databases
Topic: revdberr,Lost connection to MySQL server during query
Replies: 11
Views: 4639

Re: revdberr,Lost connection to MySQL server during query

I have similar problems when I try to run queries from MYSQL through livecode using "revExecuteSQL" and "revDataFromQuery". I thought about running the a stored routine as mentioned by zaxos before, but I wasn't sure how to get the information back to livecode once it has run on the database side. I...
by Not a lot of thought
Sun May 21, 2017 4:30 am
Forum: Talking LiveCode
Topic: Filling Out Data Grid With Tab Delimited Data Problem
Replies: 2
Views: 1092

Filling Out Data Grid With Tab Delimited Data Problem

I have a data grid named "Delays_List" which I copied from a card where the data input (tab limited information from a database query) fills out the grid. Below is my code, but for some reason it will not work on this card. (I have three data grids in the stack, this is the only one on this card). T...
by Not a lot of thought
Mon Feb 06, 2017 11:09 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

What I did above didn't work. I'm not familiar with SQLite command line. I will have to research that. Right now my computer is running through a very lengthy line by line import. I'll test the idea on a different machine and see if that works.
by Not a lot of thought
Mon Feb 06, 2017 1:43 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

@SparkOut Are you referring to the doing something like this?

Code: Select all

   put ".mode csv" into tSQL
   revExecuteSQL lDatabaseID, tSQL
   put ".import "&theFilePathIni&" Test_Table" into tSQL
   revExecuteSQL lDatabaseID, tSQL
   
where the theFilePathIni is a variable containing the selected file name.
by Not a lot of thought
Sun Feb 05, 2017 6:58 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

@Sparkout You mentioned importing into SQLITE. Let me clarify, I've only had luck inserting 1 line at a time. Is there an import file function like MySQL's LOAD DATA function? If so, that would be handy. I don't have any experience with sqlite and a file that large, but could you try importing to a ...
by Not a lot of thought
Sun Feb 05, 2017 1:26 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

File was delivered as a CSV. At present I'm going through the file manually and splitting it up into manageable sections of data to import to either SQLITE or MySQL depending on if SQLITE can handle that amount of data on this machine. I would prefer a local database to a remote one as it will make ...
by Not a lot of thought
Sun Feb 05, 2017 12:36 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

Does HeidiSQL have an advantage over MySQL Workbench for importing these kinds of files? I've tried using the LOAD DATA LOCAL INFILE function to import the file a numerous occasions with no luck.
by Not a lot of thought
Sun Feb 05, 2017 4:34 am
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Re: Large External File Usage

I am using Amazon RDS for my MySQL Server. I'm not familiar with ssh access. I do not have local access to the server. It is remote. File size roughly 3.5G as perviously noted. I attempted to open the file on the windows portion of my Mac, but it was too large for excel, access, and NotePad. Only Te...
by Not a lot of thought
Sat Feb 04, 2017 12:30 pm
Forum: Databases
Topic: Large External File Usage
Replies: 17
Views: 5393

Large External File Usage

I have a large file 10,000,000+ records roughly 3.5 Gigs. It is in CSV format. I need to import it into a database for analysis, however I can't seem to work with it. The file is too large to copy and paste into excel due to record limitations (without splitting some way). I've tried importing direc...
by Not a lot of thought
Sun Dec 11, 2016 4:27 pm
Forum: Talking LiveCode
Topic: Max External File Size Limit?!?!
Replies: 4
Views: 1040

Re: Max External File Size Limit?!?!

Since I already had something set up for importing data into a SQLite db, I was hoping to avoid recreating a more sophisticated system for the storage. The initial test data is only a few Megs. Enough just to make sure the import would work. The initial dump is 3.3G. My machine is running 16G of RAM...
by Not a lot of thought
Sun Dec 11, 2016 1:51 pm
Forum: Talking LiveCode
Topic: Max External File Size Limit?!?!
Replies: 4
Views: 1040

Re: Max External File Size Limit?!?!

There is a button for selecting the file (if I recall correctly, I modeled this after demonstration on the livecode website). on mouseUp answer file "A text file" If it <> "" then put it into theFilePath put URL("file:" & theFilePath) into field "Content" else --no file was selected, or cancel was p...
by Not a lot of thought
Sun Dec 11, 2016 4:10 am
Forum: Talking LiveCode
Topic: Max External File Size Limit?!?!
Replies: 4
Views: 1040

Max External File Size Limit?!?!

I've been working on some analytics for a project I'm involved in. I've been using test data up until this point and everything has been working fine. I just received the data for the project and it's pretty large 3.3G in .csv format. I went to start an import into the SQLite database that I set up ...

Go to advanced search