Re: [gentoo-user] mysql upgrade 5.5 > 5.6 mysql_upgrade needed?

2015-04-01 Thread hydra
On Tue, Mar 31, 2015 at 10:27 PM, Marko Weber | 8000 wrote: > > hello list, > again i have to ask. > Do i need to run mysql_upgrade after upgrading mysql 5.5 > 5.6 ? > I ask because the post install text recommend this after an major upgrade. > On the Mysql Website is a major upgrade 5.5 > 6.0, n

Re: [gentoo-user] mysql upgrade 5.5 > 5.6 mysql_upgrade needed?

2015-03-31 Thread Neil Bothwick
On Tue, 31 Mar 2015 22:27:38 +0200, Marko Weber | 8000 wrote: > Do i need to run mysql_upgrade after upgrading mysql 5.5 > 5.6 ? > I ask because the post install text recommend this after an major > upgrade. Do you *need* to? Possibly not. Should you do it? Yes. If you run it unnecessarily, it

[gentoo-user] mysql upgrade 5.5 > 5.6 mysql_upgrade needed?

2015-03-31 Thread Marko Weber | 8000
hello list, again i have to ask. Do i need to run mysql_upgrade after upgrading mysql 5.5 > 5.6 ? I ask because the post install text recommend this after an major upgrade. On the Mysql Website is a major upgrade 5.5 > 6.0, not 5.5 > 5.6 So i ask you guys. Any can help me? thank you marko

[gentoo-user] MySql Upgrade Question (Major Release)

2015-03-12 Thread Marko Weber | 8000
Hi list, the dev-db/mysql will update from 5.5 to 5.6 At the end a post install text tells me i have to fire up mysql_upgrade when this is a major update. On the mysql site i found this 5.5.40 5.x.x is the "major" nr x.5.x is the "release" nr x.x.40 is the "level" of the release so, do i

[gentoo-user] Mysql upgrade from 5.5 to 5.6 not trigger rebuild fot php-5.3

2015-02-19 Thread marco
Hi, i have a server with dev-db/mysql-5.5.40 and dev-lang/php-5.3.29 . After the upgrade from dev-db/mysql-5.5.40 to dev-db/mysql-5.6.22 the mysql_connect give some warnings: PHP Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50540 Library:50622 in

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread kashani
Jeff Smelser wrote: On Wednesday 02 November 2005 05:47 pm, kashani wrote: So yes, if your db is 20 GB or less, what I mentioned will probably work without too much trouble. If your db is 100 GB or larger, you're likely spending enough on hardware and software to solve your issues that s

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread Jeff Smelser
On Wednesday 02 November 2005 05:47 pm, kashani wrote: > Don't think you could have brought up the fact that you're complaining > about the shortcomings of Mysql in an entirely different class than I > and likely the original poster were talking about? I'd have wanted to > know a bit more ab

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread kashani
Jeff Smelser wrote: On Wednesday 02 November 2005 02:23 pm, kashani wrote: Because once you start caring about your db that much it's usually easier to setup a crap box that replicates off your master. Then you can lock the whole db on your slave and do a mysqldump without causing issu

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread Jeff Smelser
On Wednesday 02 November 2005 02:23 pm, kashani wrote: > Because once you start caring about your db that much it's usually > easier to setup a crap box that replicates off your master. Then you can > lock the whole db on your slave and do a mysqldump without causing > issues on your main db

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread kashani
Jeff Smelser wrote: Well, then you would be more interested in mysqlhotcopy.. That pretty much does what your doing.. Mysql INC has yet to make a real backup/restore procedure for mysql. So mysqldump or mysqlhotcopy is pretty much it. If you use innodb, I would go after ibbackup. (not free).

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread Jeff Smelser
On Wednesday 02 November 2005 12:52 pm, C. Beamer wrote: > Up until now, what I needed to do in MySQL, I could do just fine and > never even knew about mysqldump until recently. As I previously stated, > I've only been using Gentoo since September. When I used to use FC4, > all I ever did was ma

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread kashani
C. Beamer wrote: This works and is not a big deal. As I said, I'm just curious if there is a way to fix things so that my database will be backed up properly with the mysqldump process that is run when upgrading. As I also stated, I haven't had the chance to try dumping the existing database al

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread C. Beamer
Jeff Smelser wrote: >On Tuesday 01 November 2005 04:58 pm, C. Beamer wrote: > > > >>The database >>that I had created by creating a directory that was named after the >>database that I had created when using FC4 and then copying my database >>related files into it, did not back up. Hence my ass

