Search Results

If you want the last line, use:

tail -n 1

How you pull the record from a specific position depends on how the record is delimited and what tools you have available (sed, awk, Perl, etc.).

set expandtab

Also, set that in your .vimrc file for more convenience.

Here is what I use:

set nu
set tabstop=4
set shiftwidth=4
set autoindent
set expandtab

I suggest you look up "PHP tutorial" on Google, find a simple example of reading values from the $_POST object, and write some code. It doesn't matter if you get it working perfectly; you can post...

It sounds like you might want to look into rsync instead.

For command-line FTP, I prefer ncftp very much. It has a recursive mget, which your vanilla ftp may not.

#!/usr/bin/env python

for line in open('temp.txt', 'r'):
seen = []
words = line.rstrip('\n').split()

for word in words:
if not word in seen:
print word,
...

If you look at the output of od -c, you'll notice that it has a backslash followed by an n, with a space between them. Then a \n with no space.

If you want to literally append a newline character...

The opposite -- +72 will give you things modified more than 72 hours ago, -72 would be less than 72 hours.

Maybe something like this:

echo "LOAD DATA LOCAL INFILE '/path/to/inbounddata/data/$(date +%Y-%m-%d)/traveldata.csv'" | mysql -u yourname -p

Try this alone first to judge the output:

$ echo...

If you want stuff from within the last hour, use -1. If you want stuff less than five hours old, use -5. If you want to control the time by minutes instead of hours, use mmin instead.

Try mmin. In any case, check the manual on your system for find to see what options you have.

Also, if you're looking for files exactly six hours old, you may not find any. You may need to do...

If you already know how to use "find" to get all the files from a date, just use the "-exec" flag and cat each file onto your big file.

The only gotcha is that you'll want to be sure (by naming...

If they have the same timestamp, then what else would you sort by?

Also, I realized that the timestamp isn't reliable anyway, because when you roll over from December to January, the December (12)...

You can create a 'LOAD DATA INFILE' query and place it in the ".sql" file (the name is irrelevant). This is what I meant earlier, but I didn't specify that because I mistakenly thought your first...

Another easy option is to save your SQL query exactly as you would type it an the MySQL prompt in a text file, then:

mysql -u yourname -p < myquery.sql

If you can specify the filename in the...

CTRL + C will kill it, just like anything else. You're welcome. A megabyte isn't too big, so that shouldn't be too much of a burden on the machine.

Does this help?

$ cat temp.txt | sort | tail
03/11/09 14:55:00 hahahaha <=== will be overwritten next
03/11/09 14:57:00 i c ded p'pl
03/11/09 14:59:00 l8terz <=== end of circular file (wrap...

Are there timestamps in the file?

Please post an excerpt containing a section where the wrap over happens.

What do you mean by "union"? Do you just want the contents of both files together in one file? If so, just use cat.

cat file1 file2 > file3

Do you want a file containing only the lines that are...

Sure you do. If you're writing a shell script, have the script rename it. Of course you can always use a programming language to do the inserts, but it's probably going to be less efficient.

No, you have to rename the file to match the table. That's just the way mysqlimport works.

The second and third lines you list are identical in function. The "m" (for match) is optional.

The =~ assigns the result of a regex subsitution to the variable. If you're doing a match, it...

They're probably the same, and you should probably use ssh due to the fact that telnet sends information in plain text.

On the command line, you can just use mysqlimport. It's the direct equivalent of the command you want to run, and takes the same arguments.

If you're familiar with sqlldr for Oracle, it works in a...

fgrep -f file1 file2

Your description is a little confusing. Do you need to alter the second word, the second line, or the second word on the second line?

In any case, you can do this very simply with a Perl one-liner...