Tag: Database

  • How to test you WordPress site after an upgrade

    How to test you WordPress site after an upgrade

    If you got the white screen after your last upgraded, you may want to read on. I will in this article explain how I go about debugging a site to find out what could cause the issue of a white screen.

  • How to Visualize your data on your website

    How to Visualize your data on your website

    Have you ever wanted to visualize any of your data showing a bar graph, pie chart, word clouds, and other web visualization more than the text? There been an explosion in the number of available data sources and data-processing tools mean that more people than ever are jumping into the world of data visualization. But with…

  • How To Safely Rename a Database in MySql

    How To Safely Rename a Database in MySql

    So you want to Safely Rename your MySql Database, here is a tip on how to do it. If you do not have phpmyadmin installed on your server, then below are the steps to safely rename a MySql database.

  • Installing MongoDB on OS/X

    Installing MongoDB on OS/X

    Install MongoDB You can install MongoDB with Homebrew or manually. This section describes how to install with Homebrew.

  • MySql Store Procedure (Routine) to break a date range into a record per day for reporting

    Problem! Project resource assignments are tracked in an Excel Spreadsheet, the following data as outlined in the table below is tracked.

  • Excel Workbook Size Blow-out and Phantom Links

    Unfortunately, it is not too uncommon to have an Excel Workbook increase in file size for no apparent reason. Below are some methods to overcome this problem, that should be performed in the order stated! Please note OzGrid accepts no responsibility for any loss of data. This means to save a copy of your Workbook…

  • Recover root Password for MySQL

    You can recover MySQL database server password with following five easy steps.

  • How to repair a corrupt MySQL Database

    How to repair a corrupt MySQL Database

    For various reasons, database tables could get corrupted, and when it happens you should not panic. Reasons could be many, table corruption should be rare when using MySQL (though an overheating server continually restarting at the most inopportune times has meant I have seen more than my fair share of corruption recently, hence the inspiration…

  • Causes of MySQL Access Denied Errors

    If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the problem. One of the most common issues that we found is with dedicated servers, many of the providers we used do not set up an account for root,…

  • Start and Stop MySQL on Linux

    A) If you are using MySQL on  RedHat Linux (Fedora Core/CentOS)  then use the following command: * To start MySQL server: /etc/init.d/mysqld start * To stop MySQL server: /etc/init.d/mysqld stop * To restart MySQL server /etc/init.d/mysqld restart Tip: Redhat Linux also supports service command, which can be used to start, restart, stop any service: #…