Re: Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
On Tue, 23 Jun 2015 14:51:48 -0400, you wrote: > > >On 6/23/2015 10:59 AM, Steve Matzura wrote: >> I'm building a mail system with Dovecot, Postfix and Mailman with >> MySQL. I have the other three products installed but not yet >> configured. I'll do that after I get MySQL running. >> >> The docu

Re: Post-installation config and startup questions

2015-06-23 Thread shawn l.green
socket '/var/lib/mysql/mysql.sock' (2) Enter current password for root (enter for none): ^C Aborting! Cleaning up... Cleaning up... Warning: Could not unlink .my.cnf.24101: No such file or directory Warning: Could not unlink .mysql.24101: No such file or directory And that's where

Re: Post-installation config and startup questions

2015-06-23 Thread a . smith
Hi Steve, you haven't said what OS you are installing this on or how you have installed MySQL. Normally you would use a version avaialable in your OS distribution as this avoids any overly complicated installation and will manage security and bug patches for you MySQL binaries. Ie insta

Post-installation config and startup questions

2015-06-23 Thread Steve Matzura
I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html was instrument

Re: Slow MySQL Workbench startup

2011-01-09 Thread Felix E. Klee
On Sun, Jan 9, 2011 at 1:54 PM, Yves Goergen wrote: > Why does it take ages for MySQL Workbench to startup? I rarely use MySQL Workbench. But I remember that reducing the maximum number of items in the undo history greatly improves speed, though maybe not startup time. -- MySQL General Mail

Slow MySQL Workbench startup

2011-01-09 Thread Yves Goergen
Hello, Why does it take ages for MySQL Workbench to startup? When I start it (5.2.31 CE) on Windows (XP), the splash screen sits there around 15-30 seconds until the main window appears. There's moderate to high CPU usage in this time and the hard disk is active. I believe this has been

Re: Call a routine on mysqld startup

2009-06-15 Thread Gabriel Linder
On Mon, 15 Jun 2009 10:00:00 -0400 Jim Lyons wrote: > There's an option called "init-file" that will invoke an sql script > on start up. That would probably work for you. Thanks you, that is what I was searching for. I guess I should clean my glasses :) -- MySQL General Mailing List For list

Re: Call a routine on mysqld startup

2009-06-15 Thread Jim Lyons
y related options in mysqld --help --verbose. Is there a > way to achieve this, without modifying the startup script ? > > Thanks in advance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql

Call a routine on mysqld startup

2009-06-15 Thread Gabriel Linder
Hi, I must call a routine when mysqld start (to populate a heap table). I did not find any related options in mysqld --help --verbose. Is there a way to achieve this, without modifying the startup script ? Thanks in advance. -- MySQL General Mailing List For list archives: http

Re: MYSQL startup problem

2008-12-12 Thread Claudio Nanni
11:20:47 InnoDB: Starting shutdown... 080612 11:20:49 InnoDB: Shutdown completed 080612 11:20:49 MySql: Shutdown Complete 080612 11:21:19 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt' socket: '' port: 3306 081212 11:43:44 InnoDB: Started MySql: ready for connections. Ver

Re: MYSQL startup problem

2008-12-12 Thread Grant Allen
l-Lucent, India Email:pooja.ba...@alcatel-lucent.com Phone:+124-413-3078 | Onnet: 2721-3078 From: Chandru [mailto:chandru@gmail.com] Sent: 12 December 2008 13:40 To: BAJAJ POOJA Cc: chaim.rie...@gmail.com; mysql@lists.mysql.com Subject: Re: MYSQL startup

Re: MYSQL startup problem

2008-12-12 Thread Chandru
055) > > C:\wamp\mysql\bin>mysql -u root -p > Enter password: > ERROR 2003: Can't connect to MySQL server on 'localhost' (10055) > > > -- > Thanks & Regards > Pooja Bajaj > Alcatel-Lucent, India > Email:pooja.ba...@alcatel-lucent.com > Phone:+124

