Contact us

For coders TYPO3 Tech Corner

Delete the first/last lines of a (SQL) file

Delete the first/last lines of a (SQL) file

There isn't much to say about the following commands. Sometimes it can be useful to delete the first (or last) X lines from a file. And if the file is too large to open with a conventional program, a command in Bash can help.

Delete faulty rows from a large SQL file:

# Delete first 20 lines
tail -n +20 dump.sql > dump.tmp && mv dump.tmp dump.sql
# Delete last 20 lines
head -n -20 dump.sql > dump.tmp && mv dump.tmp dump.sql
Alexander Kellner

Alex Kellner

Alex Kellner is not only known for his many TYPO3 extensions such as powermail, femanager or lux, but also for his community work. He is also happy to give administration or development training courses or workshops.

Alexander Kellner  |  Management & COO

Back

"Code faster, look at the time" - does this sound familiar to you?

How about time and respect for code quality? Working in a team? Automated tests?

Join us