-
Recent Posts
Categories
Archives
Category Archives: mysql
Commands for Cron Jobs
I got totally lost the other day when I couldn’t get a cron job to work. Now, what path was that? WordPress Database Backup is a plugin that I’d relied on in the past to keep a randomly backed up … Continue reading
Format of Numerical Values Matters to Your MySQL Database
In using databases we tend to move around a lot of data. So much data, in fact, that it’s impossible to verify every single datum in a manual way. What we can and should do is verify that the beginning, … Continue reading
Posted in mysql, php
Leave a comment
How to Import a Data File into MySQL via phpMyAdmin
Sometimes we have a need to read data into an existing database. Knowing how to import a data file into an established table can save you a lot of time. First, we’ll be working with MySQL and to make things … Continue reading
Posted in mysql, php
7 Comments
MySQL LOAD FILE Statement Rescues Huge Database File
A client needed to use an existing database, which turned out to be a big gargantuan thing, but to be able work with it on the Web I needed to convert it from MS Access to MySQL. Instead of trying … Continue reading