RE: MYSQL startup problem

2008-12-12 Thread BAJAJ POOJA
From: Chandru [mailto:chandru@gmail.com] Sent: 12 December 2008 13:40 To: BAJAJ POOJA Cc: chaim.rie...@gmail.com; mysql@lists.mysql.com Subject: Re: MYSQL startup problem Hi, I think you may have to get me the output of netstat -an (this only tells the ports that are all listening). sorry

Re: MYSQL startup problem

2008-12-12 Thread Chandru
...@gmail.com] > Sent: 12 December 2008 13:13 > To: BAJAJ POOJA; Chandru > Cc: mysql@lists.mysql.com > Subject: Re: MYSQL startup problem > > When you do the following > Mysql -h localhost -u root. > What do you get ? > > > Sent via BlackBerry from T-Mobile > >

RE: MYSQL startup problem

2008-12-12 Thread BAJAJ POOJA
-Original Message- From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com] Sent: 12 December 2008 13:13 To: BAJAJ POOJA; Chandru Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem When you do the following Mysql -h localhost -u root. What do you get ? Sent via Bl

RE: MYSQL startup problem

2008-12-12 Thread BAJAJ POOJA
ecember 2008 13:19 To: chaim.rie...@gmail.com Cc: BAJAJ POOJA; mysql@lists.mysql.com Subject: Re: MYSQL startup problem can you check the output of netstat -n or netstat -an and find if port 3306 is listening? Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 1:12 PM, wrote: W

Re: MYSQL startup problem

2008-12-11 Thread Chandru
POOJA" >> >> Date: Fri, 12 Dec 2008 08:43:45 >> To: ; Chandru >> Cc: >> Subject: RE: MYSQL startup problem >> >> >> >> Hi, >> >> It doesn't allows me to telnet port 3306. >> If I ping that port I rec

Re: MYSQL startup problem

2008-12-11 Thread Chandru
erry from T-Mobile > > -Original Message- > From: "BAJAJ POOJA" > > Date: Fri, 12 Dec 2008 08:43:45 > To: ; Chandru > Cc: > Subject: RE: MYSQL startup problem > > > > Hi, > > It doesn't allows me to telnet port 3306. > If I ping that port

Re: MYSQL startup problem

2008-12-11 Thread chaim . rieger
When you do the following Mysql -h localhost -u root. What do you get ? Sent via BlackBerry from T-Mobile -Original Message- From: "BAJAJ POOJA" Date: Fri, 12 Dec 2008 08:43:45 To: ; Chandru Cc: Subject: RE: MYSQL startup problem Hi, It doesn't allows me to t

RE: MYSQL startup problem

2008-12-11 Thread BAJAJ POOJA
gmail.com [mailto:chaim.rie...@gmail.com] Sent: 12 December 2008 13:02 To: BAJAJ POOJA; Chandru Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem It says that is started mysql Can you telnet to port 3306 ? Sent via BlackBerry from T-Mobile -Original Message- From: "BAJAJ POOJA&qu

Re: MYSQL startup problem

2008-12-11 Thread chaim . rieger
It says that is started mysql Can you telnet to port 3306 ? Sent via BlackBerry from T-Mobile -Original Message- From: "BAJAJ POOJA" Date: Fri, 12 Dec 2008 08:27:02 To: Chandru Cc: Subject: RE: MYSQL startup problem Hi, Pls find logs attached below in mail: 08060

RE: MYSQL startup problem

2008-12-11 Thread BAJAJ POOJA
7; socket: '' port: 3306 080612 11:20:47 MySql: Normal shutdown 080612 11:20:47 InnoDB: Starting shutdown... 080612 11:20:49 InnoDB: Shutdown completed 080612 11:20:49 MySql: Shutdown Complete 080612 11:21:19 InnoDB: Started MySql: ready for connections. Version: '4.0.18-nt

RE: MYSQL startup problem

