Re: Mysql backup on Google Drive

2022-09-28 Thread Tim Woodall
On Wed, 28 Sep 2022, Remigio wrote: ... The package rclone can do this. unfortunately I can't find Rclone package Furter information? Thanks Wild guess, but lenny probably predates google drive so rclone won't be present unless you can backport. (someone can check the dates but IIRC lenny u

Re: Mysql backup on Google Drive

2022-09-28 Thread Махно
Hello. Rclone is in official Debian repo. Just check this https://packages.debian.org/bullseye/rclone 2022-09-28, tr, 14:48 Remigio rašė: > > ... > > The package rclone can do this. > unfortunately I can't find Rclone package > Furter information? > Thanks >

Re: Mysql backup on Google Drive

2022-09-28 Thread Remigio
... > The package rclone can do this. unfortunately I can't find Rclone package Furter information? Thanks

Re: Mysql backup on Google Drive

2022-09-28 Thread Dan Ritter
Remigio wrote: > Hi everyone, > I've been using a mysql database for a long time, that runs on a Debian 5 > Lenny machine. Using "cron" I locally backup it and overwrite every hour, > and I manually backup it every week on a usb pen. > I'm wondering if it's possible to automatically send the .s

Re: Mysql failed

2016-11-17 Thread Cindy-Sue Causey
On 11/16/16, Tony van der Hoff wrote: > Hi, > > I've just discovered that MySQL on my jessie desktop box has died > unexpectedly. I'm pretty sure it was working 3/4 days ago. > > > tony@tony-lx:~$ mysql -p > Enter password: > ERROR 2002 (HY000): Can

Re: Mysql failed

2016-11-16 Thread Tony van der Hoff
On 16/11/16 16:10, Joe wrote: On 16/11/2016 15:48, Tony van der Hoff wrote: The following packages have unmet dependencies: mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.50-0+deb8u1) but it is not going to be installed PreDepends: mysql-common (>= 5.5.50-0+deb8u1) bu

Re: Mysql failed

2016-11-16 Thread Joe
On 16/11/2016 15:48, Tony van der Hoff wrote: The following packages have unmet dependencies: mysql-server-5.5 : Depends: mysql-client-5.5 (>= 5.5.50-0+deb8u1) but it is not going to be installed PreDepends: mysql-common (>= 5.5.50-0+deb8u1) but it is not going to be install

Re: mysql broken after jessie upgrade

2016-09-22 Thread Cindy-Sue Causey
On 9/22/16, Tony van der Hoff wrote: > > Running Jessie here. Performed apt-get upgrade yesterday, which included > a new version of mysql. > > I now cannot connect to mysql: > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (2) > > Any sugges

Re: SOLVED Re: mysql broken after jessie upgrade

2016-09-22 Thread Liam O'Toole
On 2016-09-22, Tony van der Hoff wrote: > On 22/09/16 16:59, Greg Wooledge wrote: >> On Thu, Sep 22, 2016 at 04:02:37PM +0200, Tony van der Hoff wrote: >>> Running Jessie here. Performed apt-get upgrade yesterday, which included >>> a new version of mysql. >> >>> It turns out that the rec

Re: SOLVED Re: mysql broken after jessie upgrade

2016-09-22 Thread Tony van der Hoff
On 22/09/16 16:59, Greg Wooledge wrote: > On Thu, Sep 22, 2016 at 04:02:37PM +0200, Tony van der Hoff wrote: >> Running Jessie here. Performed apt-get upgrade yesterday, which included >> a new version of mysql. > >> It turns out that the recent upgrade took mysql from 5.5 to 5.6. It >> un

Re: SOLVED Re: mysql broken after jessie upgrade

2016-09-22 Thread Greg Wooledge
On Thu, Sep 22, 2016 at 04:02:37PM +0200, Tony van der Hoff wrote: > Running Jessie here. Performed apt-get upgrade yesterday, which included > a new version of mysql. > It turns out that the recent upgrade took mysql from 5.5 to 5.6. It > uninstalled mysql-server-5.5, but failed to inst

Re: SOLVED Re: mysql broken after jessie upgrade

2016-09-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Sep 22, 2016 at 04:02:37PM +0200, Tony van der Hoff wrote: [...] > It turns out that the recent upgrade took mysql from 5.5 to 5.6. It > uninstalled mysql-server-5.5, but failed to install mysql-server-5.6, > due to an unmet dependency on mys

SOLVED Re: mysql broken after jessie upgrade

2016-09-22 Thread Tony van der Hoff
On 22/09/16 13:59, to...@tuxteam.de wrote: > On Thu, Sep 22, 2016 at 01:07:49PM +0200, Tony van der Hoff wrote: >> On 22/09/16 12:56, to...@tuxteam.de wrote: >>> On Thu, Sep 22, 2016 at 12:43:18PM +0200, Tony van der Hoff wrote: Hi, >>> Running Jessie here. Performed apt-get upgrade yeste

