MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
14 views

mysql replication and innodb_file_per_table

Is it possible for the master (5.1) to have innodb_file_per_table = 0 and for the slave (5.1 or 5.5) to have innodb_file_per_table = 1 ?
1
vote
0answers
23 views

Can I create a trigger in mysql and update the same to oracle database? [on hold]

I am trying to replicate data from mysql to oracle db. Is that possible by creating triggers in mysql?
4
votes
4answers
465 views

SQL query to find player with maximum runs

I have the following tables with me : Table 1 Title : Runs +------------+---------+ | P_ID | Runs | +------------+---------+ ...
3
votes
1answer
49 views

How can I get the last inserted id from an specific table from a given stored procedure?

I know about the existence of LAST_INSERT_ID() function... Though I am not quite sure about its behaviour... Does it take the last inserted id from the current user into account? Or uses all the ...
1
vote
3answers
60 views

Multi-table optimal database design

I'm a bit new to the database design. Thus this question to people who may have more experience. I need to design a database that needs to store statistical data for many systems. The data is ...
1
vote
2answers
17 views

Select data where column value exists in seperate rows for same reference id

This is on a MySQL database. Locations have services. What I want is to get all results where service_id is 2 AND 3, not OR so using IN is out I believe. Database ---------------------------- | ...
0
votes
1answer
25 views

How to test mysql for changes

