Stack Overflow
Stack Overflow

Questions tagged [mysqlupgrade]

Questions related to the command `mysql_upgrade` which will migrate the data from one version to another version.

29 questions
52
votes
3 answers

How do I update MySQL 5.7 to the new MySQL 8.0?

How do I update to MySQL 8.0 from the default version (5.7)? It's important for me for it to make an update and not re-install MySQL so all my data won't be corrupt. There is not a lot of info regarding this issue since it was only released not…
Imnotapotato
  • 5,308
  • 13
  • 80
  • 147
20
votes
6 answers

mysql_upgrade failed - innodb tables doesn't exist?

I am upgrading my mysql-5.5 docker container database to mysql-5.6 docker container. I was able to fix all other problems. Finally my server is running with 5.6. But when i run mysql_upgrade i am getting the following…
Gangaraju
  • 4,406
  • 9
  • 45
  • 77
11
votes
4 answers

How to update mysql version in xampp (error with innodb_additional_mem_pool_size)

I'm trying to upgrade mysql in xamp. I'm using laravel which requires mariaDB v10.2.2. So I downloaded the latest msi package from the mariaDB website. Now I followed following points to install the same: Install MySQL to C:\TEMP. Make old…
Nitish Kumar
  • 6,054
  • 21
  • 82
  • 148
9
votes
1 answer

Upgrade MySQL 5.6 to 5.7

I'm quite new to MySQL and learning fast. I installed WAMP on my system and have been using it for a month or so. I'm looking to upgrade MySQL to 5.7 as I will be in need of the new gis features but I can't find a easy to follow step by step on what…
Paul
  • 328
  • 1
  • 5
  • 17
2
votes
1 answer

AWS RDS MySQL replication from 5.6 to 5.7 during the upgrade process

Context Hi all, we are about to upgrade our AWS RDS MySQL instance from MySQL 5.6 to MySQL 5.7. To do so, we are planning to go through the following steps Create a read replica of the primary instance Upgrade the read replica version from 5.6 to…
Lonny Chetrit
  • 21
  • 2
2
votes
0 answers

HI mysql update

HI I want to change the first name to grouocho if name is harpo and last name is Williamns other vise I want to change to Mocho Groucho where first name is Harpo. When I run my code it gives me Error 1175 You are using safe update mode and you…
sinan cengiz
  • 21
  • 5
1
vote
1 answer

How to Update Shopware to Version 6.5 Using Dockware Container

I have already installed Shopware 6.4 using Dockware through the docker-compose.yml file. Now, I'm aiming to upgrade Shopware to version 6.5. However, I've encountered a challenge: Shopware 6.4 uses MySQL 5.7, while Shopware 6.5 requires MySQL 8. In…
saber seyyedi
  • 13
  • 3
1
vote
1 answer

How to speed up altering storage engine and DB export/import in MySQL

I have a MySQL database with around 250GB of data running on Linux platform (12GB Ram). I am upgrading MySQL to 8.0.32 from 5.7.42-1 and to do so, altering one of the largest table with partitioning and MyISAM storage engine in my DB. Here is the…
Dams
  • 47
  • 7
1
vote
1 answer

mysql_upgrade via queries

is there a way of detecting if I need to run mysql_upgrade without having access to the command-line so to the tool mysql_upgrade or mysql_check? I need a way that uses SQL-statements or something like that
user14389193
1
vote
2 answers

Update to MySQL 5.7 and high disk space consumption

Using: MySQL 5.6 on Debian 9, total DB size is around 450Gb Updated to 5.7, ran mysql_upgrade, noticed that around 150 GB has been taken up. 2 tables are really large and they stayed in 'copying to tmp table' for a couple of hours Noticed…
carrieandrsn
  • 11
  • 1
1
vote
0 answers

Upgrade thousand for mysql 5.7 databases to latest 8.0 version

We are having thousands of mysql databases (v 5.7) and want to upgrade to latest v8.0. We have configured new mysql on same sarver with diff port (say 3307). we tried multiple steps Replacing mysql5.7/data directory to mysql8.0/data gives an error…
Prasad
  • 19
  • 1
  • 6
1
vote
1 answer

MAMP fails to upgrade mysql databases

When I run MAMP, it asks me to upgrade mysql databases and once I click okay, I get Warning: Using a password on the command line interface can be insecure. Looking for 'mysql' as: /Applications/MAMP/Library/bin/mysql Looking for 'mysqlcheck' as:…
Limpuls
  • 856
  • 1
  • 19
  • 37
1
vote
1 answer

How to repair mysql.user table?

I am starting mysql-5.6 server with mysql-5.5 data. I am getting the following error. I can't start server for running mysql_upgrade Error: 2016-06-14 11:07:54 5827 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-06-14 11:07:54 5827…
Gangaraju
  • 4,406
  • 9
  • 45
  • 77
0
votes
0 answers

update mysql from a sql file

Im new to the php and mysql. I have been coding an auto update script. Everything works fine as I can download the latest version files from my own host which includes of the sql file of mysql. All I want to do an update due to this sql file. What I…
Emre GOKTEPE
  • 1
  • 2
0
votes
1 answer

MySQL issue: columns set to DEFAULT = CURRENT_TIMESTAMP got overwritten during sql import, on entire database

A couple of months ago I migrated to another mysql server, and I did an export and import through the phpMyAdmin web interface. I just realized that I just lost all the "creation dates" for multiple tables, as they all got overwritten with what I…
Merricat
  • 2,583
  • 1
  • 19
  • 27
1
2