Re: mysql broken after jessie upgrade

2016-09-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Sep 22, 2016 at 01:07:49PM +0200, Tony van der Hoff wrote: > On 22/09/16 12:56, to...@tuxteam.de wrote: > > On Thu, Sep 22, 2016 at 12:43:18PM +0200, Tony van der Hoff wrote: > >> Hi, > > > >> Running Jessie here. Performed apt-get upgrade yes

Re: mysql broken after jessie upgrade

2016-09-22 Thread Tony van der Hoff
On 22/09/16 12:56, to...@tuxteam.de wrote: > On Thu, Sep 22, 2016 at 12:43:18PM +0200, Tony van der Hoff wrote: >> Hi, > >> Running Jessie here. Performed apt-get upgrade yesterday, which included >> a new version of mysql. > >> I now cannot connect to mysql: >> ERROR 2002 (HY000): Can't connect

Re: mysql broken after jessie upgrade

2016-09-22 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Sep 22, 2016 at 12:43:18PM +0200, Tony van der Hoff wrote: > Hi, > > Running Jessie here. Performed apt-get upgrade yesterday, which included > a new version of mysql. > > I now cannot connect to mysql: > ERROR 2002 (HY000): Can't connect to

Re: MySQL access denied for user

2016-08-15 Thread Florian Pelgrim
Hi, I assume that you installed mysql from repository and did not alter the configuration. Login with root into mysql and then: 1. create your drupal database # create database drupal; 2. create a user account for it # create user 'drupal_user'@'localhost' IDENTIFIED BY 'some_random_stuff_here'

Re: MySQL access denied for user

2016-08-15 Thread limpia
On 2016-08-15 04:54, Liam O'Toole wrote: On 2016-08-15, Bill Wohler wrote: I'm getting the following: $ mysql -h localhost -u user Enter password: ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) This user was created with a fresh installation

Re: MySQL access denied for user

2016-08-15 Thread Liam O'Toole
On 2016-08-15, Bill Wohler wrote: > I'm getting the following: > > $ mysql -h localhost -u user > Enter password: > ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using > password: YES) > > This user was created with a fresh installation of mysql as (mysql) root > wit

Re: MySQL access denied for user

2016-08-15 Thread Joe
On Sun, 14 Aug 2016 22:17:12 -0700 Bill Wohler wrote: > Bill Wohler wrote: > > > I'm getting the following: > > > > $ mysql -h localhost -u user > > Enter password: > > ERROR 1045 (28000): Access denied for user > > 'user'@'localhost' (using password: YES) > > > > This user was c

Re: MySQL access denied for user

2016-08-14 Thread Bill Wohler
Bill Wohler wrote: > I'm getting the following: > > $ mysql -h localhost -u user > Enter password: > ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using > password: YES) > > This user was created with a fresh installation of mysql as (mysql) root > with the follow

Re: Mysql Access Problems after Jessie Upgrade

2015-05-10 Thread Alan Chandler
On 10/05/15 18:58, Alan Chandler wrote: I don't think this is a mythtv problem. All other aspects of it appear to be working with its local database connection. The fact that mysql --host=owl.home --user=mythtv --password=xx mythconverg is the problem means its the database connection

Re: Mysql Access Problems after Jessie Upgrade

2015-05-10 Thread Alan Chandler
On 10/05/15 18:29, Brad Rogers wrote: On Sun, 10 May 2015 18:17:27 +0100 Alan Chandler wrote: Hello Alan, The plot thickens - After working during the week, I came to view Mythtv again today and it is refusing connection to the database again. The following may, or may not, be of use to you

Re: Mysql Access Problems after Jessie Upgrade