Re: [gentoo-user] MySQL Upgrade

2005-11-02 Thread Jeff Smelser
On Tuesday 01 November 2005 04:58 pm, C. Beamer wrote: > A better description would have been that the restore worked. However, > the only database that was restored was the test database. The database > that I had created by creating a directory that was named after the > database that I had cr

Re: [gentoo-user] MySQL Upgrade

2005-11-01 Thread C. Beamer
Hi, Jeff Smelser wrote: >On Sunday 30 October 2005 05:15 pm, C. Beamer wrote: > > > >>The instructions on the Gentoo website for upgrading gave a step by step >>to create a backup of my database. However, when I went to restore the >>database after the upgrade, the restore didn't work. I'm th

Re: [gentoo-user] MySQL Upgrade

2005-11-01 Thread Jeff Smelser
On Sunday 30 October 2005 05:15 pm, C. Beamer wrote: > In September, when I wiped Fedora Core off my main system and installed > Gentoo, I had a MySQL database that I used for one reason and one reason > only. To get my database files from the FC4 system to Gentoo, I just > copied them to a ZIP d

Re: [gentoo-user] MySQL Upgrade

2005-10-30 Thread Qian Qiao
On 10/31/05, C. Beamer <[EMAIL PROTECTED]> wrote: > Qian Qiao wrote: > > > >So the mysqldump you did on the 4.0 didn't dump the databases other > >than test, hmmm. > > > > > > That's correct. And as stated in my original post, I think it might > have something to do with the way I got the database

Re: [gentoo-user] MySQL Upgrade

2005-10-30 Thread C. Beamer
Qian Qiao wrote: >On 10/30/05, C. Beamer <[EMAIL PROTECTED]> wrote: > > >>Qian Qiao wrote: >> >> >>>What was the error message, if it was about the key length exceeding >>>1000, then you hit a known bug. >>> >>> >>> >>> >>No, I didn't get any error messages on restoring the database th

Re: [gentoo-user] MySQL Upgrade

2005-10-30 Thread Qian Qiao
On 10/30/05, C. Beamer <[EMAIL PROTECTED]> wrote: > Qian Qiao wrote: > >What was the error message, if it was about the key length exceeding > >1000, then you hit a known bug. > > > > > No, I didn't get any error messages on restoring the database that was > created by the backup process that was i

Re: [gentoo-user] MySQL Upgrade

2005-10-30 Thread C. Beamer
Qian Qiao wrote: >>The instructions on the Gentoo website for upgrading gave a step by step >>to create a backup of my database. However, when I went to restore the >>database after the upgrade, the restore didn't work. I'm thinking that >>it was because of the way I got my database files into M

Re: [gentoo-user] MySQL Upgrade

2005-10-30 Thread Qian Qiao
On 10/30/05, C. Beamer <[EMAIL PROTECTED]> wrote: > Hi all, > > I just upgraded MySQL using the instructions on the Gentoo website. For > the most part, everything went fine and now everything works, but I had > to make a couple of adjustments. My question now is if there is a > proper way to do

[gentoo-user] MySQL Upgrade

2005-10-30 Thread C. Beamer
Hi all, I just upgraded MySQL using the instructions on the Gentoo website. For the most part, everything went fine and now everything works, but I had to make a couple of adjustments. My question now is if there is a proper way to do what I did as a workaround. In September, when I wiped Fedor