Stack Exchange Network

Stack Exchange network consists of 174 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
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [mysql-5.5]

MySQL version 5.5 - please also tag with mysql for search purposes.

0
votes
2answers
11 views

How do I export a multi table database with exceptions?

I am working out of phpmyadmin to export data using an sql. I have an 88 table database. I would like to export all data to a .csv from 85 of those tables where I am only keeping the rows in which my ...
0
votes
1answer
31 views

Converting MySQL 5.5 datetime binary to MySQL 5.6 (math problem)

I received a database "backup" of binary files (.frm and .ibd) that were copied from a MySQL 5.5 install. Unfortunately, I was unable to get these files to import into a MySQL 5.5 vm that I created. ...
0
votes
0answers
3 views

Submit values to mysql data base form a form in side another form together

I have some questions on php. imagine this form <form> <input type="text" name="name"> <form id="second" onsubmit="return false;"> <input type="text" name="name1"> </form&...
0
votes
1answer
17 views

How to transfer data from mysql 5.5.24 to 5.1.36

I've had a server that is not booting up, it had mysql 5.5.24. I was able to copy the whole /data directory. I will be temporarily using an older backup server that has mysql 5.1.36 and cannot be ...
0
votes
1answer
17 views

Do I need to `mysql_upgrade --verbose -u root -p` each time when `source backup.sql`?

I am upgrading mysql 5.1 to mysql 5.5 in centos 7 server. As time limit,I only mysqldump and source several small database to mysql 5.5,and then mysql_upgrade --verbose -u root -p,everything is ok. ...
0
votes
0answers
17 views

MySQL innodb_log_file_size causing problems starting MySQL [duplicate]

I have just restored a backup taken from xtrabackup (only for testing, so not critical luckily), and I am getting the following error: InnoDB: Error: log file ./ib_logfile0 is of different size 0 ...
0
votes
1answer
15 views

mysql 5.5 repartition

With MySQL 5.5, I want to change the partitioning scheme of a very large InnoDB table from "hash" to "range". Can I do it while the table is accepting DML? If not, what is the best-practice work-...
2
votes
0answers
24 views

ranking using find_in_set

Trying to use this method to get the rank position of $associateID. Everything works except FIND_IN_SET. It's not reading alias1 or alias2. Does FIND_IN_SET work with alias's? How can I get this to ...
0
votes
1answer
26 views

Slow query with multiple group by

I have a query to get all the comments from threads where a given user has commented and not yet seen the comment. So if user 1 commented to a topic, then user 2 commented after his comment, then user ...
1
vote
1answer
19 views

Error while restoring the table dump

ERROR 1067 (42000) at line 25: Invalid default value for 'created_on' I'm getting this error while restoring a table after taking the dump(remotely). I have used mysqldump -h (hostname) -u -p (...
0
votes
1answer
23 views

MySQL MONTH Clause: Want to get Month Name instead of number

My query is SELECT MONTH(`hire_date`) AS month FROM `emp_tbl` I'm getting output in Java fx if(resultSet.next()){ int month = resultset.getInt('month'); // output is like 11 } Then I ...
0
votes
1answer
28 views

How to get same column values to make multiple columns?

I don't know if my question is valid or not but I'm working on an attendance system, and I want to get some output for my project. I have an attendance table that holds three columns: emp_id, ...
0
votes
0answers
14 views

MySQL 5.6 and Replication

I'm stuck with one specificity of Replication on MySQL servers. I'm currently working with this configuration : A <--> B ⊦---> C ---> D I explain. I've got a replication Master <-->...
0
votes
1answer
24 views

SQL Query Optimization (Mysql 5.7)

I have following query to execute in live mysql 5.7, which takes around 7 sec and we want to reduce their time, please support SELECT COUNT( DISTINCT InternalInquiry.inquiry_id ) ...
0
votes
1answer
24 views

MySQL Range Optimization and Multipart index

I'm new to the MySQL world. When I read about MySQL Range Optimization some questions were raised related to multipart indices. MySQL 5.7 Doc (http://jorgenloland.blogspot.com/2011/08/mysql-range-...
1
vote
3answers
27 views

Does MariaDB 5.5.56 have INFORMATION_SCHEMA.INNODB_METRICS?

I'm trying to debug why I don't have INFORMATION_SCHEMA.INNODB_METRICS. I'm uncertain because I see it in the MySQL 5.5 reference glossary: https://dev.mysql.com/doc/search/?d=10&p=1&q=...
0
votes
1answer
21 views