2008-12-11 Thread Shanmugam, Dhandapani
startup problem Hi, By default you can find them in the datadirectory ( the place where you have all your databases stored) Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 12:42 PM, BAJAJ POOJA < pooja.ba...@alcatel-lucent.com> wrote: > Hi Chandru, > > Can you pls. h

Re: MYSQL startup problem

2008-12-11 Thread Chandru
Sent:* 12 December 2008 11:58 > *To:* BAJAJ POOJA > *Cc:* mysql@lists.mysql.com > *Subject:* Re: MYSQL startup problem > > Hi, > > can you please look at the mysql error logs? if you are not able to > figure out the reason, please paste the error log. > > > Re

Re: MYSQL startup problem

2008-12-11 Thread Ananda Kumar
mp; Regards > Pooja Bajaj > Alcatel-Lucent, India > Email:pooja.ba...@alcatel-lucent.com > Phone:+124-413-3078 | Onnet: 2721-3078 > > > > > From: Chandru [mailto:chandru@gmail.com] > Sent: 12 December 2008 11:58 > To: BAJAJ PO

RE: MYSQL startup problem

2008-12-11 Thread BAJAJ POOJA
2008 11:58 To: BAJAJ POOJA Cc: mysql@lists.mysql.com Subject: Re: MYSQL startup problem Hi, can you please look at the mysql error logs? if you are not able to figure out the reason, please paste the error log. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ P

Re: MYSQL startup problem

2008-12-11 Thread Chandru
Hi, can you please look at the mysql error logs? if you are not able to figure out the reason, please paste the error log. Regards, Chandru www.mafiree.com On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA < pooja.ba...@alcatel-lucent.com> wrote: > Hi, > > I am using wamp server version 1.1. >

MYSQL startup problem

2008-12-11 Thread BAJAJ POOJA
Hi, I am using wamp server version 1.1. When I try to start wamp server, It starts apache only, and does not starts mysql service. I tried to start mysql service independently, even that is not possible. Pls. let me know if any solution available. -- Thanks & Regards Pooja Bajaj Alcatel-Lucent,

Startup Item won't install on Mac OS X 10.5.2

2008-04-06 Thread Gabe da Silveira
I was having some problems with MySQL after restoring a new MacBook Pro from a Time Machine backup. I deleted /Library/StartupItems/MYSQLCOM and the corresponding package in /Library/Receipts, however I am unable to reinstall the Startup Item. I've tried both 10.5 packages and the Intel

Re: mysqld startup failure

2007-12-12 Thread jekillen
On Dec 12, 2007, at 8:03 PM, jekillen wrote: On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote: - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "jekillen" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, December 11, 2007 9:12 PM Subject: Re: mysqld s

Re: mysqld startup failure

2007-12-12 Thread jekillen
On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote: - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "jekillen" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, December 11, 2007 9:12 PM Subject: Re: mysqld startup failure jekillen wrote: Hello: Th

Re: mysqld startup failure

2007-12-12 Thread Ken Menzel
- Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "jekillen" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, December 11, 2007 9:12 PM Subject: Re: mysqld startup failure jekillen wrote: Hello: The saga of this machine continues: FreeBSD v6.2 lat

Re: mysqld startup failure

2007-12-11 Thread Chris
jekillen wrote: Hello: The saga of this machine continues: FreeBSD v6.2 latest mysql version installed from ports: mysql51 client, serve, and scripts. There is no /usr/local/mysql it did not create this dir. No idea where it should put the files, a freebsd list might be able to point you in th

mysqlmanager startup scripts for Debian

