Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.

1
vote
0answers
15 views

What tools could I possibly use to make an Android app real-time while using MySQL as database?

I have already developed a website mainly using Laravel and MySQL for back-end. I have built an API using Lumen micro-framework, that is used for the communication between the Laravel app and the ...
-2
votes
0answers
5 views

sequel pro storage

Shame on me, I've never done a backup of my Macbook. It is now gone but I succeed in recovering the entire user folders. I was wondering whether and where I could find my Sequel Pro databases. Could ...
0
votes
1answer
8 views

Nodejs ORM for MYSQL

The purpose to find recommendation for a node-js package to interact with mysql db which can achieve following objectives It should be highly documented Resolve maximum of MYSQL query handling in ...
0
votes
0answers
5 views

Mysql uses heavy memory [closed]

My MySQL uses 2gb resident memory of the server. it's having around 10 databases but only 2 databases are accessible by websites. Here my question is MySQL uses heavy memory when non-accessible ...
-1
votes
0answers
4 views

When I am creating the table in phpMyAdmin or i am adding the record, how do i move on the fields using the keyboard? [closed]

If I use tab - it will move me to the next input space which is right. But i would like to go down or up to input all the names first. Thank you in advance.
-1
votes
0answers
20 views

Looking for a plugin that could provide auto backup the database in PHPmyadmin weekly or monthly

I am looking for the best plugin and method that could provide schedule backup the large-scale database in PHPmyadmin. It will follow the time we set to auto backup the database such as weekly, and ...
0
votes
1answer
34 views

Choosing the right database management system?

I am writing a Telegram bot script which needs to store inputted user data. I have no real experience using database management systems such as SQLite, MySQl and Postgres. I don't need my application ...
0
votes
0answers
5 views

Package for user management in Node express and MySQL

Could you please recommend a Node package that provides the following features: - user sign-in and sign-up - password change, password forgotten - user email change - email notifications to validate ...
0
votes
0answers
7 views

MySQL microservice

Im wondering if theres any public microservice that offers a simple api to write and read data to a db. For instance a mysql db. So i can send lests say a json to this api using only js and that ...
0
votes
0answers
2 views

What is the best stack for a gene to disease database

I am the founder of a Genomics Diagnostic company and I am interested in understanding if anybody have built databases using Grakn and what their experience is. Kind Regards Gitte Pedersen CEO and ...
-1
votes
0answers
9 views

compatibility with httpd24-httpd Nagvis

I have problems when starting Nagvis, since it is ready for Apache (httpd), but not with httpd24-http. Could you help me? I job in CentOS Regards, and thank you very much
0
votes
0answers
9 views

Get the response time of a couple of websites using php, azure and mysql on a linux machine

