Archive | MySQL RSS feed for this section

Import BCP output file into MySQL database

19. June 2011

4 Comments

Recently, A project that I was working on required that I import a fairly large BCP file containing around 260k entries. I spent quite a while trying to work out the best way to import it directly into my MySQL database with little or no pre-processing required. The answer turned out to be quite simple, […]

Continue reading...

Optimize All MySQL Tables on a Server

30. January 2010

4 Comments

I would like to point out here quickly that I assume that you have root access in this article. One of my regular tasks is to optimize MySQL installations (primarily on shared cPanel servers). I use a number of utilities in order to identify areas in which I could optimize the MySQL installations, the main one […]

Continue reading...
View in: Mobile | Standard