I'm OCD person, I think I accidentally dropped something in my mysql. Problem is I've around 50 databases, and I cannot manually check everything :( Is there a way to check for these kind of ...
0
votes
2answers
19 views

Error: This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table

I'm trying to run this query in mysql Ver 15.1 Distrib 5.5.44-MariaDB, for Linux (x86_64) using readline 5.1 but got this error all the time: CREATE TRIGGER trig_companies_table_insert BEFORE INSERT ...
0
votes
0answers
21 views

vtiger: can't login with newly created user [on hold]

When I create a new user in the 'Manage users' users section, and after trying to login with his details I get the following in log: Tue Jun 30 16:05:04 2015,666 [8555] INFO VT - PearDatabase ...
1
vote
1answer
32 views

Why does MySQLTuner only see 4Gb of RAM?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing ...
0
votes
1answer
29 views

What are the dangers of not gracefully shutting down mysql server

What are the dangers of not shutting down a windows MySql server gracefully (i.e. hitting the reset switch on the server as apposed to shutting the OS down) ?
0
votes
1answer
16 views

How to Upgrade Master Slave MySQL on AWS RDS?

I already have Master Slave configuration on AWS RDS. We want to upgrade 5.5 to 5.6.23. ..What should be correct sequence to Upgrade ? 1. Upgrade Master ( Using Modify Instance ) --> Upgrade Slave 2. ...
0
votes
1answer
16 views

Preserving create_time when loading a mysqldump file [duplicate]

I want to make a copy of a MySQL database but preserve the information_schema.create_time for each of the tables. I haven't been able to find an option to do that with mysqldump.
1
vote
2answers
36 views

Disable Primary Key on MyISAM Table

I wanted to speed up a large insert bulk by disabling keys. So I ran the following command on a MyISAM table: alter table my_table disable keys; When I execute show index from answer_2011, I see a ...
3
votes
2answers
130 views

INSERT data on MySQL to specific position based on its value (similar to ORDER BY)

I have a MySQL table with 3 columns for simplicity sake: Datename |Date |Name -------------+--------+----- 30/06/15test |30/06/15|test 30/06/15other|30/06/15|other Note: Column Datename is ...
0
votes
1answer
16 views

Old Data on SFTP [on hold]

There are several old files on an sftp of mine that date back to two years ago. These files are ingested into a MySQL database. I am wondering what to do with the old raw files. The reason I am asking ...
-2
votes
1answer
24 views

How to become MySQL trainer? [on hold]

I'm a certified MySQL developer and I have over a decade of SQL experience, most of it MySQL. What are the steps to take to became a MySQL trainer? Edited to add: Sample questions that made me ...
0
votes
0answers
16 views

Computing View Table based on rows of other tables [duplicate]

I want to compute a specific view, but I think it will be more clear if I show an example: Given this one view: | Group | User | Type | Quantity | |-------|------|------|----------| | 1 | 13 | ...
1
vote
1answer
48 views

mysql query choosing an incorrect execution plan

I have a primary with an dependant subquery as a where condition that is choosing a wrong execution plan, and therefore is running for ever. Main query: SELECT rtr.id AS id156_, ...
0
votes
2answers
29 views

Performance impact of adding a foreign key to a 1M rows table

I have an ecommerce database running MariaDB + InnoDB, which has a table to store the transactions (T) and another which stores quotes (Q). I'd like to make a connection between T and Q by adding a ...
3
votes
1answer
66 views

MySQL: UNION query to get a line for each date

Table1 DATE SKU QTY 2015-06-20 ABCD 3 2015-06-20 ABCD 1 2015-06-21 ABCD 5 2015-06-23 ABCD 2 2015-06-20 EFGH 1 2015-06-21 EFGH 3 Table2 DATE ...
0
votes
1answer
28 views

No connection could be made because the target machine actively refused it. MYSQL work bench?

I have created php and Mysql site.Its Working Locally Xampp well. Finally I moved My site to server..i have Used Mysql Workbench. connected client database in Mysql Workbench in My system.when I Run ...
3
votes
1answer
141 views

Indexes on Slave

I already have a my system with Master-Slave replication. I have started using Slave for data fetching. So, I need to create some extra indexes on Slave.[Not In master - however be informed that the ...
3
votes
1answer
66 views

MySQL 5.5 to RDS 5.6 Replication Error

I am facing following error and unable to fix it. So far I have disabled binlog checksum on the RDS. [Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum ...
3
votes
2answers
21 views

Is it possible to backup stored routines and functions with Innobackupex?

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ? I am only ...
3
votes
3answers
139 views

INSERT/UPDATE in same query from previous SELECT with some singularities

I'm trying to perform a INSERT|UPDATE by selecting data from another DB and this is what I have so far: INSERT INTO pdone.reps (veeva_rep_id,display_name,username,`first`,`last`,email) SELECT ...
1
vote
0answers
26 views

MySQL log tables design

I have to make 25 modification historic tables from 26 tables. I need a design for each table that could grow more than 75,000,000 of rows. I use InnoDB for 25 tables and 1 with MyISAM. I have one ...
0
votes
0answers
22 views

Syntax error when creating SCHEMABINDING view

I am trying to implement full text search in laravel 4, with mysql database. To implement full text search I need to create indexed view. When I am trying to create view with schemabinding i am ...
0
votes
2answers
24 views

MySQL Add/Grant user if it does not exist

I am trying to create a update/install script that adds a user and database only if it's a fresh install. The script uses a randomly generated password for the user, so using the GRANT statement as ...
0
votes
1answer
14 views

MySQL RDS Error 1062

Normally we can skip 1062 duplicate error but in rds can we skip multiple 1062 errors in one go. For example we define slave skip error =1062 in my.cnf and restart slave. but in RDS MYSQL how can we ...
1
vote
1answer
16 views

DB Schema for Timesheet

Hi I want to create a web based resource tracking system which will be used by my manager using php and html. The db i am using is MySql. I have already created tables for employee, project etc. I ...
2
votes
2answers
43 views

Mysql alter table question

I have a huge table in my mysql 5.6.19 database -around 5.7 gb of data- and there is a need to alter a description column which is currently set to text, to be able to contain around 500000 chars. Now ...
1
vote
0answers
10 views

Adding new sproc to the exisiting database using connectors?

The project I'm currently working on is mostly pythonic, by this reason I'll likely use mysqldb python connector or sqlalchemy. The question arose when I've tried to find out the way of adding new ...
0
votes
0answers
29 views

Database migration stops halfway through

I've had issues trying to use PostgreSQL so changed my application to use MYSQL. But, when I run rake db:migrate I get the following message before the migration stops: -- PostgreSQL database ...
2
votes
3answers
41 views

How to show multiple names for one record but not duplicate the record?

I have a database structure like so: Car - id - carname - image - category - status Parts - partid - partname CarParts - carpartid - carid(fk) - partid(fk) - amountid(fk) Category - ...
0
votes
2answers
36 views

MYSQL Select Distinct with SUM

I am developing a Stocks management application, the Portfolio register table has 4 columns, other than date and registry_key, and it looks like this: ---------------------------------------- | ...
0
votes
0answers
41 views

MySQL queries waiting for table lock

Today I had some weird behaviour on my MySQL server that I couldn't explain. Hopefully someone can give me some debugging hints. The initial problem was that some parts of our webshop didn't seem to ...
0
votes
2answers
12 views

Mysql Data truncation for Valid DECIMAL

create table test(id INT, value DECIMAL(25,6)); insert into test values (16, 10e16); insert into test values (17, 10e17); -- Works till here insert into test values (18, 10e18); -- Fails here. Data ...
1
vote
1answer
16 views

update query field order guaranteed

Is an UPDATE query in MySQL guaranteed to execute the field updates in order that are presented? e.g. UPDATE `table` SET `first_to_update` = `second_field`, `second_field` = `third_field`, ...
0
votes
2answers
22 views

No connection could be made because the target machine actively refused it

I have created a PHP site using MySQL. It works well on localhost. However, when I moved it to a remote server, it stopped working. The error shown is: "No connection could be made because the ...
0
votes
1answer
35 views

How to create index on long data type field

I have a MySQL table with a long data type field: `create_date` long NOT NULL, I want to index it: CREATE INDEX ix_logs_create_date ON `logs` (create_date) USING BTREE; But I encounter the ...
2
votes
1answer
31 views

How can I pass object to procedure from trigger? [on hold]

I am using mysql 5.6. After insert or update, inside the trigger I am calling procedure, So how can i pass NEW and OLD object from trigger to procedure ?
0
votes
1answer
25 views

Create TRIGGER to insert after the insertion of specific value

I have the following TABLE #1 id time sender receiver message status aux_id TABLE #2 time_to_send sender receiver message aux_id The TABLE #2 has a process that sends the data to an api which ...
0
votes
1answer
30 views

Moving MySQL data from RDS to RDS

We have an RDS instance with about 200G of data in it. A few issues cropped up on our end, and we need to both change the collation and charset of all our tables, as well as have all the data ...
2
votes
2answers
53 views

Problem with mysql group_concat, complex query, not getting required result

I have 5 tables college trade district contact intake Their relationship looks like this I'm having problem with the contact table. In this table, cid and location are the primary key. It can ...
-1
votes
0answers
20 views

MySQL Freezes System Preferences then crashes mac

Ive installed MySQL Server on my Mac mini but when I try get to the preferences panel through the system preferences I get an alert saying: system preferences quit unexpectedly. Then the machine ...
0
votes
1answer
11 views

How can I parse mysql bin log file for statements (Row/Mixed Format)

I have a mysql database running with binary log enabled. Unfortunately, a statement was executed by the client, which turned out erroneous. Since a number of records have been "affected", I want to ...
1
vote
4answers
65 views

SQL retrieve last elements of table using group by like behaviour

I am trying without success to retrieve the last version of all articles in a table. The table structure: CREATE TABLE `journalarticle` ( `uuid_` varchar(75) DEFAULT NULL, `articleId` ...
0
votes
0answers
7 views

Toad for Mysql gives error on Compare

I've posted this message on Toad World looking for help but no one has answered. So I'm trying here. I repeatedly get the same error while using any of the Compare options when connecting to a ...
3
votes
2answers
23 views

How do I connect to mysql without having to type an empty password?

I just installed MySQL, and by default the root user has no password. If I connect with this command: mysql --port=3307 --host=127.0.0.1 -uroot -p It asks me to enter a password, I just hit return, ...