2015-05-10 Thread Brad Rogers
On Sun, 10 May 2015 18:17:27 +0100 Alan Chandler wrote: Hello Alan, >The plot thickens - After working during the week, I came to view >Mythtv again today and it is refusing connection to the database again. The following may, or may not, be of use to you (taken from the Debian Multimedia maili

Re: Mysql Access Problems after Jessie Upgrade

2015-05-10 Thread Alan Chandler
On 04/05/15 11:51, Bernhard Schmidt wrote: Alan Chandler wrote: Hi, Do you have /etc/hosts.allow / hosts.deny non-standard? Both appear empty (other than comments) So I added a line ALL: 127.0.0. 192.168.0. to /etc/hosts.allow and everything started working again Not sure if I need to

Re: Mysql Access Problems after Jessie Upgrade

2015-05-04 Thread Bernhard Schmidt
Alan Chandler wrote: Hi, >>> Do you have /etc/hosts.allow / hosts.deny non-standard? >> >> Both appear empty (other than comments) > > > So I added a line > > ALL: 127.0.0. 192.168.0. > > to /etc/hosts.allow > > and everything started working again > > Not sure if I need to include the 127.0.0 t

Re: Mysql Access Problems after Jessie Upgrade

2015-05-04 Thread Alan Chandler
On 03/05/15 23:00, Alan Chandler wrote: On 03/05/15 19:59, Bernhard Schmidt wrote: Do you have /etc/hosts.allow / hosts.deny non-standard? Both appear empty (other than comments) So I added a line ALL: 127.0.0. 192.168.0. to /etc/hosts.allow and everything started working again Not su

Re: Mysql Access Problems after Jessie Upgrade

2015-05-03 Thread Alan Chandler
On 03/05/15 19:59, Bernhard Schmidt wrote: Alan Chandler wrote: Hi Alan, Today I am having database connection problems. Using mysql client to connect to my server "owl.home" mysql --host=owl.home --user=mythtv --password=XX mythconverg ERROR 2013 (HY000): Lost connection to MySQL se

Re: Mysql Access Problems after Jessie Upgrade

2015-05-03 Thread Bernhard Schmidt
Alan Chandler wrote: Hi Alan, > Today I am having database connection problems. > > Using mysql client to connect to my server "owl.home" > > mysql --host=owl.home --user=mythtv --password=XX mythconverg > ERROR 2013 (HY000): Lost connection to MySQL server at 'reading > authorization pac

Re: mysql command waiting endlessly (lenny)

2014-09-18 Thread berenger . morel
Le 17.09.2014 18:09, Don Armstrong a écrit : On Wed, 17 Sep 2014, berenger.mo...@neutralite.org wrote: Le 17.09.2014 17:33, Don Armstrong a écrit : >In the future, these details would be helpful. I have said in my first post: > but when it connect through the mysql program, there is no promp

Re: mysql command waiting endlessly (lenny)

2014-09-17 Thread Don Armstrong
On Wed, 17 Sep 2014, berenger.mo...@neutralite.org wrote: > Le 17.09.2014 17:33, Don Armstrong a écrit : > >In the future, these details would be helpful. > > I have said in my first post: > > > but when it connect through the mysql program, there is no prompt. > >Through the odbc program (isql),

Re: mysql command waiting endlessly (lenny)

2014-09-17 Thread berenger . morel
Le 17.09.2014 17:33, Don Armstrong a écrit : On Wed, 17 Sep 2014, berenger.mo...@neutralite.org wrote: Le 16.09.2014 19:46, Don Armstrong a écrit : >Most likely, you've created a configuration where the machine in >question is unable to access 3306. I do not think so, since the isql command (

Re: mysql command waiting endlessly (lenny)

2014-09-17 Thread Don Armstrong
On Wed, 17 Sep 2014, berenger.mo...@neutralite.org wrote: > Le 16.09.2014 19:46, Don Armstrong a écrit : > >Most likely, you've created a configuration where the machine in > >question is unable to access 3306. > > I do not think so, since the isql command (which uses odbc driver) > works, and is

Re: mysql command waiting endlessly (lenny)

2014-09-17 Thread berenger . morel
Le 16.09.2014 19:46, Don Armstrong a écrit : On Tue, 16 Sep 2014, berenger.mo...@neutralite.org wrote: On a old lenny, we have a software which have to connect to a server of the same LAN (we do not have physical access to any stuff, and we can only connect through ssh to that client computer

Re: mysql command waiting endlessly (lenny)

2014-09-16 Thread Don Armstrong
On Tue, 16 Sep 2014, berenger.mo...@neutralite.org wrote: > On a old lenny, we have a software which have to connect to a server of the > same LAN (we do not have physical access to any stuff, and we can only > connect through ssh to that client computer), but when it connect through > the mysql pr

Re: mysql command waiting endlessly (lenny)

2014-09-16 Thread Chris Bannister
On Tue, Sep 16, 2014 at 04:08:23PM +0200, berenger.mo...@neutralite.org wrote: > Hello. Hi, [...] > Does someone have any idea about what could be the problem, and/or how to > fix it? I suggest you'd be better off asking on a mysql support list, but be prepared to be flamed for not providing en

Re: mysql re-instate debian-sys-maint user [SOLVED]

2014-07-18 Thread Tony van der Hoff
On 18/07/14 17:23, Tony van der Hoff wrote: > I seem to have lost my debian-sys-maint user on mysql-server. I had > expected to be able to run dpkg-reconfigure mysql-server, but that does > nothing obvious. > > Any suggestions, please as to how to correctly recover this user and > password and per

Re: Mysql database dump quit working

2014-04-24 Thread John W. Foster
On Wed, 2014-04-23 at 22:13 +0100, Steve wrote: > > I have a mediawiki site running on Mysql db; I just started getting this > > message on my automated backup; > > > > mysqldump: Got error: 144: Table './mywiki/searchindex' is marked as > > crashed and last (automatic?) repair failed when using

Re: Mysql database dump quit working

2014-04-23 Thread Steve
> I have a mediawiki site running on Mysql db; I just started getting this > message on my automated backup; > > mysqldump: Got error: 144: Table './mywiki/searchindex' is marked as > crashed and last (automatic?) repair failed when using LOCK TABLES The table is marked as crashed, and an autom

Re: Mysql database dump quit working

2014-04-23 Thread Henning Follmann
On Wed, Apr 23, 2014 at 10:33:34AM -0500, John Foster wrote: > I have a mediawiki site running on Mysql db; I just started getting this > message on my automated backup; > > mysqldump: Got error: 144: Table './mywiki/searchindex' is marked as > crashed and last (automatic?) repair failed when usin

Re: Re: MySQL slow and high load with Debian Wheezy (was: [whole mail text])

2013-09-07 Thread Daniel Enright
Found this thread searching for a solution to my problem (which sounds similar). My solution was barrier=0 in /etc/fstab see https://wiki.archlinux.org/index.php/Ext4 Uh, specifically my problem was that loading large mysql files took forever and would often end with mysql losing the connecti

Re: Mysql

2013-08-10 Thread The_Ace
On Thu, Aug 1, 2013 at 2:48 AM, Ethan Rosenberg, PhD wrote: > Dear List - > > This is a combined answer to your questions... > > > > #deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD > Binary-1 20110322-15:11]/ squeeze contrib main > > #deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_

Re: Mysql

2013-07-31 Thread Ethan Rosenberg, PhD
Dear List - This is a combined answer to your questions... #deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD Binary-1 20110322-15:11]/ squeeze contrib main #deb cdrom:[Debian GNU/Linux 6.0.1a _Squeeze_ - Official i386 DVD Binary-2 20110322-15:11]/ squeeze contrib main deb htt

Re: Mysql

2013-07-31 Thread lina
On Wednesday 31,July,2013 03:32 AM, Ethan Rosenberg, PhD wrote: > Dear List - > > I attempted an upgrade and now > > Connect Error (2002) Can't connect to local MySQL server through > socket '/var/run/mysqld/mysqld.sock' (2 > > From bad to worse!!! Before your upgrading, mysql function well? A

Re: Mysql

2013-07-31 Thread Dom
On 31/07/13 06:18, Ethan Rosenberg, PhD wrote: root@meow:/home/ethan# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if yo

Re: Mysql

2013-07-30 Thread Ethan Rosenberg, PhD
On Wed, 2013-07-31 at 00:23 -0400, Ethan Rosenberg, PhD wrote: Now that we have established that mysql is not running, how to I restart it? Doesn't it work, if you follow the Debian Wiki? https://wiki.debian.org/MySql It's the second hit when searching for debian start mysql by Google.de

Re: Mysql

2013-07-30 Thread Ralf Mardorf
On Wed, 2013-07-31 at 06:35 +0200, Ralf Mardorf wrote: > On Wed, 2013-07-31 at 00:23 -0400, Ethan Rosenberg, PhD wrote: > > Now that we have established that mysql is not running, how to I restart it? > > Doesn't it work, if you follow the Debian Wiki? > > https://wiki.debian.org/MySql > > It's

Re: Mysql

2013-07-30 Thread Ralf Mardorf
On Wed, 2013-07-31 at 00:23 -0400, Ethan Rosenberg, PhD wrote: > Now that we have established that mysql is not running, how to I restart it? Doesn't it work, if you follow the Debian Wiki? https://wiki.debian.org/MySql It's the second hit when searching for debian start mysql by Google.de a

Re: Mysql

2013-07-30 Thread Ethan Rosenberg, PhD
On 30/07/13 21:30, Ralf Mardorf wrote: On Tue, 2013-07-30 at 16:16 -0400, Ethan Rosenberg, PhD wrote: Is the MySQL server running? ps aux | grep mysql ---> ethan@meow:~$ ps aux | grep mysql ethan 3043 0.0 0.0 3300 772 pts/0S+ 13:12 0:00 grep mysql<-- ps aux does show all r

Re: Mysql

2013-07-30 Thread Ralf Mardorf
On Tue, 2013-07-30 at 21:40 +0100, Dom wrote: > > On Tue, 2013-07-30 at 16:16 -0400, Ethan Rosenberg, PhD wrote: > >> ethan 3043 0.0 0.0 3300 772 pts/0S+ 13:12 0:00 grep > >> mysql<-- > > > Process 3043 in this case is the grep command from ps aux | grep mysql. Sorry, true. I re

Re: Mysql

2013-07-30 Thread Dom
On 30/07/13 21:30, Ralf Mardorf wrote: On Tue, 2013-07-30 at 16:16 -0400, Ethan Rosenberg, PhD wrote: Is the MySQL server running? ps aux | grep mysql ---> ethan@meow:~$ ps aux | grep mysql ethan 3043 0.0 0.0 3300 772 pts/0S+ 13:12 0:00 grep mysql<-- ps aux does show all r

Re: Mysql

2013-07-30 Thread staticsafe
On Tue, Jul 30, 2013 at 04:16:45PM -0400, Ethan Rosenberg, PhD wrote: > On 7/30/2013 3:32 PM, Ethan Rosenberg, PhD wrote: > >Dear List - > > > >I attempted an upgrade and now > > > >Connect Error (2002) Can't connect to local MySQL server through > >socket '/var/run/mysqld/mysqld.sock' (2 > > > > F

Re: Mysql

2013-07-30 Thread Ralf Mardorf
On Tue, 2013-07-30 at 16:16 -0400, Ethan Rosenberg, PhD wrote: > Is the MySQL server running? > > ps aux | grep mysql > > ---> ethan@meow:~$ ps aux | grep mysql > ethan 3043 0.0 0.0 3300 772 pts/0S+ 13:12 0:00 grep > mysql <-- ps aux does show all running processes ;). 3043 i

Re: Mysql

2013-07-30 Thread Ethan Rosenberg, PhD
On 7/30/2013 3:32 PM, Ethan Rosenberg, PhD wrote: Dear List - I attempted an upgrade and now Connect Error (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 From bad to worse!!! TIA Ethan Is the MySQL server running? ps aux | grep mysql ---> et

Re: Mysql

2013-07-30 Thread Jerry Stuckle
On 7/30/2013 3:32 PM, Ethan Rosenberg, PhD wrote: Dear List - I attempted an upgrade and now Connect Error (2002) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 From bad to worse!!! TIA Ethan Is the MySQL server running? ps aux | grep mysql If not,

Re: MySQL slow and high load with Debian Wheezy (was: [whole mail text])

2013-05-24 Thread Martin Steigerwald
Hi Andrei, How could that KMail can answer from the subject if marked, but I strongly second Lisi´s notion of putting a legible text into the mail body and using a fine descriptive and short enough subject for the mail. Am Donnerstag, 23. Mai 2013, 11:15:29 schrieb Andrei Hristow: > Hi, I have

Re: mysql-server 64 bit on a 32 bit lenny

2012-09-06 Thread Stan Hoeppner
On 9/5/2012 11:17 PM, Bob Proulx wrote: > I don't think knowing more about the kernel will help. Especially now > that you pointed out the 32-bit userland and wanting a 64-bit mysql. > That seems the critical point. I tend to agree. At this point I'm thinking his best option may be installing a

Re: mysql-server 64 bit on a 32 bit lenny

2012-09-05 Thread Bob Proulx
Stan Hoeppner wrote: > Bob Proulx wrote: > > Roland RoLaNd wrote: > >> i have 32 bit lenny running. ( i cannot upgrade) > >> i need to install mysql-server-5.1 amd64 on it. > >> This system is already running l 64 bit kernel. > >> > >> i can't seem to find that package in any current repo so i'm >

Re: mysql-server 64 bit on a 32 bit lenny

2012-09-05 Thread Stan Hoeppner
On 9/5/2012 12:11 AM, Bob Proulx wrote: > Roland RoLaNd wrote: >> i have 32 bit lenny running. ( i cannot upgrade) >> i need to install mysql-server-5.1 amd64 on it. >> This system is already running l 64 bit kernel. >> >> i can't seem to find that package in any current repo so i'm >> thinking of

Re: mysql-server 64 bit on a 32 bit lenny

2012-09-05 Thread Camaleón
On Wed, 05 Sep 2012 07:20:30 +0300, Roland RoLaNd wrote: (please, no html posts, thanks) > i have 32 bit lenny running. ( i cannot upgrade) i need to install > mysql-server-5.1 amd64 on it. (...) And the compelling reason for doing so is...? (just curious) Greetings, -- Camaleón -- To UNS

Re: mysql-server 64 bit on a 32 bit lenny

2012-09-04 Thread Bob Proulx
Roland RoLaNd wrote: > i have 32 bit lenny running. ( i cannot upgrade) > i need to install mysql-server-5.1 amd64 on it. > This system is already running l 64 bit kernel. > > i can't seem to find that package in any current repo so i'm > thinking of force installing it using dpkg but i don't kno

Re: MySQL stored procedure slow with recent Wheezy upgrade

2012-06-08 Thread Chen Gang
Hi I encounter exactly same problem, default configuration shipped by package cannot resolve the problem. Gang -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/CAOZ7

Re: MySQL stored procedure slow with recent Wheezy upgrade

2012-06-04 Thread hvw59601
Daniel Kraft wrote: On 04/06/12 20:24, Daniel Kraft wrote: On 04/06/12 16:23, hvw59601 wrote: Daniel Kraft wrote: Hi, I'm running Wheezy, and a recent update to MySQL made a database application much, much slower. The query performed is a stored procedure containing some loops, which before

Re: MySQL stored procedure slow with recent Wheezy upgrade

2012-06-04 Thread Daniel Kraft
On 04/06/12 20:24, Daniel Kraft wrote: > On 04/06/12 16:23, hvw59601 wrote: >> Daniel Kraft wrote: >>> Hi, >>> >>> I'm running Wheezy, and a recent update to MySQL made a database >>> application much, much slower. The query performed is a stored >>> procedure containing some loops, which before (

Re: MySQL stored procedure slow with recent Wheezy upgrade

2012-06-04 Thread Daniel Kraft
On 04/06/12 16:23, hvw59601 wrote: > Daniel Kraft wrote: >> Hi, >> >> I'm running Wheezy, and a recent update to MySQL made a database >> application much, much slower. The query performed is a stored >> procedure containing some loops, which before (at least on 24th May) >> took less than one sec

Re: MySQL stored procedure slow with recent Wheezy upgrade

2012-06-04 Thread hvw59601
Daniel Kraft wrote: Hi, I'm running Wheezy, and a recent update to MySQL made a database application much, much slower. The query performed is a stored procedure containing some loops, which before (at least on 24th May) took less than one second, and now (today) more than four minutes. I didn

Re: MySQL upgrade from 5.1 to 5.5

2012-05-26 Thread Camaleón
On Fri, 25 May 2012 11:06:01 -0400, Brad Alexander wrote: > I did an upgrade on my mediawiki box the other day to fix some security > issues. Well, in the mix, mysql-common was upgraded from > mysql-common_5.1.62-1 to mysql-common 5.5.23+dfsg-1. Nothing happened > until last night when we took a p

Re: Re: MySQL 4.0 (sarge) --> MySQL 5.0 (etch) -- Please do "REPAIR TABLE"

2012-05-09 Thread Karl E. Jorgensen
Hi On Wed, May 09, 2012 at 08:04:11AM +0100, Rajeev tyagi wrote: > Dera Tech, > > > i m not able to see innodb table on mysql database can you pls help me out Difficult to help without more details How are you attempting to "see" the table? (e.g. what SQL statement?) Which error do you ge

Re: Re: MySQL 4.0 (sarge) --> MySQL 5.0 (etch) -- Please do "REPAIR TABLE"

2012-05-09 Thread Rajeev tyagi
Dera Tech, i m not able to see innodb table on mysql database can you pls help me out Thanks & regards Rajeev

Re: MySQL seems to be running too slow; LONG

2012-05-07 Thread Camaleón
On Sun, 06 May 2012 20:54:31 -0500, John W. Foster wrote: > On Sun, 2012-05-06 at 14:09 +, Camaleón wrote: >> (...) >> >> It seems the script did a good job by telling you what's what you can >> tweak. Have you made any of the recommended changes? > actually I made all the suggested changes

Re: MySQL seems to be running too slow; LONG

2012-05-06 Thread John W. Foster
On Sun, 2012-05-06 at 14:09 +, Camaleón wrote: > On Sat, 05 May 2012 13:26:33 -0500, John W. Foster wrote: > > > I got this output from mysqltuner: > > Any advice is appreciated: The main issues is that this db server > > handles a Mediawiki database and when I upload files it takes way to >

Re: MySQL seems to be running too slow; LONG

2012-05-06 Thread Camaleón
On Sat, 05 May 2012 13:26:33 -0500, John W. Foster wrote: > I got this output from mysqltuner: > Any advice is appreciated: The main issues is that this db server > handles a Mediawiki database and when I upload files it takes way to > long to do its job likewise when serving up the data to produc

Re: mySQL workbench

2012-05-05 Thread Camaleón
On Sat, 05 May 2012 18:15:36 +0100, Tony van der Hoff wrote: > On 05/05/12 18:08, Camaleón wrote: >>> Well, I tried. Dozens of missing dependencies. Since my source build >>> works fine, I abandoned that idea ;) >> >> Fair decision. But I bet you also had to install a bunch of packages to >> get

Re: mySQL workbench

2012-05-05 Thread Tony van der Hoff
On 05/05/12 18:08, Camaleón wrote: On Sat, 05 May 2012 17:52:22 +0100, Tony van der Hoff wrote: On 05/05/12 16:13, Camaleón wrote: There's a Ubuntu deb. Did you mean that? Yep, that one. I saw it, but I'm always a bit suspicious of 'buntu things! Will it work? I have not tried but I ca

Re: mySQL workbench

2012-05-05 Thread Camaleón
On Sat, 05 May 2012 17:52:22 +0100, Tony van der Hoff wrote: > On 05/05/12 16:13, Camaleón wrote: >>> There's a Ubuntu deb. Did you mean that? >> >> Yep, that one. >> >>> I saw it, but I'm always a bit suspicious of 'buntu things! Will it >>> work? >> >> I have not tried but I can't see why not :

Re: mySQL workbench

2012-05-05 Thread Tony van der Hoff
On 05/05/12 16:13, Camaleón wrote: On Sat, 05 May 2012 16:09:10 +0100, Tony van der Hoff wrote: On 05/05/12 14:58, Camaleón wrote: On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: Sadly, MySQL workbench doesn't appear to be available as a Debian package, It is... since wheezy :

Re: mySQL workbench

2012-05-05 Thread Camaleón
On Sat, 05 May 2012 16:09:10 +0100, Tony van der Hoff wrote: > On 05/05/12 14:58, Camaleón wrote: >> On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: >> >>> Sadly, MySQL workbench doesn't appear to be available as a Debian >>> package, >> >> It is... since wheezy :-) >> >>> so I'm tryi

Re: mySQL workbench

2012-05-05 Thread Tony van der Hoff
On 05/05/12 14:58, Camaleón wrote: On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: Sadly, MySQL workbench doesn't appear to be available as a Debian package, It is... since wheezy :-) so I'm trying to build it from source. There's a deb file available upstream. Did you try wi

Re: mySQL workbench

2012-05-05 Thread Camaleón
On Sat, 05 May 2012 16:27:58 +0200, Sven Joachim wrote: > On 2012-05-05 15:58 +0200, Camaleón wrote: > >> On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: >> >>> Part way through the configure script, I get the error: >>> ---

Re: mySQL workbench

2012-05-05 Thread Tony van der Hoff
On 05/05/12 15:27, Sven Joachim wrote: On 2012-05-05 15:58 +0200, Camaleón wrote: On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: Part way through the configure script, I get the error: - checking for CAIRO... config

Re: mySQL workbench

2012-05-05 Thread Sven Joachim
On 2012-05-05 15:58 +0200, Camaleón wrote: > On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: > >> Part way through the configure script, I get the error: >> - >> checking for CAIRO... configure: error: Package requirement

Re: mySQL workbench

2012-05-05 Thread Camaleón
On Sat, 05 May 2012 14:17:47 +0100, Tony van der Hoff wrote: > Sadly, MySQL workbench doesn't appear to be available as a Debian > package, It is... since wheezy :-) > so I'm trying to build it from source. There's a deb file available upstream. Did you try with that? > Part way through the c

Re: mysql tuning - need recommendation

2011-12-28 Thread J. Bakshi
On Wed, 28 Dec 2011 15:15:52 +0330 hamed hosseini wrote: > hi, i cant help you,but i like your work,can you tell me and show me how > can create webserver? > i have i7 and 4 GB ram. > note:i have install mysql and phpmyadmin and apache,but i am new in > linux,and i want create webserver. > > On

Re: mysql tuning - need recommendation

2011-12-28 Thread hamed hosseini
hi, i cant help you,but i like your work,can you tell me and show me how can create webserver? i have i7 and 4 GB ram. note:i have install mysql and phpmyadmin and apache,but i am new in linux,and i want create webserver. On Wed, Dec 28, 2011 at 3:10 PM, J. Bakshi wrote: > Dear list, > > Let me

Re: mysql workbench

2011-12-01 Thread Gilles Mocellin
Le jeudi 01 décembre 2011 08:53:22 J. Bakshi, vous avez écrit : > Dear list, > > How can I benchmark the mysql server in debian squeeze box ? > Any tools in debian or any 3rd party shell script ? > > The mysql is performing very bad and I need to boost its performance. > This is a new box with 8

Re: mysql workbench

2011-12-01 Thread J. Bakshi
On Thu, 1 Dec 2011 10:05:37 +0200 Michel Blankleder wrote: > On Thursday, December 01, 2011 09:53:22 J. Bakshi wrote: > > Dear list, > > > > How can I benchmark the mysql server in debian squeeze box ? > > Any tools in debian or any 3rd party shell script ? > > > > The mysql is performing very

Re: mysql workbench

2011-12-01 Thread Michel Blankleder
On Thursday, December 01, 2011 09:53:22 J. Bakshi wrote: > Dear list, > > How can I benchmark the mysql server in debian squeeze box ? > Any tools in debian or any 3rd party shell script ? > > The mysql is performing very bad and I need to boost its performance. > This is a new box with 8 GB RAM

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-11 Thread Joey L
On Fri, Oct 7, 2011 at 5:49 PM, Walter Hurry wrote: > On Fri, 07 Oct 2011 16:17:23 -0400, Joey L wrote: > >> with replication - in case of a failure - I have to manually cut it over >> to the replicated files ??? >> is there any hot-standby feature ??? >> thanks mjh > > Hints: If you want help: >

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-07 Thread Walter Hurry
On Fri, 07 Oct 2011 16:17:23 -0400, Joey L wrote: > with replication - in case of a failure - I have to manually cut it over > to the replicated files ??? > is there any hot-standby feature ??? > thanks mjh Hints: If you want help: a) Write in English; start sentences with a capital letter. b) D

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-07 Thread Joey L
with replication - in case of a failure - I have to manually cut it over to the replicated files ??? is there any hot-standby feature ??? thanks mjh On Thu, Oct 6, 2011 at 3:25 PM, rfsf...@gmail.com wrote: > You may want to setup replication or cluster. Replication is a standard > feature of mysq

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-06 Thread Gilles Mocellin
Le 06/10/2011 20:49, Joey L a écrit : Would I have to use NFS ??? is there a better solution for High Availability ?? I think iscsi only attaches a network storage device to the server for writing/reading but this will not solve the issue of who owns the db at what time ??? Is mysql 5 come with h

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-06 Thread rfsf...@gmail.com
You may want to setup replication or cluster. Replication is a standard feature of mysql. Cluster is in mysql-cluster package available at mysql.com site. Would I have to use NFS ??? is there a better solution for High Availability ?? I think iscsi only attaches a network storage device to the

