DEANO.ME

mysql

 

I consider myself a seasoned PHP Web Developer, with over 10 years working in the field and with all the care and attention I’ve given Web Development over those 10 years it frustrated me recently to come across a problem that a client was having which baffled me, seriously baffled me! My client has a […]

 

In August 2014 I started an article on improving the speed and performance of your OpenCart store by improving your OpenCart database indexing, shockingly it appears OpenCart did not set required indexes that are vital for larger OpenCart stores. MySQL uses indexes to speed up queries, every join or search using an index is cached […]

 

Are you looking to simply duplicate existing rows in your MySQL table? I needed to do this recently for a database I had for a project I was developing, I wanted to duplicate the data in the database to about 10,000 rows to test response times of SQL and perform optimization on the system.

 

Apologies for the downtime, I’m officially a dumbass… Changed the MySQL database username/passwords last night and forgot to update the WordPress connection information. On another note, we did experience some downtime Monday also, this was due to a technical fault with the MySQL server itself, which was playing up all morning…

+1
Tweet
Share
Share
Stumble
Pin
Email
Shares 0