Currently, I have this time stamp from shopify api (2018-12-16T17:36:29+11:00) that I need to store in a datetime field in mysql. 1st question: What exactly 2018-12-16T17:36:29+11:00 means? date: 2018-12-16, time: 17:36:29, timezone: +11:00????? 2nd question: If I want to store…
So I tried to make these following two tables with phpmyadmin. create table category ( catId int identity(1,1), catName varchar(20), Constraint pk_category PRIMARY KEY(catId)) create table subcategory ( subCatId INT IDENTITY(1,1), catId INT, subCatName VARCHAR(20), CONSTRAINT pk_subcategory PRIMARY KEY(catId,subCatId), CONSTRAINT…
I'm trying to spin up a container on my raspberry pi 3. The container has a MySQL server that is giving me some trouble when I try to spin up. $ docker-compose up > /dev/null & $ Building mysql ERROR:…
I have a web based applications that runs on tomcat5 mysql and using JVM and java etc... it works fine but everytime it starts getting up to around 300MB of memory for the java.exe (windows server ) it will crash…
I need to automate a couple things for my website, one of them being having the database cleared at midnight every night. I looked at cron job tutorials and came up with a script <?php $con = mysqli_connect("localhost", "root", "password",…
I've read my logfiles into R, and when I look at the referer there are some strange entries: > logs <- read.table("logfile") > referer <- data.frame(table(logs$referer)) > head(referer, 2) Var1 Freq 1 157 2 - 250290 Apache uses a dash…
I have a problem. My web site very slowly I think it's mysql. Max user connection instant 100 users. 30-40 people in most cases. My server : Intel Xeon E3-1230v3 16 GB DDR3 Ram 240 GB OCZ SSD Disk Centos…
I have a php website on localhost, and it always worked fine, but now it just shows old css files and old js files. When I edit the files and refresh the page nothing changes. especially the css layout file…
So I have a .php script where it checks the database for a date/time and if that date and time is within the next 30 min, then it will send them an email notification. $stmt = $dbh->prepare(“SELECT user_id FROM meetings…
Earlier this year I moved a lightly traffic, data centric site from shared hosting onto a CentOs CloudVM. Performance was perfectly acceptable for 7+ months - now ~10% of queries per day are taking longer than 5 seconds to complete,…