Re: MySQL High Availability on Debian - using Iomega StorCenter ix-2 nas device.

2011-10-06 Thread Joey L
Would I have to use NFS ??? is there a better solution for High Availability ?? I think iscsi only attaches a network storage device to the server for writing/reading but this will not solve the issue of who owns the db at what time ??? Is mysql 5 come with high availibity option included or is thi

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Camaleón
On Thu, 05 May 2011 11:13:14 -0700, Abraham wrote: >> logrotate? >> >> > That's the only thing I could find that might be doing it as I went > through the cron files. > In the /etc/logrotate.d/mysql-server file there is a /usr/bin/mysqladmin > flush-logs command that is probably being run which wo

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Abraham
> > >> > logrotate? > > That's the only thing I could find that might be doing it as I went through the cron files. In the /etc/logrotate.d/mysql-server file there is a /usr/bin/mysqladmin flush-logs command that is probably being run which would probably restart the server?

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Bob McConnell
Abraham wrote: Does anyone know why a MySQL Server would be automatically rebooting at midnight? I never set it to reboot and can't find an option to change this. I've also searched online and can't find an answer. Any ideas? Rebooting? Is the mysqld process restarting at midnight, or is the wh

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Abraham
> > > Does anyone know why a MySQL Server would be automatically rebooting at > > midnight? I never set it to reboot and can't find an option to change > > this. I've also searched online and can't find an answer. Any ideas? > > > > Rebooting? Is the mysqld process restarting at midnight, or is the

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Mihira Fernando
On 05/05/2011 09:08 PM, Abraham wrote: Does anyone know why a MySQL Server would be automatically rebooting at midnight? I never set it to reboot and can't find an option to change this. I've also searched online and can't find an answer. Any ideas? Much appreciated! Abraham The janitor a

Re: MySQL Server Rebooting Automatically?

2011-05-05 Thread Jari Fredriksson
5.5.2011 18:38, Abraham kirjoitti: > Does anyone know why a MySQL Server would be automatically rebooting at > midnight? I never set it to reboot and can't find an option to change > this. I've also searched online and can't find an answer. Any ideas? > Rebooting? Is the mysqld process restarting

Re: mysql replication problem, after upgrade squeeze

2011-02-23 Thread Boyd Stephen Smith Jr.
On Wednesday 23 February 2011 17:04:01 Dev Newsletter wrote: > the last months I used the squeeze (testing), Squeeze isn't testing anymore. Squeeze was released 2011-02-06 and is not stable. Wheezy is testing. If you have listed "testing" in your sources.list... > today I have done a aptitude

  1   2   3   4   5   >