I want to get the response time of a couple of websites, without overloading the server in which I keep my database. The dns of the websites are located on a mysql database within a linux machine (...
-1
votes
0answers
7 views

OpenSource Tools For Database Replication?

I want to ask maybe someone knows, is there an open source tool for 2-way database replication like symetricds, because I have the task of making the database replication engine use tools other than ...
-1
votes
0answers
8 views

Mysql Router as part of docker container

From Mysql Router in docker hub there is a statement: MySQL Router is part of InnoDB cluster, and is lightweight middleware that provides transparent routing between your application and back-end ...
0
votes
0answers
5 views

Need a simple UI for a mySQL database that can do simple queries and views

TLDR: Using mySQL Running database locally on computer Windows only Not looking to pay money Looking for simple language/framework to create UI to manipulate and view tables I have a simple mySQL ...
-1
votes
0answers
6 views

no data in the result grid in mysql workbench 6.3

when I open in the schemas panel "sakila" database, the table city, I see data in the table.But, when I open a table of a[https://i.stack.imgur.com/yHmI7.jpg][1]][1] database which I created, I see ...
-2
votes
0answers
7 views

Free Webhosting - But with certain specifications

I used to self-host my website on one of my servers. However, my website is using too much memory and CPU power with renders my website to sometimes issue an internal server error, rendering the ...
-1
votes
0answers
3 views

Several MySQL (5 and 8) on same Windows 10

Some admins of Mysql here? Is it possible to install severyl versions of Mysql (5 and 8) on same machine (Windows10)? I need the older version for compatibility reasons. Thanks
-2
votes
0answers
12 views

Best DBMS\approach for 1Tb data

What we have We have ~1Tb raw data of clients, their emails, categories and cities. About 30bln records. Many repeat, however, we only need unique records. We DON'T have data about all categories, ...
-2
votes
0answers
7 views

How do complete duplicate row delete on a mysql table?

The mysql table consists of the following forms: atime / action / sip / sport / dip / dport / transip / transport / rcvbytes / sentbytes 2019-02-22 05:19:33 / close / 1.1.1.1 / 1234 / 2.2.2.2 / 80 / ...
-1
votes
0answers
3 views

Is it possible to add/remove squarespace pages based on an external database?

From what I've gathered, the answer to this question appears to be no, but I haven't seen my specific question asked, so I thought I'd give it a try. As with most programmers, I despise redundant ...
0
votes
0answers
6 views

Realtime plotting a graph for time complexity of RSA algorithim using php

I want to plot a time complexity graph of RSA algorithm using PHP and MySQL.but I don't know how to plot it real-time using PHP. please help me finding opensorce code or tool or libraries to plot it ...
0
votes
1answer
9 views

Software to create a database structure from a batch of XSD files

In my work we're now generating a database from a lot of XSD (50-100) for generating reports. This is a constriction imposed by the ministery, so there's nothing we can do. So the problem I'm having ...
1
vote
0answers
4 views

Tool to convert stored procedures from SQL Server to MySQL

I am already tried like a below tools for conversion Mysql workbench Dataloader (trial version) DRPU database converter (trial version) But, still i can't able to convert Stored procedures from sql ...
0
votes
0answers
13 views

Package to use with React native to subscribe to notifications/chat/etc provided by Laravel-implemented API

My friend is building a backend with php laravel framework and he is building an API to connect the backend with a React native app. Regarding Notifications, Chat and other form of data that need a ...
1
vote
0answers
8 views

MySQL client with ability to view images in columns

I have a column with a path to image files. At the moment I'm using HeidiSQL, but I would like to have a client that automatically loads an image file from a path.
0
votes
1answer
29 views

Recruitment: FOSS CRM(-ish)

I have to implement a CRM(-ish) system for a recruitment agency. I say CRM-ish, because I don't need any finical features. Basically, for candidates, I want to record their technical skills & ...
0
votes
0answers
11 views

Lightweight beautifully-designed MySQL GUI for windows?

I'm searching for a MySQL GUI tool which has a beautifully-designed GUI. I need something like Sequel Pro on mac
1
vote
0answers
7 views

Database table editor for Wordpress

I'm a software developer who will be building some relatively simple, but very custom components for a Wordpress website. Each component will rely on data located in one or two database tables. I'm ...
1
vote
1answer
19 views

Visual SQL Builder that includes ability to update data

I do not know SQL and need to create a script that will update data in our database. I know there is software and services out there that provide a drag & drop interface that build sql queries to ...
0
votes
0answers
9 views

Easy responsive GUI for php and mysql code

I have a website using php ( jquery, datatables etc.) with a mysql back end. The users would like to be able to change the themes, images , positions etc on the pages. I know you can embed php inside ...
1
vote
2answers
14 views

Current RDBMS options in the cloud

We currently have a MySQL installation that, because "it just works" has not been given the attention that it should have been. As such it is now running an unsupported version. As moving to a ...
0
votes
0answers
7 views

Relational or Graph-based Database for certain use case?

I would be glad if you could advice me the right database-technology for my problem: I want to store a bigger amount of objects (>5 mio.). These objects belong to different types (approx. 2000 ...
1
vote
0answers
18 views

DB admin software that can block certain query

I need to know if there exists a database administration software for MySQL which have the following features 1. Can have multiple connections to multiple db servers 2. Then, I can block any kind of ...
0
votes
0answers
12 views

MySQL + Airtable

Phpmyadmin When editing fields in Phpmyadmin it looks like below: It's not a very fun way to edit the data. You need to click into each row to edit so the overview is lost when editing the data. You ...
0
votes
0answers
16 views

High Availability solution for MySQL

Guys I need an advice. I am not an SQL geek but have some experience with MySQL. So Currently I am stuck with choosing the best solution. So I need an advice from proffesionals who really had hands on ...
0
votes
0answers
8 views

Automaticly import csv table into mysql database [duplicate]

I want to know how to write a script or what program to use to automaticly import data out of different csv tables into my database. Ive got 2 different csv tables with data they get updated every ...
0
votes
0answers
5 views

What to use to host a remote connection for mySQL and website

I have create a java web app in netbeans that is locally connected to a MySQL workbench database. I now want this to be abled to access remotely and the website to be hosted online. How do I set up a ...
0
votes
0answers
12 views

Package with mysqli suggestions/autocomplete for Sublime 3

Is there any package that allows me to easy-complete my (my)SQL commands like PHP Completions Kit does for PHP? I'm not looking for any generators, just simply word-suggester. Actually, I think that ...
0
votes
1answer
39 views

Is there any database which can be accessed offline without internet connection?

we need to design web and mobile app solution for a client. the requirements are following Application with offline capabilities, that will sync with cloud when you reconnect to the internet, but the ...
0
votes
0answers
9 views

Recommendation for Web-controlled music playback on pi

I want to work on a project I imagined a while ago where a raspberry pi plays back music from a queue. The queue should be accessible from a web page, hosted on the pi. As of now I have never worked ...
0
votes
0answers
6 views

MySQL + PHP + IoT - Notification on heartbeat failure

I'm working on a personal project that involves deploying internet-connected Arduino devices around my city. I'm planning on having them send a regular heartbeat to a PHP script that will log the ...
1
vote
0answers
20 views

Mysql user management centralized

I search software for centralized MySQL user management on linux platfrom. I want to manage multiple MySQL server (MariaDB 10+) or only users (create,remove and privileges) in one place. At the ...
0
votes
0answers
14 views

Backend for local and remote synchronized database

I am creating a small software using PHP and I want it to connect to a local installation of MYSQL The requirement is: Local mysql database will be updated by php, local database should synchronize ...
0
votes
0answers
37 views

MySQL Connector/C++ 8.0 for Visual Studio 2017

I'm looking for a DLL or Static library for MySQL Connector/C++ 8.0 for both Debug and Release mode that works with Visual Studio 2017. Should be for 32-bit platform (windows 7 and windows 10 ...
0
votes
1answer
19 views

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]

Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
0
votes
1answer
23 views

mysql viewer for windows that connects to SSH using a private key and a passphrase

I want to connect to a mysql database located on a linux server, through ssh and using private key and a passphrase, from windows 10, I'm looking for a GUI mysql viewer. PHPmyadmin won't work in such ...
0
votes
0answers
17 views

free mySQL management studio

This is my first question in this area I am looking for a good free mySQL management studio. I wonder if there is any thing as good as SQL Server Management Studio I tried mySQL workbench but is ...
0
votes
0answers
118 views

Simplest php/mysql form builder

I have a mysql database with several fields including columns called username and password in addition with few more columns of data. If an user enter username and password I need to display ...
1
vote
0answers
33 views

ORM with Master - Slave Replication and Load Balancing

I have an e-commerce website (built upon Opencart), utilizing Master-Slave replication (1 Master and 2 Slave DB servers). For effective load balancing, people recommended us to use Maxscale. However, ...