Why is this blob saving when used as a concatenated string but not as a prepared statement

I have a PHP mysqli prepared statement that looks like this: $editSQL = "UPDATE tblClientReminders SET Header = ?, Notes = ?, DepartmentID = ?, TierID = ?, RemindType =...
1
vote
1answer
29 views

mysql : ordering a table in the order of the primary key

I have a table with a primary key consisting of two integer columns. I store ~200 millions lines in this table. My program needs to get the full table ordered by the columns of the primary key in the ...
0
votes
1answer
14 views

Should I created a different table to hold a big text / varchar field in MySQL 5.5.61 with Antelope file format?

I read that newer version of MySQL save the big text fields apart from the rest of the row, so we don't have to bother about it. However, how about an older version, specifically MySQL 5.5? Is it ...
1
vote
1answer
13 views

Condition evaluation with NULL or ''

I am having this strange effect from evaluating truthiness of a field IF ( a IS NOT NULL && ((b IS NOT NULL) || (NOT b = '')) && c IS NOT NULL ) THEN set NEW.results = "Passed" ...
0
votes
1answer
23 views

Master slave replication with different mysql version is on both slave and master

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7. Is it possible to add Multiple ...
-1
votes
1answer
31 views

Is mysql using some kind of auto repair due to “check table” warnings?

Today i noticed a "strange" behaviour of MySQL when using "CHECK TABLE" on a crashed table. First i got a warning like "Size of datafile is: * ... Should be: *" but i could still "insert into / select ...
1
vote
1answer
19 views

Table column length is fine in MySQL 5.5 and 5.6, but upgrading to 5.7 results in too many columns