2007-12-05 Thread Mark Rogers
Where possible I use distro builds of applications (let them worry about security updates and testing, means I don't need build tools on a production server), but all the distros I've checked use their own startup scripts which do not allow me to use mysqlmanager (or even mysqld_mul

mysqld startup failure

2007-11-22 Thread jekillen
Hello: The saga of this machine continues: FreeBSD v6.2 latest mysql version installed from ports: mysql51 client, serve, and scripts. There is no /usr/local/mysql it did not create this dir. the following errors are encountered when attempting to run the server: 071121 15:04:37 mysqld started 0

startup problem on mysql 5.0.45

2007-08-02 Thread MASSIMO PETRINI
After a shutdown regular on my mysql master, when the mysql process startup apper the error below 070802 16:07:08 [Warning] The syntax for replication startup options is deprecat ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 070802 16:07:

Re: 5.0.37 hangs on startup

2007-03-14 Thread James Green
rting? Cheers, James James Green wrote: > Hi, > > I've upgraded from 5.0.26 to 5.0.37, both compiled from same source > options, and the newer release crashes on startup. > > 5.0.26 Appears fine on all counts. > 5.0.37 Appears to start without innodb switched on, but mys

5.0.37 hangs on startup

2007-03-14 Thread James Green
Hi, I've upgraded from 5.0.26 to 5.0.37, both compiled from same source options, and the newer release crashes on startup. 5.0.26 Appears fine on all counts. 5.0.37 Appears to start without innodb switched on, but mysql clients just hang, and you cannot stop it without several "killall

Re: mysqld_multi startup stop

2006-10-22 Thread Atle Veka
Sounds like you need to configure a user that has SHUTDOWN privileges. From: http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html Make sure that the MySQL account used for stopping the mysqld servers (with the mysqladmin program) has the same username and password for each server. Also, make

mysqld_multi startup stop

2006-10-21 Thread Low Kian Seong
Dear all, I am running the official mysql rpms on a sles 9 box, and I am running multiple versions of mysql servers on different ports. The problem I am facing is that when i run mysqld_multi start it starts the servers up fine but when i do the reverse : mysqld_multi stop , it doesn't stop

Re: startup in OS-X

2006-10-06 Thread Rahul S. Johari
Usually mysql is located at /usr/local/mysql in the terminal window. Using Terminal, get to /usr/local/mysql/bin 'ls' will give you the list of files in the folder Try ./mysqld_safe > On 10/6/06, Chris Elhardt <[EMAIL PROTECTED]> wrote: >> apologize for the newbie question. >> >> installed myS

Re: startup in OS-X

2006-10-06 Thread obed
On 10/6/06, Chris Elhardt <[EMAIL PROTECTED]> wrote: apologize for the newbie question. installed mySQL 4 some time ago, and just played around with it in terminal. Now that I really need to learn some database, I can't get it to start in terminal. it autostarts; I can see it in the activity m

Re: startup in OS-X

2006-10-05 Thread Dan Buettner
Chris, what autostarts is likely the server, 'mysqld' (for mysql daemon). What you need to start to access the server is a client, 'mysql'. What command are you issuing? just mysql at the terminal prompt? It seems odd I know, especially to long-time Mac users, but the operating system may just

startup in OS-X

2006-10-05 Thread Chris Elhardt
apologize for the newbie question. installed mySQL 4 some time ago, and just played around with it in terminal. Now that I really need to learn some database, I can't get it to start in terminal. it autostarts; I can see it in the activity monitor as a background process. but when I try

How to set "User" variables (not system/session ones) at database startup

2006-08-09 Thread Asif Lodhi
Hi, I want to set certain _user_ variables, which I will create myself, at the database startup time so that all clients can use the values stored [only one time at the beginning] in those variables instead of computing the same each time in triggers or other code. It's just like the pa

Re: Code snippet to run at database service startup

2006-08-07 Thread Daniel da Veiga
On 8/7/06, Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi, What if I want certain variables initialized and certain code to run at the database service startup? I am running 5.0.22 on Windows XP Service Pack 2. Are there any tirggers that can tell me that the database is starting up? Y

Code snippet to run at database service startup

2006-08-07 Thread Asif Lodhi
Hi, What if I want certain variables initialized and certain code to run at the database service startup? I am running 5.0.22 on Windows XP Service Pack 2. Are there any tirggers that can tell me that the database is starting up? -- Thanks in advance, Asif -- MySQL General Mailing List For

mysqld running at 100% after being accessed in startup script

2006-07-18 Thread Stuart Brooks
Hi, I have a strange problem. I am running mysqld (5.0.20) on NetBSD 3.0 and after the startup scripts are complete the mysqld process ramps up to 100% utilization. However this only happens if I make mysql calls from within the startup scripts. If I wait until the startup scripts have completed

RE: MySQL service startup time

2006-07-05 Thread Bartis, Robert M (Bob)
- From: Rob Desbois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 11:51 AM To: mysql@lists.mysql.com Subject: MySQL service startup time Hi, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when

Re: MySQL service startup time

2006-07-05 Thread Jeremy Cole
Hi Rob, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in th

MySQL service startup time

2006-07-05 Thread Rob Desbois
Hi, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in the ins

ndbd --initial startup issues in mysql cluster

2006-05-02 Thread Pradeep Chandru
hi, i am trying to install a cluster. i am facing issues in starting up the ndbd. My configuration is as follows. *Config.ini:* [NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management n

Re: innodb errors on startup

2006-03-29 Thread Heikki Tuuri
Marten, - Original Message - From: "Marten Lehmann" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, March 29, 2006 7:52 PM Subject: Re: innodb errors on startup Well, ok, we need to stress this more in the manual. A few users have misunders

Re: innodb errors on startup

2006-03-29 Thread Marten Lehmann
error on startup doesn't appear any more? Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb errors on startup

2006-03-29 Thread Heikki Tuuri
way it happened, but it may have the same result. Since the dictionary only has problems with some certain databases, we simply created a new databases and restored the db-dump into it. So the databases are mostly working, but the errors on startup appear anyhow. Regards Marten Best r

Re: innodb errors on startup

2006-03-29 Thread Marten Lehmann
xed. Thats not exactly the way it happened, but it may have the same result. Since the dictionary only has problems with some certain databases, we simply created a new databases and restored the db-dump into it. So the databases are mostly working, but the errors on startup appear anyhow

Re: innodb errors on startup

2006-03-28 Thread Heikki Tuuri
php - Original Message - From: "Marten Lehmann" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, March 28, 2006 7:49 PM Subject: innodb errors on startup Hello, I'm getting this in my errorlog: 060328 18:43:45 mysqld ended 060328 18:43:46 mysqld

innodb errors on startup

2006-03-28 Thread Marten Lehmann
Hello, I'm getting this in my errorlog: 060328 18:43:45 mysqld ended 060328 18:43:46 mysqld started 060328 18:43:46 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember

Re: changing the UNIX user for mysql server startup

2005-12-08 Thread Remo Tex
Perumal, Jai wrote: Hi, We install the mysql version 5.0.16 on Linux Red hat as the root operating system user. After the install we changed the ownership and group to a mysql UNIX user. We tested starting and stopping the mysql server using the mysql UNIX user account and it worked fine.

changing the UNIX user for mysql server startup

2005-12-08 Thread Perumal, Jai
Hi, We install the mysql version 5.0.16 on Linux Red hat as the root operating system user. After the install we changed the ownership and group to a mysql UNIX user. We tested starting and stopping the mysql server using the mysql UNIX user account and it worked fine. But when we reboot t

Re: mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)

2005-12-07 Thread Gleb Paharenko
Hello. > seems to put the socket file in the wrong place- (should be in /tmp) Your running copy of mysqld has --socket==/var/lib/mysql/mysql.sock argument. Perhaps mysqld_safe puts it by default or reads from [mysqld_safe] or [mysqld] sections of configuration file. Specify the value of so

mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)

2005-12-07 Thread Dan Gahlinger
Description: mysql will not create /tmp/mysql.sock at first it would not create /var/run/mysql/mysqld.pid - I manually created the /var/run/mysql and set permissions, and it works. now i have problems with the socket file - it wont create it How-To-Repeat: bin/mysqld_safe --user=mysql & ./b

Re: minimum processes at startup

2005-11-30 Thread Gleb Paharenko
Hello. > CONNECT_PRIOR is the right value? Sorry, but right value for what? It is not number of threads, it is priority. > It was only for example. MySQL 4.* has only one(!) thread/process. > Why? MySQL 5 has more again. Did you make your experiments on the same machine or different,

Re: minimum processes at startup

2005-11-28 Thread Gleb Paharenko
Hello. > CONNECT_PRIOR is the right value? Sorry, but "right value" for what? It is not a number of threads, it is priority. > It was only for example. MySQL 4.* has only one(!) thread/process. > Why? MySQL 5 has more again. Did you make your experiments on the same machine or differe

Re: minimum processes at startup

2005-11-27 Thread Ondrej Koala Vacha
On Fri, 25 Nov 2005, Gleb Paharenko wrote: > Hello. > > > I have mysql 3.23.55 without innodb and it has one process, with innodb > > it starts with 16 processes. > > Information about MySQL threads is available here: > http://dev.mysql.com/doc/internals/en/threads.html CONNECT_PRIOR is the r

Re: minimum processes at startup

2005-11-25 Thread Gleb Paharenko
pgrade. Ondrej Koala Vacha wrote: > > Hi, > > is it possible to control how many processes/therads mysqld starts at > startup? > I have mysql 3.23.55 without innodb and it has one process, with innodb > it starts with 16 processes. > > MySQL manual: &g

minimum processes at startup

2005-11-25 Thread Ondrej Koala Vacha
Hi, is it possible to control how many processes/therads mysqld starts at startup? I have mysql 3.23.55 without innodb and it has one process, with innodb it starts with 16 processes. MySQL manual: Section 2.12.1.1. Linux Operating System Notes ... When using LinuxThreads, you should see a

RE: Startup Error

2005-09-20 Thread Andy Eastham
n tomcat write into this? Andy _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: 20 September 2005 12:00 To: 'Andy Eastham' Subject: RE: Startup Error [EMAIL PROTECTED] mysql]# ls -l /usr/local/mysql lrwxrwxrwx1 root root 40 Sep 19

