Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [mysql-5.1]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
48 views

Remote connecting to Asterisk mysql database from internet issue

I can connect to Asterisk MySQL database (asteriskcdrdb) and everything is okay. Asterisk server located in my LAN network. I can to connect to this database from my computer with Mysql client ...
user avatar
  • 101
0 votes
1 answer
346 views

'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,EXPLICIT) for operation '='' on query

I have migrated the mysql 5.1 to 5.7 by using the mysqldump file. But i am facing the issue during master slave replication as below. Error 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (...
user avatar
0 votes
1 answer
50 views

How to set up mysql docker container with existing ib* files?

Related to a previous issue, I'm trying to recover some data from existing ib* files from a crashed server. The database version is 5.1.69, so quite old. One of the responses was to install MySQL 5.5, ...
user avatar
1 vote
1 answer
26 views

Latest version to support MySQL 5.1.69 ib* files

Would like to recover InnoDB data from a crashed server. The last backup indicated it was running MySQL server 5.1.69. When doing a recovery, the log files show that the current MySQL won't support ib*...
user avatar
0 votes
0 answers
115 views

allow Linux ROOT user access MySQL server without password - how this is done?

MySQL Server 5.1 OS - RHEL 6.10 I have got this new client to work on and I don't see the MySQL root password saved anywhere. Not in any file under root's home directory or in any other configuration ...
user avatar
1 vote
2 answers
56 views

Problem with complex queries after migrating from MySQL 5.1 to MariaDB 10.4

I completed a migration from MySQL 5.1 master-slave system to a MariaDB 10.4 Galera Cluster. All the databases where copied over since they were on InnoDB per-file and they are working fine. However ...
user avatar
0 votes
1 answer
2k views

The OLE DB provider "MSDASQL" for linked server "(null)" reported an error

I created a linked server to MySQL database server on my SQL Server database server. I tested the connection. It succeeded successfully for MySQL connection. I can see the databases on MySQL instance ...
user avatar
  • 59
1 vote
1 answer
61 views

MySQL still using one CPU even though extra CPU added

I m SQL server DBA. My company just handover one MySQL server to manage which i m still learning. Recently extra CPU has been added to the server due to CPU is 100% but when checked on the server , ...
user avatar
1 vote
2 answers
2k views

Mysql Daemon cannot start after upgrade from 5.1 to Mysql 8

I preinstalled Oracle Enteprise Linux and it automatically installed Mysql Community 5.1. But I wanna update it to 8. After update the daemon won't start and the /var/log/mysqld.log shows that [...
user avatar
0 votes
1 answer
48 views

Update query over nested select query

Want to update status of only those record whose a_msisdn count > 100 on specific date: mysql> select * from cc_info limit 1; +----------------------+--------------+--------+------------+----------...
user avatar
1 vote
1 answer
3k views

Insert into table with column same values as auto increment column ( computed column )

Say I have a table with "column1" (Primary Key, Auto Increment) and "column2". How can insert into the table with column2 will have the same values as column1 which is auto increment column?
user avatar
  • 13
2 votes
1 answer
14k views

MySQL "bad handshake" after entering password

I'm having problem to connect to the remote DB from the terminal as follow mysql -u db_user -p -h 10.100.1.100 Enter password: afer entering password I'm getting that error: ERROR 1043 (08S01): Bad ...
user avatar
0 votes
1 answer
2k views

How to replicate particular table in MySQL master-slave configuration?

How do I replicate a particular table in a MySQL master-slave configuration? I have tried replicate-do-table and replicate-wild-do-table. I tried in my.ini file; is there any alternative to replicate ...
user avatar
0 votes
0 answers
115 views

Restoring backup with a MySQL Database downgrade

I want to migrate a MySQL 5.7 database to a MySQL 5.1 version because the MySQL version of the server I’m migrating my WordPress webpage is 5.1. I tried to do it in the usual way but it was not ...
user avatar
2 votes
1 answer
5k views

Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

I'm getting following message: Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' I've tried to follow MySQL :: MySQL 8.0 Reference Manual :: B....
user avatar
  • 565
0 votes
1 answer
40 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 ...
user avatar
  • 105
1 vote
1 answer
207 views

MySQL server 5.1 trigger problem

I have implemented a trigger. But once I try to update the table it is giving me the error: can't update table 'booking' in stored function/trigger because it is already used by the statement which ...
user avatar
  • 11
5 votes
2 answers
181 views

Is there a "soft" ORDER BY / GROUP BY?

SQL-Fiddle http://sqlfiddle.com/#!9/c82c87b/1 Table Definition First of all, this is my table: CREATE TABLE `stackoverflow` ( `id` VARBINARY( 36 ) NOT NULL COMMENT 'GUID generated by PHP', `time` ...
user avatar
0 votes
2 answers
623 views

display numbers with zero pad

I have some data stored as an unsigned tinyint. When displaying it I want it to be zero padded only if it is 1 digit in length. I have issues with LPAD(CAST(NUMBER AS CHAR CHARSET UTF8),2,'0') when ...
user avatar
0 votes
1 answer
609 views

Changes between Mysql version 5.1 TO 5.7

I have recently migrated Mysql 5.1 to Mysql 5.7. DB Migration was successful but when the application started firing few selected queries, Mysql started taking hours to execute them for which ...
user avatar
0 votes
1 answer
4k views

Where should I store a custom ".my.cnf" file?

I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...
user avatar
  • 1,690
1 vote
0 answers
53 views

Optimization Technique For Update Query in MySQL 5.1.73-log

I am trying to optimize an update query on InnoDB table in MySQL 5.1.73-log. As per my understanding we can not use EXPLAIN on update query for 5.1 version. So what will be the alternate course of ...
user avatar
  • 371
0 votes
1 answer
920 views

SELECT multiple columns when using GROUP_CONCAT with UNION

I have a frustrating situation caused by poor database design - unfortunately that part is out of my control. This is the table definition: CREATE TABLE `account` ( `account_no` int(10) unsigned ...
user avatar
2 votes
1 answer
291 views

Chain replication M1 (5.1) -> S1 (5.5) -> S2 (5.6) to limit downtime for an upgrade 5.1 to 5.6

I have to upgrade a production server from 5.1 to 5.6 version. The favourite option would be to dump the database from 5.1 and import on 5.6 but this operation has been estimated to 2 hours on my ...
user avatar
2 votes
1 answer
641 views

MySQL innodb_row_lock_time is more than wall clock time

We recently started graphing the innodb_row_lock_time status variable in our monitoring system. I noticed something I can't understand on a graph for a busy server: Between 04:55PM and 04:57PM, the ...
user avatar
  • 121
1 vote
0 answers
919 views

Unable to delete a MySQL InnoDB table

I am using MySQL 5.1.56 I have a DB with about 70 tables and I have an issue with a particular corrupted table e.g. Table_X When I try to access the table mysql> select * from Table_x; ERROR 1105 (...
user avatar
  • 11
6 votes
2 answers
4k views

MySQL and AUTO_INCREMENT columns in multiple-column index for InnoDB tables: support status?

Missing support for AUTO_INCREMENT columns in multiple-column index for InnoDB tables is a widely known limitation, as is the trigger workaround for when it is needed (see e.g this post). Yesterday, ...
user avatar
0 votes
1 answer
80 views

How to roll back mysql 5.6 to sql 5.1

I recently updated mysql from 5.1 to 5.6 however it's causing too many issues with the websites hosted on my machine. Does anyone know how to remove mysql 5.6 and reinstall version 5.1.
user avatar
  • 101
0 votes
1 answer
70 views

MySQL in RHEL shows different versions

I was given a RHEL 6.9 server with MySQL installed and I just wanted to check the MySQL version running on it. When I tried the rpm -qa | grep mysql or mysql --version or SHOW VARIABLES LIKE "%...
user avatar
  • 147
2 votes
2 answers
2k views

Importing a large mysql dump while replication is running

So we have a simple master/slave mysql replication running between two CentOS Servers. The master has multiple databases. eg.. Database1 Database2 Database3 The issue is we have a mysql dumpfile ...
user avatar
1 vote
1 answer
1k views

Removing InnoDB indexes causes database table almost not accessible and slow [closed]

I have a server with 32GB RAM. I have given almost 70% InnoDB buffer pool to it. I have table with almost 40 million rows. Recently, I tried to remove one of the indexes and replace it with another. ...
user avatar
26 votes
5 answers
129k views

MySQL: How to create Column if not exists?

I am trying to create a Column for my table only if it does not exist. I have researched a lot but I could not find any solution yet. Is this really possible to conditionally create Column ?
user avatar
  • 363
0 votes
2 answers
678 views

Simple, small table (5000 rows) with around 2% slow queries, with high table lock time - context_voluntary and block_ops_out

I am running MySQL version 5.1.69 and the tables in question are MyISAM. I have a very simple table: CREATE TABLE `tbl` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `otherID` int(11) NOT NULL, `...
user avatar
0 votes
1 answer
1k views

Credentials for mysql fail for mysqldump in bash script [closed]

I am having a very strange problem in a script to back up MySQL schemas. The script creates a list of schemas and then runs the mysqldump command for each of them. The credentials are stored in a ...
user avatar
0 votes
2 answers
2k views

MySQL Server Overloaded

I have a MySQL 5.1 server that is struggling. We have too many rows in some of the tables and we do not have enough RAM - currently only 32 GB RAM. I have RAM begin delivered tomorrow, but I ...
user avatar
  • 33
3 votes
2 answers
1k views

Repeatable Read: Which one is correct?

Which one is correct? With transaction 1 as Repeatable Read, other transactions can not update a row after it has been selected by transaction 1. With transaction 1 as Repeatable Read, other ...
user avatar
  • 117
0 votes
2 answers
50 views

Need MySQL configuration options like 'first time'

When I installed MySQL-5.1.49-win32 for the first time I got a window asking 'root password' and 'confirm' in 'mysql server instance configuration wizard'. Now I uninstall the software and install ...
user avatar
1 vote
1 answer
85 views

mysql upgrade 5.0.45 to 5.1.7 and problem query

Have been working on a migration the past few weeks, and we have run into a mysql specific problem. After creating a new VM, faster server than the old, we have a query that takes approx 2 seconds on ...
user avatar
  • 19
0 votes
1 answer
103 views

Importing a mysql database after drop filling up limited / in /tmp deleted file - A problem?

I'm importing a fairly large set of databases into a system which has a / partition only 10GB large. After a previous failed import, I dropped the database, but noticed /var/lib/mysql didn't exactly ...
user avatar
0 votes
1 answer
142 views

MYSQL Password Settings

Is there a command that I could use to check the password settings for MySQL without looking into each account? I'm trying to get password max length, min length, lockout threshold, password history, ...
user avatar
  • 1
0 votes
1 answer
661 views

MYSQL Patching -Roll back

MYSQL patching. I took all database backups before starting patching. If we patch mysql 5.6.30 to 5.6.32 and if we want to rollback to 5.6.30 due to some issues. Can we do that? if so should we have ...
user avatar
  • 1
0 votes
2 answers
1k views

MySQL query using alias to count certain years from DATETIME

I have a table which consists of an ID count, a DATETIME field named orderDate showing when a customer bought an item. I am trying to create a query which takes ID and orderDate, to find all dates ...
user avatar
0 votes
2 answers
3k views

Why is a 'Select distinct limit 100' using tmp tables? [closed]

I hope someone can teach me why MySQL is using temporary tables on a super simple select with a limit of 100 and how to get it do query more efficiently. I'm running MySQL 5.1.53-community. The ...
user avatar
0 votes
1 answer
1k views

Not Able to Increase InnoDB Buffer Pool Size in Mysql

I am facing a very rare problem with my DB. I have Windows Server with 64 GB RAM but I am not able to increase innodb buffer pool size in mysql. Current InnoDb buffer pool Size : 1.6G When I ...
user avatar
1 vote
3 answers
3k views

MYSQL parallel query performance issue

Im working on a project for my company which sells huge amounts of weather data to customers through a Web API. As part of that API, there is a backend service which needs to fetch data from MYSQL ...
user avatar
1 vote
1 answer
169 views

Increasing column from VARCHAR(255) in master/slave setup

We have replication set up on some MyISAM servers, in a master/save scenario, MySQL v5.1. One of the columns is currently declared as VARCHAR(255). We want to increase this to VARCHAR(512). We have ...
user avatar
  • 135
3 votes
2 answers
3k views

count null values of table from information_schema tables

Is there any way to count null values in a column by using information_Schema tables? EG: SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA ='myschema' and ...
user avatar
3 votes
2 answers
479 views

Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex

My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 ...
user avatar
  • 565
0 votes
1 answer
904 views

Mysql slave skipping some updates

I have an existing Mysql 5.1.73 Master/Slave/Slave configuration, which is working correctly and all changes are being replicated. I have now set up a PerconaDB (mysql+galera+XtraDB) 5.6.30 3-node ...
user avatar
1 vote
2 answers
2k views

Mysql Refuses to Start

On HOST OS RHEL 6.5, I upgraded mysql server from 5.1 to 5.7.9. And when i try to start it refuses and give me these messages in Logs 2016-08-01T07:29:42.939712Z mysqld_safe Starting mysqld daemon ...
user avatar

1
2 3 4 5
7