search for: mysql_upgrade

Displaying 15 results from an estimated 15 matches for "mysql_upgrade".

2016 Apr 28
1
About 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...
2016 Apr 28
4
About mysql upgrade
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
2009 Feb 09
2
Problems with mysql multi-master after update.
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
2009 Aug 28
1
mysql-server-5.0.82sp1-1.el4_8 upgrade
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
2012 Feb 07
1
MySQL on CentOS 6 broken? No 'mysql' database?
...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...
2017 Jul 12
2
Asterisk realtime - Error with index length in alembic script
...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...
2016 Apr 28
0
About mysql upgrade
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...
2016 Jul 19
0
Announcing release of MariaDB 10.1 on CentOS Linux 7 x86_64 SCL
...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...
2008 Oct 30
2
mysql 4 > 5 export import issue
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
2017 Jul 12
2
Asterisk realtime - Error with index length in alembic script
...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...
2016 Jul 19
2
Announcing release of MariaDB 10.1 on CentOS Linux 6 x86_64 SCL
...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...
2016 Jul 19
2
Announcing release of MariaDB 10.1 on CentOS Linux 6 x86_64 SCL
...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...
2017 Mar 19
4
upgrading Mysql 5.0.95
..._ 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...
2015 May 29
3
Using Mariadb databases from old server
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 >>
2016 Jul 19
0
CentOS-announce Digest, Vol 137, Issue 6
...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...