RE: Startup Error

2005-09-19 Thread Johnson, Richard (NY Int)
ubject: RE: Startup Error Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell

RE: Startup Error

2005-09-19 Thread J.R. Bullington
To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 05091

Re: Startup Error

2005-09-19 Thread Michael Stassen
Johnson, Richard (NY Int) wrote: Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid

RE: Startup Error

2005-09-19 Thread J.R. Bullington
Check your <>.err logs located in the /data/ directory. This will tell you why you can't start the server. J.R. -Original Message- From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 10:38 AM To: 'mysql@lists.mysql.com' Subje

Startup Error

2005-09-19 Thread Johnson, Richard (NY Int)
Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919

Re: Too many Mysql processes at startup after upgrade to 4.1.14

2005-09-16 Thread Kishore Jalleda
ng this behaviour even earlier with 4.0.17 when the > server > > > > >just started but after a certain point the no of processes return to > normal. > > > > > So I had to switch back to 4.0.x, and it works perfectly fine, Also I > did > > > > >n

Re: Too many Mysql processes at startup after upgrade to 4.1.14

2005-09-16 Thread Chris Allen
just started but after a certain point the no of processes return to normal. > > > So I had to switch back to 4.0.x, and it works perfectly fine, Also I did > > >not dump the databases just zipped the old datadir and unzipped it into the > > >new datadir, anybody else expe

