Posts Tagged ‘ mysql ’

Deleting Duplicate Posts in WordPress

Mar 15th, 2011 | By

I ran into a little problem today where one of the programs I wrote to create blog posts was creating duplicates during one step of the process.  I haven’t quite figured out why it’s doing it yet however in the meantime I have used it to create and import about 25,000 blog posts and the
[continue reading…]



Importing 1000’s of posts, publishing 1000’s of drafts and mysql fun

Mar 10th, 2011 | By

Alright so for one of my side businesses I am using wordpress as a platform to create large directories for businesses to use to find other businesses.  It’s like a big ass yellow pages but for specific businesses.  Anyways part of the fun has been figuring out how to get 5000-6000 listings per city into
[continue reading…]



Backup all mysql databases to individual files

Feb 16th, 2011 | By

Thanks go out to Sonia Hamilton, as her blog is where I found the original version of this script, however it did need a fair bit of tweaking to work properly in BSD so I went ahead and redid parts of it  as you can see below. This script will back up each of your
[continue reading…]



Importing / Loading a Mysql backup / database from a .sql file – In Shell

Mar 23rd, 2009 | By

I was appalled when the first page of search results for this came up with instructions on how to do this for a Windows server.  So I felt it my duty to add to the tutorials out there for people actually running a real web server (BSD/Linux/Etc) Parse in the .sql file into an already
[continue reading…]



Wow, afternoon of hell

Nov 4th, 2008 | By

So for some odd reason my Industrybroadcast database magically corrupted itself this afternoon and what hell that was to try to fix.. Had to narrow down the problems for 3 stressful hours all the while knowing that the site was down.. Bah! Oh well at least it happens now while we are only getting 200
[continue reading…]