This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Tag: Big Data
-
Check what data Google collecting from you
You have probably heard about big data, for the service provider to get the data they need to be collected. One type of data is location data, location data can be collected if you have the location tracking on in your browser, mobile phone or other devices like a fitness band.
-
Useful mysql to remove / in a db column
Here is a handy sql statement for removing a trailing ‘/’ in the column url
-
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…
-
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: #…