So I have a CMS that is being upgraded from MySQL 5.5 -> 5.7. One table has a 1000+ columns, but it works fine in 5.5 and 5.6. When reaching 5.7, queries involving this table result in a 1117 error. (...
0
votes
1answer
35 views

Remove Characters & Sum Numeric Values

I am using mysql 5.6 and want to remove all characters from json output of db column and after that required sum of numeric values Input: {"across_back":"0","bustd":"0","waiscvvt":"50","hisdp":"50"...
0
votes
1answer
27 views

MySQL, would like to get both a field and a count inside GROUP_CONCAT

I can get a list of statuses that a tracking ticket has had, as well as the id of those statuses, as follows: SELECT t.id, t.name, GROUP_CONCAT( CONCAT(s.id, ':', s.name) ORDER BY s.id) AS ...
0
votes
1answer
35 views

MySQL replication much slower on MySQL 5.7 compared to MySQL 5.5

I have two databases setup for testing (so no live data or connections). The first is a MySQL 5.5.57 Database acting as the master. The second is a MySQL 5.7.23 Database acting as a slave. It is ...
0
votes
1answer
415 views

How to insert data to database by using checkbox in PHP MySQL? [closed]

I have this output: a problem while I inserting data the time value for all users inserted to the database, I want when I checked the checkbox send the time value to the database for every student I ...
0
votes
1answer
23 views

Does the row locking on slave database also apply to master database?

In a transaction, for example, START TRANSACTION; SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE; INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '...
1
vote
1answer
62 views

Information_Schema.Tables reports different result in MySQL 5.5 and MySQL 5.7

I have started testing some MySQL 5.7 databases to replace our ageing 5.5 Databases, and there seems to be a significant change in the way the information_schema.tables Table records the data size. I ...
1
vote
0answers
31 views

Allocate each value, considering what would be inserted

I'm stuck in a challenge where maybe you can help me. This is what my data sets for the tables look like: entities Object Payment Invoice InvoiceItem Payoff Object has N payments Invoice has ...
0
votes
1answer
82 views

Selecting data from multiple rows into a single row multiple columns [duplicate]

I have a table that has columns like following. Batch number is a database design thing like row number dm_id type_in_id type_student_id amount 36 1 1 ...
2
votes
1answer
49 views

MySQL Replication Stops, But Still Says it is Running

I've got a strange replication problem. For reference I am using MySQL 5.5 with Statement Based Replication. We have a Master with Slaves on site A / network A, and slaves on site B / network B. ...
0
votes
1answer
58 views

in MySQL what is the query to show these student's that each marks less than 50?

I have this table marks in MySQL database I used a query to output this table that shown as below: it's my output: I want use a query to show these student's that each marks less than 50, output ...
2
votes
5answers
57 views

How can I make CASE WHEN query faster?

I have the following query which takes around 20 seconds to return data: select landing_page, SUM(CASE WHEN profile_id=77 and month(dates)='8' and year(dates)='2018' THEN ...
0
votes
1answer
447 views

In PHP MySQL how to sum or not sum multiple columns?

I have three tables this is my codes: <table border='1'> <tr> <th>Subject</th> <th>Mark1</th> <th>Mark2</th> &...
1
vote
1answer
197 views

getting innodb buffer usage

I am running MySQL 5.5.52 I am trying to see how much of my innodb buffer pool is used. If I run 'show engine innodb status' I see this: ---------------------- BUFFER POOL AND MEMORY -----------------...
0
votes
1answer
225 views

Can I perform a transaction across two different MySQL databases on two different servers in different tables

I have a table A in database db1 in server A and table B in database db2 in server B, both of which are MySQL. Is it possible to make a transaction, where updates in both tables are involved? ...
2
votes
3answers
70 views

Where future rows don't exist

I have the following table CREATE TABLE TaskJournal ( TaskJournalId INT NOT NULL AUTO_INCREMENT, TaskId INT NOT NULL, TaskStatus TINYINT NOT NULL, TaskStart INT NOT NULL, TaskEnd INT NULL, ...
0
votes
1answer
135 views

What is the safest way to install the sys schema on a production server?

The reason I'm asking is because I need to install the sys schema on my database so that I can utilize performance_schema because I'm hoping that will help me figure out why mysql is crashing every 30 ...
0
votes
1answer
164 views

Is there a routine in MySQL similar to fn_dblog in SQL-server?

I already search about fn_dblog and it is about transaction log and it is used in SQL SERVER. if there any way to do transaction log in MySQL like fn_dblog? i can't find one
1
vote
1answer
31 views

What is wrong with my trigger?

For reasons unknown to me, the control flow doesnt reach "ITS CORRECT BUT PRIZE IS MONETARY" block, that corresponds to variable bounty not being NULL. I'm pretty confident that SELECT Bounty FROM ...
1
vote
2answers
203 views

Distinct value across multiple columns

I have a table like this, CREATE TABLE foo ( id integer, col1 integer, col2 integer, col3 integer, col4 integer, col5 integer ); INSERT INTO foo (id, col1, col2, col3, col4, col5) ...
0
votes
0answers
189 views

AWS RDS MYSQL SP Privileges Issues (Error Code: 1227)

I have created SP in RDS-MYSQL with the user of abc. Now, I want to update from user xyz but its giving me message: (Note: Both user have full access on db) Error Code: 1227 Access denied; you need (...
0
votes
3answers
68 views

Left Join of a Subselect query very slow

I'm using mysql 5.5. and I have three tables: newsletter_newsitem: contains a row per news item newsletter_newsitem_areas: a many-to-many table that relates a news item to a region (a news item can ...
0
votes
0answers
44 views

innodb_trx shows transaction state running but nothing in processlist

Hi I am using MySQL server 5.5.58 (RHEL 7). When I see select * from information_schema.innodb_trx, it shows me trx_state as running and SHOW PROCESSLIST has nothing. I am confused. What could this ...
0
votes
0answers
19 views

MySQL suddenly execute old queries

We found out that mysql (5.5) execute old queries (update statements), we saw this in our binlogs from 29th may 3 month old queries. Timestamp of the query is from February 19th. #180219 19:12:02 ...
0
votes
0answers
28 views

What's the meaning of trx0sys.c in show engine innodb status?

Hi I have gone through https://www.percona.com/blog/2006/07/17/show-innodb-status-walk-through/ howto read/interpret "show engine innodb mutex" output? https://www.percona.com/blog/2011/09/...
0
votes
1answer
115 views

Help with setting up MySQL on a dedicated server - detailed report given

I need help because I do not understand much MySQL settings on a dedicated server. I have one WordPress website installed with medium traffic with W3 Total Cache. The storage engine is InnoDB. ...
1
vote
0answers
370 views

How to transposing rows into columns in MySQL?

I have three table (student's_info,subject and marks): this is table student's_info: ---------------- |s_id | s_name | ---------------- | 1 | Ali | | 2 | Jon | --------------- This is ...
0
votes
1answer
631 views

How to see special characters in MySQL Workbench query results?

In my Database, I made a small mistake by inserting a blank (space character) after a value like this: INSERT INTO MYTABLE(country_name, code, value) values ('France', 'FR ', 345); -- id is ...