search for: mysql_upgrade

On 28.04.2016 17:58, Lamar Owen wrote: > On 04/28/2016 08:45 AM, Sergio Belkin wrote: >> I've found some issues upgrading mysql, some people recommends run >> mysql_upgrade. I wonder why such a script is not run from scriptlet of >> mysql-server rpm. > Back in the Dark Ages of the PostgreSQL RPMset (PostgreSQL 6.5), early > in my time as RPM maintainer for the community PostgreSQL.org RPMset, I > asked a very similar question of some folks, and I got a...

Hi, I've found some issues upgrading mysql, some people recommends run mysql_upgrade. I wonder why such a script is not run from scriptlet of mysql-server rpm. Thanks in advance -- -- Sergio Belkin LPIC-2 Certified - http://www.lpi.org

Hello, after I updated from mysql-5.0.22 CentOS 5.0 to mysqld-5.0.45 in CentOS 5.2, mysql looses master-slave sync after one node reboots. I've noticed that the slave doest not respect the informantion on master.info, instead, it tries to read the informantion from the master server file inc-index.index. Let me give a example, the master is alredy on incremental.000006 and the

Hi, There has been update to mysql within the centosplus repository on 26th August. Please be aware, that you might need to upgrade tables after the server upgrade. 1) run CHECK TABLE .... 2) if the response is 'Table upgrade required. Please do "REPAIR TABLE `tablename`" to fix it!' 3) do run :o) REPAIR TABLE 4) good point is again CHECK TABLE 4) good point is OPTIMIZE TABLE

...mysql mysql-devel mysql-server' When I try and start MySQL I get: 120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120206 16:42:07 InnoDB: Started; log sequence number 0 44233 120206 16:42:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 120206 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended if I go look in...

...plugin-connect, python-mysqldb and alembic packages (alembic does not work when installed via pip). Additionally - since MariaDB by default does not have a root user password set and running mysql -u root requires sudo as well - you need to execute the following: sudo mysql_secure_installation sudo mysql_upgrade -p --force So far so good. I run into problems when running alembic when I get to the following change: e96a0b8071c_increase_pjsip_column_size.py mariadb fails this operation with error "Specified key was too long; max key length is 767 bytes" when it tries to increase some fields to var...

On 04/28/2016 08:45 AM, Sergio Belkin wrote: > I've found some issues upgrading mysql, some people recommends run > mysql_upgrade. I wonder why such a script is not run from scriptlet of > mysql-server rpm. Back in the Dark Ages of the PostgreSQL RPMset (PostgreSQL 6.5), early in my time as RPM maintainer for the community PostgreSQL.org RPMset, I asked a very similar question of some folks, and I got a canonical answer...

...install centos-release-scl $ sudo yum install rh-mariadb101 $ scl enable rh-mariadb101 bash At this point you should be able to use mariadb just as a normal application. Here are some examples of commands you can run: $ systemctl start rh-mariadb101-mariadb $ mysql $ mysql_upgrade In order to view the individual components included in this collection, you can run: $ sudo yum list rh-mariadb101\* Last but not least you can try this Software Collection in Docker. You can pull the image with the following command: $ sudo docker pull centos/mariadb-101-centos7 F...

Hi I am migrating a mailserver from CentOS 4 to 5 and i am migrating the db's over from mysql-max-4.1.13 to mysql-server-5.0.45-7.el5 during the mysql import it fails with this... ERROR 1062 (23000) at line 129: Duplicate entry '3-r????' for key 1 anyone got any clues to this one as so far i have drawn a blank thanks

...and alembic > packages (alembic does not work when installed via pip). > Additionally - since MariaDB by default does not have a root user password > set and running mysql -u root requires sudo as well - you need to execute > the following: > sudo mysql_secure_installation > sudo mysql_upgrade -p --force > > So far so good. I run into problems when running alembic when I get to the > following change: > https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_ > increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjs > CUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfff...

...m install centos-release-scl $ sudo yum install rh-mariadb101 $ scl enable rh-mariadb101 bash At this point you should be able to use mariadb just as a normal application. Here are some examples of commands you can run: $ service rh-mariadb101-mariadb start $ mysql $ mysql_upgrade In order to view the individual components included in this collection, you can run: $ sudo yum list rh-mariadb101\* For more on MariaDB in general, see https://mariadb.org. About Software Collections -------------------------- Software Collections give you the power to build, install, an...

...m install centos-release-scl $ sudo yum install rh-mariadb101 $ scl enable rh-mariadb101 bash At this point you should be able to use mariadb just as a normal application. Here are some examples of commands you can run: $ service rh-mariadb101-mariadb start $ mysql $ mysql_upgrade In order to view the individual components included in this collection, you can run: $ sudo yum list rh-mariadb101\* For more on MariaDB in general, see https://mariadb.org. About Software Collections -------------------------- Software Collections give you the power to build, install, an...

..._ to remove the data directories.) 3. yum remove mysql mysql-server (again, it will include a few things I don't want removed. so, i'll have to use rpm -e --nodeps and list the packages for removal then issue yum clean all.' 4. yum install mysql51 5. start mysql service 6. run command mysql_upgrade... (here's where things start getting fuzzy) Question #1: is this command to be run from the commandline or should I log into mysql as root user and run the command? Question #2: at this point I will have mysql 5.1 installed and running but to get up to 5.5 am I expected to yum r...

Todor Petkov wrote: >> I'm running CentOS-7, but I left some MySQL databases >> on my old CentOS-6.5 partition which I'd like to retrieve. >> I assume they are contained in the file /var/lib/mysql/ibdata1 ? >> >> Could I just copy this file to /var/lib/mysql in CentOS-7? >> Or is there some way Mariadb or phpMyAdmin can import mysql databases >>

...m install centos-release-scl $ sudo yum install rh-mariadb101 $ scl enable rh-mariadb101 bash At this point you should be able to use mariadb just as a normal application. Here are some examples of commands you can run: $ service rh-mariadb101-mariadb start $ mysql $ mysql_upgrade In order to view the individual components included in this collection, you can run: $ sudo yum list rh-mariadb101\* For more on MariaDB in general, see https://mariadb.org. About Software Collections -------------------------- Software Collections give you the power to build, install, an...