Re: Too many Mysql processes at startup after upgrade to 4.1.14

2005-09-16 Thread Gleb Paharenko
o normal. > So I had to switch back to 4.0.x, and it works perfectly fine, Also I did >not dump the databases just zipped the old datadir and unzipped it into the >new datadir, anybody else experience this behaviour at startup( I am aware >that once the server is back online it is

Too many Mysql processes at startup after upgrade to 4.1.14

2005-09-15 Thread Kishore Jalleda
behaviour at startup( I am aware that once the server is back online it is flooded with requests), the OS is Redhat 7.3, the server currently does 200-400 qps quiet comfortably . Any help would be appreciated, let me know if you need more info Kishore Jalleda

Re: Anyone knows what happens at mysqladmin startup time?

2005-09-08 Thread Eric Bergen
It appears that mysqld is not listening on /tmp/mysql.sock. Log into mysql and run show variables like 'socket'; This will tell you where mysqld is actually listening for socket connections. Then update your my.cnf files so they all have the same sock file location as the one that mysqld is li

Anyone knows what happens at mysqladmin startup time?

2005-09-08 Thread 王静
hi all, here is the suituation i've installed mysql4.1.14 under the /usr/local directory. the problem is, the server can work properly, however, mysqladmin doesn't. i posted it yesterday, and someone suggested me to issue the following command, however the same error 111 occured. #mysqladmin -uroo

Re: INNODB memory allocation error during startup

2005-09-06 Thread Bruce Dembecki
We see that error when we go above the memory limits of a 32 bit operating system. When we run a 64 bit binary on our 64 bit hardware we can allocate more memory and it fires up fine. I'm a Mac guy so your string of letters and numbers describing your hardware and MySQL version don't mean m

INNODB memory allocation error during startup

2005-09-02 Thread eddie
Hello kind sirs, I have a DL380 G4 box, Dual Xeon 3.0Ghz with 6GB of DDR2 Ram, I'm Linux CentOS 4 with a 2.6.12.5 vanilla kernel, and a remote storage which I access via iSCSI (linux-iscsi-4.0.2 complied as a module) connected with two Gigabit interfaces. the 'balancing' between the two links

Startup with Error

2005-08-02 Thread Nguyen, Phong
when I startup I got error like Innodb: error: log file .\ib_logfile (0,1) is different size Innodb: than specifiled in the .cnf file 050729: {eror} can't init database 050729:{error} aborting . Could you please tell me why? Thank youNguyen -- MySQL General Mailing List For

Re: looking for a pure startup opportunity..

2005-07-03 Thread Hank
even if you could get 10 million in funding, you think you and your partner get to walk away with 5 million each? That's not how it works. They invest that money into the COMPANY, and expect YOU to turn 10 million into at least 50 million. They also OWN YOU during that time - it's no cakewal

Re: looking for a pure startup opportunity..

2005-06-27 Thread Sebastian
if that was the case it would easy to be a millionaire.. spam or scam... it's all the same.. bruce wrote: hi... i'm out here in california, the bay area, and was wondering if anyone on the list is interested in either being partners, forming a sweat equity startup? or if anyone h

looking for a pure startup opportunity..

2005-06-27 Thread bruce
hi... i'm out here in california, the bay area, and was wondering if anyone on the list is interested in either being partners, forming a sweat equity startup? or if anyone has an idea/concept, and you're looking for people to be part of your team... i've read way too many artic

Re: limit the number of startup process

2005-06-23 Thread Gleb Paharenko
Hello. I don't know such an option. However, in my opinion, max_connections variable could be helpful. See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html [EMAIL PROTECTED] wrote: > Hi > > i like to imit te number of process at startup: >

limit the number of startup process

2005-06-23 Thread zdust
Hi i like to imit te number of process at startup: "/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/" but i couldn t find the option thx all -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

limit the number of startup process

2005-06-23 Thread zdust
Hi i like to imit te number of process at startup: "/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/" but i couldn t find the option thx all -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld_multi at startup on Mac OS X not working

2005-04-14 Thread Bruce Dembecki
# exit > % mysqld_multi report > Reporting MySQL servers > MySQL server from group: mysqld4 is running > MySQL server from group: mysqld5 is running > % > > However, I can't get this to work at system startup time. Starting up > a single mysql server works fine, with the

mysqld_multi at startup on Mac OS X not working

2005-04-08 Thread Jan Pieter Kunst
ever, I can't get this to work at system startup time. Starting up a single mysql server works fine, with the following /Library/StartupItems/MySQL/MySQL script: #!/bin/sh . /etc/rc.common if [ "${MYSQL:=-YES-}" = "-YES-" ]; then ConsoleMessage "Starting MySQL dat

Re: mysql 4.0.18 crashing on startup

2005-03-04 Thread Baba Buehler
PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, March 02, 2005 6:32 PM Subject: mysql 4.0.18 crashing on startup I've got a customer with a mysql that is crashing on startup. MySQL is 4.0.18 with InnoDB tables on a Linux 2.4.26 system. MySQL binaries are Linux x86 glibc static gcc from mysql.c

Re: mysql 4.0.18 crashing on startup

2005-03-03 Thread Heikki Tuuri
6:32 PM Subject: mysql 4.0.18 crashing on startup I've got a customer with a mysql that is crashing on startup. MySQL is 4.0.18 with InnoDB tables on a Linux 2.4.26 system. MySQL binaries are Linux x86 glibc static gcc from mysql.com Can anyone divine what might have happened to cau

mysql 4.0.18 crashing on startup

2005-03-02 Thread Baba Buehler
I've got a customer with a mysql that is crashing on startup. MySQL is 4.0.18 with InnoDB tables on a Linux 2.4.26 system. MySQL binaries are Linux x86 glibc static gcc from mysql.com Can anyone divine what might have happened to cause this? thanks, baba resolve_stack_dump gives: 0x80

Loading data on startup

2005-02-25 Thread gunmuse
I need to copy data from TABLE A to TABLE B(Memory Table) on MySql startup or restart.   MySql --init-file on startup is obviously something I need to use could I get an example of what a sql would look like to start the memory table and completely copy data from table A. ThanksDonny

Re: mysql 4.1.7 startup fails cannot write a tmp file to /root/tmp

2004-11-19 Thread Spenser
I dug around the archives for this list and I found the message below from September (http://lists.mysql.com/mysql/172458) ...here is what Marko Makela told me about your situation: It's probably from innobase_mysql_tmpfile(), which is called two or three> times at startup. That functio

Re: mysql 4.1.7 startup fails cannot write a tmp file to /root/tmp

2004-11-19 Thread Spenser
files with > > > 'tmpdir' server system variable. > > > in: > > > http://dev.mysql.com/doc/mysql/en/Temporary_files.html > > > http://dev.mysql.com/doc/mysql/en/Server_system_variables.html > > > > > > So I tried this advice by pu

Re: mysql 4.1.7 startup fails cannot write a tmp file to /root/tmp

2004-11-19 Thread Spenser
So I tried this advice by putting the following line In /etc/my.cnf in > the [mysqld] section: > tmpdir = /usr > However, it still wants to write to /root/tmp at startup with a > strangely named file (the filename changes with each startup). > > I have done mysqla

mysql 4.1.7 startup fails cannot write a tmp file to /root/tmp

2004-11-19 Thread Gail Lange
, it still wants to write to /root/tmp at startup with a strangely named file (the filename changes with each startup). I have done mysqladmin variables and nothing is listed as related to /root/tmp. Is there some startup variable that I am missing? Thanks, Gail -- MySQL General Mailing Lis

Re: Cloned machine mysql startup problem with innodb

2004-10-26 Thread Heikki Tuuri
Paul, - Original Message - From: "Paul W" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, October 25, 2004 11:33 AM Subject: Cloned machine mysql startup problem with innodb For backup purposes I have what amounts to a complete clone of a live se

Cloned machine mysql startup problem with innodb

2004-10-25 Thread Paul W
from /var/lib/mysql? Could I just delete libdata1? As to the line saying I should edit innodb_data_file_path back to what it was - I have no idea what it was :-( I'm after the simplest way to get it started, the rest is easy. from the startup errors: InnoDB: Error: data file /var/

  1   2   3   4   >