MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
4 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
13 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.
0
votes
2answers
29 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 ...
2
votes
2answers
97 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
15 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 ...
-1
votes
1answer
14 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?
0
votes
0answers
15 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
25 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
25 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
0answers
37 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
22 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
139 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
20 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
128 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
24 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
19 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
11 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
15 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
9 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
24 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 - ...
-1
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
33 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
14 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
34 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 ...
1
vote
1answer
28 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
25 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
56 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
6 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
22 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, ...
1
vote
1answer
30 views

Search and compare list of ever-growing IPs

I'm a newbie when it comes to mysql things and queries in general, just wanted to point that out. I'll keep this as short as I can. I have a table where I track the IPs of users that enter the ...
0
votes
0answers
22 views

http vs sql queries [migrated]

i have big problem deciding what approach to take, i have many pages on my site that uses tabs. for example a page with 5 tabs (horizontal tabs). now every tab takes data from different table in the ...
0
votes
0answers
8 views

Amazon RDS Read Replica

I would like to know, is the Read Replica is nothing but the slave server, where only reads are there. I created two mysql instances in amazon RDS, one is Read Master, and another is Read Replica. ...
0
votes
0answers
33 views

How can I write a query to aggregate multiple strings into one field? [migrated]

I am trying to merge three tables. The first table has id and data_name, second table data_id, option_id and property, third table user_id, data_id. For example: first table +----+-----------+ | ...
0
votes
1answer
23 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
0
votes
0answers
8 views

mysql 5.5 statement based to rds mysql mixed replication

I am moving to rds mysql 5.6 that has by default mixed replication. I am moving from 5.5 where I have statement based replication. I was wondering if i enable replication between them i.e make rds ...
0
votes
1answer
34 views

Adding columns & index to a huge table

I'm working with a Rails app backed by a MySQL database. One of the more-frequently used models is backed by a table with over 200,000,000 rows (and growing). We've been aware for a while that the way ...
1
vote
1answer
32 views

Cannot delete MySQL trigger. Appears in information_schema, but no .TRN file

I have a MySQL database with a few tables and triggers. A process was trying to drop one of the triggers and it failed with the following error: Malformed file type header in file 'trigger_name.TRN' ...
-3
votes
1answer
48 views

How to organise huge mysql database for emails and search through it

I wanted to ask you for your opinion, what would be the ultimate and the best way to store million of emails and search on them, using MySQL. So first the product: You have tons of emails, which ...
0
votes
1answer
26 views

MySql Insert signal if where clause fails

As part of a chained sequence of transactional queries, I'm inserting values that exist in a temporary table into a new table. Every query is validated for errors in PHP using: if ...
1
vote
1answer
49 views

Trying to restore users/passwords for a MySQL server

I had a system failure, but I managed to save the /var/lib/mysql library on my linux system. I have since rebuilt a new Linux (Ubuntu) system (LAMP). I copied the old /var/lib/mysql/mysql folder to ...