MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
2answers
259 views

Mysql trigger not working, syntax issues

I have this trigger CREATE TRIGGER checkcollision AFTER UPDATE ON players BEGIN SELECT RAISE(ABORT, 'collision') FROM walls WHERE NEW.x=x AND NEW.y=y; END; mysql 5.1.72-0ubuntu0.10.04.1 ...
0
votes
0answers
4 views

MYSQL Thread Historical Data

We had to force a restart on our database server today and we're now trying to find out what the server was doing at the time of the shutdown. In our error logs we have found 5 instances where the ...
0
votes
0answers
12 views

BEST RELATIONAL DATABASES APPROACH FOR DELETE: use DELETE or use a valid/non-valid COLUMN?

When it comes to databases, which is the best technical approach to use when a user want's to delete his profile/delete some of his products from a shopping card: Actually delete the rows from the ...
1
vote
2answers
40 views

Stored procedure to check if username exists

I'm trying to write a stored procedure So far I have this, but it always returns 1 CREATE DEFINER=`root`@`localhost` PROCEDURE `USER_EXISTS`(IN `USERNAME` VARCHAR(64) CHARSET utf8mb4) SELECT CASE ...
0
votes
1answer
10 views

MySQL:How much aprox disk space required for bin_log of the 80GB of DB?

I had total 80GB of database in MySQL server,and there is huge amount of trasaction are happend on daily basis,I need to be enable a bin_log so I required a recommendation how much disk space is ...
1
vote
3answers
15 views

mysql import failed caused by overgrown general log file

I have a table about 70G in size. I took a backup using mysqldump. In the new server, I performed a restoration. time mysql -uroot -p TDB < TDB.sql Enter password: ERROR 3 (HY000) at line 58155: ...
0
votes
3answers
544 views

Two nullable columns one required to have value

No-Explanation Question: Is there anyway to have a constrain of 2 null values that always requires 1 to have value ? For example two date columns both null but having at least 1 that requires to have ...
0
votes
1answer
2 views

Mysql connect without username/password

I build a new website for a client (WordPress is underlying) and have access trough FTP to his webspace. He does not provide or even know more informations than this because he had taken it from an ...
0
votes
1answer
16 views

How to limit the range of an insert-update to only look at certain rows/ rows with field value: X?

I posted something similar before, but am still unsure of the technical implementation --- I'm so close to being there to the finished product. I have a table of tickets, and a stream of ticket ...
0
votes
1answer
279 views

MySQL select by primary key against 100M of records within 30ms

I have no expirience with MySQL and database performance tuning in general. Wondering whether it is possible to perform a large number of selects against 100 millions of records by primary key within ...
0
votes
1answer
124 views

MySQL update one table from another joined many-to-many

I have two tables, events and plays joined many-to-many by a third table plays_in_events. Where the events.Name field is blank, I want to set it equal to the name of the play that was performed in ...
0
votes
0answers
6 views

Determine parent id when moving hierarchical data to different tables?

I've got several tables which contain category and tag relationships for different posts. I'm trying to move the categories from the posts table into their respective tables while maintaining their ...
0
votes
1answer
487 views

MySQL: Prevent DROP TABLE and TRUNCATE TABLE on Slaves

Can someone tell me how to prevent the following commands DROP TABLE <tbl-name>; TRUNCATE TABLE <tbl-name>; from being replicated to slaves?
0
votes
0answers
16 views

Database Design Question? Relationships and Form Data

I am working on a project that requires to store evaluation form data. Essentially, the a reviewer will fill out a form based on the performance of the person being evaluated. Now there is well over ...
0
votes
1answer
317 views

Report Builder cannot publish to report server

This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is ...
0
votes
0answers
11 views

All users are having NO Privileges in phpMyAdmin

By mistake, I changed all the privileges of user 'root' in my MySQL Database. Not even a single privilege is having for that user. Now if I log in with another user I am able to access only one ...
1
vote
2answers
538 views

Trying to recover/import/transfer database from MySQL data dir

I used phpMyAdmin->export to create a backup of my database but I have now discovered it did not export the whole database, some tables was missed/refused. However at the time of doing the export I ...
0
votes
2answers
28 views

How do I do an outer join between all nested subqueries? (getting an error of 'OUTER' is not a valid input for this position)

I have this query: SELECT AVG(a.score) AS Average1, AVG(b.score) AS Average2, AVG(c.score) AS Average3 FROM (SELECT subfactor.score, dateID, EmployeeID FROM employeescore LEFT JOIN ...
0
votes
0answers
36 views

Very high CPU caused by mysql service

A running mysql service uses CPU in a crazy way. (See attached screenshot from htop) I followed the instructions here with no luck. My server specs: CPU: 1900Mhz . Intel Hexa-Core Xeon E5-2420 ...
1
vote
2answers
167 views

MYSQL joining 3 tables with left join

I have these tables: pupils: (id_pupil, name, surname, email, user, pass, level, class) incidents: (id_incidents, date, time, type_incident, comments, id_pupil, id_user, subject, id_trimester) ...
1
vote
1answer
19 views

Migrating Oracle to MySQL: MySql Workbench Not Available

I am currently trying to migrate information from a query of a remote Oracle database to a local MySQL database. I have poked around and have found it has been frequently suggested to use the ...
0
votes
1answer
20 views

MySQL script writing slow

I'm using php and the exec() function to run 2 MySQL script files one after another The first file has approx 2k update statements (see below) in and is 114kb in size. UPDATE table1 SET is_active = ...
2
votes
3answers
103 views
+50

How can I make MySQL client read password from mylogin.cnf?

I'm trying to make the mysql client connect to a mysql server without requiring the password to be given interactively. Steps taken: 1) First create a mylogin.cnf file $ mysql_config_editor set ...
0
votes
1answer
28 views

Query results that not are in previous query result

I want to retrieve from my table the id_product of the products which haven't got some attribute and it's value is not the ones i want For example i want the id_product of the products in which ...
0
votes
1answer
19 views

auto increment for the table with 1000 of records in mysql

How to reset auto increment for the table with 1000 of records in mysql. I want it to start counting from 1 again.
1
vote
1answer
338 views

Unable to use mysql_upgrade:

I updated mysql recently and found problem related to privileges and backup. When I am using mysql_upgrade command it says- mysqlcheck: Got error: 1064: You have an error in your SQL syntax; check ...
1
vote
1answer
363 views

MySQL users corrupt

I have a strange situation here: From time to time I cannot log in with any of my mysql users. I even cannot make a mysql dump. So I started searching in mysql files and I found that users.MYD and ...
-3
votes
0answers
24 views

Hi this is my requirement can you help me?

Student sid name address phno 1001 abc nellore 1342425 1002 xyz allur 98876545 mark sid m p c 1001 45 34 34 1002 62 13 78 fee sid fee 1001 ...
0
votes
1answer
13 views

Shell script for partial table backup

I have multiple database in my MYSQL server and i want to take some particular tables backup from each database. can anyone help me in writting a shell script for this scenario.
0
votes
1answer
23 views

How to pass the input parameters to dynamic Pivot stored procedure

This Is My Query: DELIMITER $$ DROP PROCEDURE IF EXISTS `leavemanagement`.`SP_ViewAttendance` $$ CREATE PROCEDURE `leavemanagement`.`SP_ViewAttendance` ( IN in_branch_id varchar(10) ) BEGIN ...
1
vote
1answer
250 views

How to improve the performance of SELECT queries with multiple JOINs on a 50GB database hosted on AWS m3.medium MySQL RDS?

Example query: SELECT p.ListAgentEmail, p.ListAgentFirstName, p.ListAgentLastName, p.ListingKey FROM Property_RES AS p INNER JOIN Property_RES_COUNTIES_OR_REGIONS ON ...
3
votes
1answer
690 views

To what extent is MariaDB Java client a perfect replacement for MySQL JDBC (Connector/J)?

Premise: I ship a Java application which will make a JDBC connection to a MySQL database. (At the time of this writing it could be 5.1 or 5.5, but hopefully the question and answer don't rely heavily ...
0
votes
1answer
227 views

Consolidated realtime mysql backup with master/slave setup or binlog

I have 20+ mysql servers and their have low write requirements. So, I want to see if any way I can replicate the data/binlog from these servers to a single slave so realtime backup purpose. If I ...
1
vote
3answers
46 views

MySQL: List databases with tables

Is there a way to list all my databases with tables in a single command? Expectation: mysql> SHOW DATABASES, TABLES; DB1 table1 table2 DB2 table1 table2 table3 ...
2
votes
1answer
32 views

BLObs – Should I Store In Database Or in Directory Structure?

BLObs – Should I Store In Database Or in Directory Structure I have been developing a database to replace an ageing data structure that contains 1000's of files within a directory structure. The ...
0
votes
1answer
108 views

Index to fix this query MySQL

We have an extremely large forum running lots of third party software (Most of which doesn't run all that well) and we're starting to optimize things as time allows. This query keeps popping up in the ...
0
votes
0answers
12 views

maxscale read/write split with mysql [on hold]

I am setting up mysql MMM with two slaves. I will use slaves for read only and master for writes only. I do not have read/write split in application. I came across maxscale program. I was wondering if ...
1
vote
1answer
31 views

Merge multiple columns into one column in different table?

I've done this before, but I don't remember how. I need to select all rows from several columns in one table and insert them into one column in a different table while keeping them all on separate ...
0
votes
1answer
141 views

Very slow update with subquery (different tables)

I run this query to update "domains" table based on "log" table: UPDATE domains SET domains.mx_collected = 0 WHERE domains.domain IN (SELECT log.mail as domain_name FROM log WHERE `time` >= ...
-1
votes
1answer
14 views

restore mysql 5.0.77 backup to mysql 5.5 [on hold]

I am having backup of mysql version 5.0.77. I want to restore backup of 5.0.77 to our new machin having mysql version 5.5 What is the procedure?
0
votes
0answers
6 views

When will store procedure/functions support result set as return type

I have noticed that MySql doesn't support result-set on a store procedure and functions, which means return a table. So I can't do things like CALL sp_my_store_procedure() ORDER BY id ASC; Or ...
0
votes
1answer
40 views

SQL CLR in MySQL?

Can we call SQL CLR in MySQL Server using User Define Function? I want to create trigger in mysql. It will call user define function and this UDF will update the table in SQL Server.
0
votes
0answers
9 views

i want to get Hierarchical structure of category and subcategory for nth level in one mysql query

i want to get Hierarchical structure of category and subcategory for nth level in one mysql query. i try some solution but it's not work properly. i try following query but it only get only ...
0
votes
2answers
716 views

Why is my RDS mysql slow query log full of server restarts?

One of my RDS mysql databases is giving me warnings about the slow query logs taking up significant space. The logs are rotated once an hour, and contain a dozen repetitions of: ...
0
votes
2answers
11 views

Compare values in SQL having dots

I'm comparing values from two different database. In one table the name is stored with dots(i.e A.B C) and in another table the same value is stored as AB C(i.e in second table none of the names ...
0
votes
1answer
63 views

Select the last massage for each user [on hold]

Please help me with a query. I know, that my english is not even on basic level, but I try to explain. I want to write a query that selects every last massage from each user (I want to create a dialog ...
0
votes
2answers
24 views

MySQL replication - how to read from slaves? manually?

MySQL Manual - Replication: "Scale-out solutions - spreading the load among multiple slaves to improve performance. In this environment, all writes and updates must take place on the master ...
1
vote
1answer
157 views

How to export a MySQLtable with a longBLOB column to an Oracle database?

In MySQL I have a table: Select * from Dummy; Columns like below: id name salary binary_col 1 a 100 A.pdf 2 b 200 b.pdf 3 c 300 c.pdf 4 d 400 d.pdf 5 e 500 e.pdf ...
0
votes
1answer
587 views

MySQL failover - Master to Master Replication

My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
0
votes
1answer
125 views

mysqldump 5.5.25 use swap instead of memory

mysql version 5.5.25, while use mysqldump to dump big tables, it eat lots of swap while there is lots of free memory. # free -m total used free shared buffers ...