Date computation in MySQL PHP
Hi All, I want to know how do I use computations on dates in php or mysql like for example, today is September 13, 2003 (2003-09-13) and I want to get the date output if I add 5 days from the given date so that my output would be September 18, 2003 (2003-09-18). And if any given day falls on a Sunday, it will be moved to Monday. I just want to disregard Sunday and want to use Monday to Saturday. Anyone who can help me will be appreciated. Regards, Delz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
Does the installation of the PKG itself finish successful? No problems installing the files, the PKG works fine and everything is as it should be in /usr/local/ It's essential to start up mysqld before you continue with using mysqladmin. When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Cheers, Andy -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
connection error
I have created a user grant all privileges on *.* to user@% =identified by ' pword' with grant option; and grant all privileges on *.* to [EMAIL PROTECTED] =identified by ' pword' with grant option; but when I try and connect through mysql client(DBTools) on remote PC I get the 'access denied for user: [EMAIL PROTECTED]' (using password:yes). According to the manual I should have created a user who can connect from anywhere as well as from localhost. I don't understand why this isn't working. using mysql version 4.0.14 RH 9.0 DBtools pro on win2k Network connection is fine. Any help appreciated. Bob
Re: OS X Installation and Setup
Hi, It could be a permission problem on /tmp and/or mysql data directory. OR You have not mysql internal tables (host, user, etc) in data/mysql. Try to open a file named (yourhost).err in data directory and see why mysql ended. Santino Does the installation of the PKG itself finish successful? No problems installing the files, the PKG works fine and everything is as it should be in /usr/local/ It's essential to start up mysqld before you continue with using mysqladmin. When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Cheers, Andy -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connection error
Robert, On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote: I have created a user grant all privileges on *.* to user@% =identified by ' pword' with grant option; and grant all privileges on *.* to [EMAIL PROTECTED] =identified by ' pword' with grant option; Did you actually use a space in ' pword' ? You could try changing it to a password without a space in it. but when I try and connect through mysql client(DBTools) on remote PC I get the 'access denied for user: [EMAIL PROTECTED]' (using password:yes). This suggest you tried to log on with a username 'user%' instead of 'user'. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do you ORDER BY two columns as one?
I have two tables, each with a column of type datetime, tbl_parent.parent_datetime, tbl_child.child_datetime. Then I want to count how many children a parent entry have and retrieve the latest parent entry OR the parent entry with the latest child entry. Therefore I need to ORDER BY parent_datetime and child_datetime as one column. So far, I haven't found a way to do this. Maybe there is some way I can SELECT and merge the two columns and then ORDER BY that? Cause ORDER BY tbl_parent.parent_datetime AND tbl_child.child_datetime doesn't seem to work. Any help would be appreciated, thanks.
a few questions regarding MySQL rights
Our programmer is designing a large scale database and I have some questions. 1) can I create groups, add users and assign privileges to the group? 2) since this system is going over a VPN the data should be encrypt using 3DES. If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1226 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVOur programmer is designing a large scale database and I have some questions./DIV DIV1) can I create groups, add users and assign privileges to the group?/DIV DIV2) since this system is going over a VPN the data should be encrypt using 3DES.nbsp; If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data?/DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV DIVJon L. Miller, MCNE, CNSBRDirector/Sr Systems ConsultantBRMMT Networks Pty LtdBRA href=http://www.mmtnetworks.com.au;http://www.mmtnetworks.com.au/A/DIV DIVnbsp;/DIV DIVI don't know the key to success, but the key to failureBRnbsp;is trying to please everybody. -Bill Cosby/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a few questions regarding MySQL rights
As far as I know, MySQL Access Privilege system does not allow you to create groups of users. You can have only users. Communication between MySQL Server and MySQL client is, normally, NOT encrypted. You can do that using SSL connections to your server (Mysql4 feature). Check http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Secure_connections Sincerily, Leonardo Rodrigues - Original Message - From: Jon Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 13, 2003 9:53 AM Subject: a few questions regarding MySQL rights Our programmer is designing a large scale database and I have some questions. 1) can I create groups, add users and assign privileges to the group? 2) since this system is going over a VPN the data should be encrypt using 3DES. If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do you ORDER BY two columns as one?
on 13/9/03 9:57 am, Peter Nguyen at [EMAIL PROTECTED] wrote: Cause ORDER BY tbl_parent.parent_datetime AND tbl_child.child_datetime doesn't seem to work. Any help would be appreciated, thanks. The AND should be a , thus: ORDER BY tbl_parent.parent_datetime, tbl_child.child_datetime Roddie Grant [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: a few questions regarding MySQL rights
In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: 1) can I create groups, add users and assign privileges to the group? Yup. 2) since this system is going over a VPN the data should be encrypt using 3DES. If a authorized user needs access to the data who is not in the VPN this information would be traveling in a clear text format (please correct meif I'm wrong) but is there a way to encrypt the data? For starters, I'd recommend always using SSH (whether VPNing or not) to encrypt the pipe (puTTY.exe is a great, free Windows-based terminal emulator for that, or Cygwin). It also depends on how your users are connecting (VPNers and other) and are you planning on using ODBC? If so, check out the net on redirecting ODBC requests through SSH. That way the pipe is encrypted, so whether the data is or not is less (but still) important. The config is something like this: client machine ssh -L 80:192.168.0.254:80 -l root -T 192.168.0.254 (You'll need the root password to the DB machine in this case) Check out: http://archives.postgresql.org/pgsql-odbc/2001-09/msg00040.php for more info. How will you be maintaining the DB? Through scripts? If so, SSH and ban Telnet. If you plan to use a GUI, you might check out www.ems-hitech.com/mymanager which provides a method for using SSL (its about $135.00 US). HTH, Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OS X Installation and Setup
Andy Callan wrote: When i try to startup the mysqld it works but then I get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Find the error log (which will be called machine-name.err and will be in your data directory) and see what it says. It generally prints an error that pretty much tells you what you need to do. I don't know where the package installer puts the data directory on OS X, but it might by /usr/local/mysql/data --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Retrieve a binary file from a mysql database
[EMAIL PROTECTED] wrote: From mysql manual: If you want to create the resulting file on some other host than the server host, you can't use SELECT ... INTO OUTFILE. In this case you should instead use some client program like mysqldump --tab or mysql -e SELECT ... outfile to generate the file thanks for yours answers, My database is filled with phpmyadmin but when I do : mysql -u karim -p vdc2 -e select file from Check_log where Check_log_id=1 toto.tar.gz the file toto.tar.gz is not good ( a select *** into dumpfile gives the good file on the server) is it a problem of escaped character ? Karim. On Fri, 12 Sep 2003, karim bernardet wrote: Hello, Is it possible to retrieve a file stored in a blob field using a mysql client from a host which is not the server ? Thanks for your help, Karim. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Date computation in MySQL PHP
On Sat, 2003-09-13 at 02:50, delz wrote: I want to know how do I use computations on dates in php or mysql like for example, today is September 13, 2003 (2003-09-13) and I want to get the date output if I add 5 days from the given date so that my output would be September 18, 2003 (2003-09-18). And if any given day falls on a Sunday, it will be moved to Monday. I just want to disregard Sunday and want to use Monday to Saturday. Anyone who can help me will be appreciated. Delz, Read this article. I found it very informative when I was looking into doing Date Arithmetic with MySQL. http://www.devshed.com/Server_Side/MySQL/DateArithmetic/ -Pete -- perl -e 'print pack(H*, 70766572746573406E79632E72722E636F6D0A)'
Re: a few questions regarding MySQL rights
At 10:21 AM -0400 9/13/03, [EMAIL PROTECTED] wrote: In a message dated 9/13/03 8:40:08 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: 1) can I create groups, add users and assign privileges to the group? Yup. ??? How do you create a group in MySQL? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Retrieve a binary file from a mysql database
At 5:24 PM +0200 9/13/03, karim bernardet wrote: [EMAIL PROTECTED] wrote: From mysql manual: If you want to create the resulting file on some other host than the server host, you can't use SELECT ... INTO OUTFILE. In this case you should instead use some client program like mysqldump --tab or mysql -e SELECT ... outfile to generate the file thanks for yours answers, My database is filled with phpmyadmin but when I do : mysql -u karim -p vdc2 -e select file from Check_log where Check_log_id=1 toto.tar.gz the file toto.tar.gz is not good ( a select *** into dumpfile gives the good file on the server) is it a problem of escaped character ? 1) mysql may format certain characters for display. For example, it may show newlines as \n. You might find it useful to add the -r (or --raw) option. 2) The output will include column headers by default. I assume you don't want that, so the --skip-column-headers may be useful. 3) You have named the output file with a .tar.gz extension. I'm not sure why, but if this implies that you believe the output will be in compressed tar format, it wont. You'll need to tar and compress the output from mysql yourself. For 1) and 2), you can find out such things by running mysql --help and looking through the help message. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connection error
At 8:08 PM +1200 9/13/03, Robert Morgan wrote: I have created a user grant all privileges on *.* to user@% =identified by ' pword' with grant option; and grant all privileges on *.* to [EMAIL PROTECTED] =identified by ' pword' with grant option; but when I try and connect through mysql client(DBTools) on remote PC I get the 'access denied for user: [EMAIL PROTECTED]' (using password:yes). According to the manual I should have created a user who can connect from anywhere as well as from localhost. I don't understand why this isn't working. Are you able to connect from the remote PC if you use the mysql client instead? Are you able to connect as this user when you try it from the server host? using mysql version 4.0.14 RH 9.0 DBtools pro on win2k Network connection is fine. Any help appreciated. Bob -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unscribe
please,remove my email from your database __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New DBTools Manager 2.2.0
We are pleased to announce the new release 2.2.0 of the DBManager Professional. It is a major bug fix bringing stability and performance to the application. Also it adds support to SQLite databases and Xbase Tables which you can manage using the same way you do for MySQL and PostgreSQL. In next version support for Interbase/Firebird will be available. Here is the list of changes: a.. Added support for SQLite Databases b.. Added support for Xbase Tables (Experimental) c.. Added filtering and ordering capabilities to the datasheet when editing table data d.. The DAO wizard can export data to a MSAccess Database e.. Fixed crash at startup (see message in the forums=Bug Reports) f.. Fixed datasheet refreshing and drawing problems and some things were reimplemented to make things a little easier g.. Fixed database dump (was generating NULLs instead of the real data) h.. Fixed Table Editor (was showing TEXT instead of MEDIUMTEXT/LONGTEXT column type) i.. Removed MSAccess/DAO engine as catalog database holder. We are using the SQLite engine which doesn't require any extra driver j.. Added more compatibilities with older versions of mysql and newer versions of PostgreSQL k.. Fixed bug when closing a query, datasheet or the application with queries opened. This caused crashes in some systems l.. Fixed the setup, which was installing an incorrect MFC version and creating a wrong key in the registry m.. Fixed a bug when converting data using the DAO Import Wizard, it didn't create the database and the process was stopped because the database didn't exist in the server n.. Fixed bug when creating users, sometimes it shows an empty error message box o.. Fixed drag and drop for tables and added drag and drop for databases p.. Added column sort on click in the datasheet when editing data q.. Fixed crash when connecting to a server at startup without passwords The new setup is quite smaller compared to old versions, since it doesn't install the DAO drivers anymore. Due to this, you need to install the drivers manually if you plan to import/export to MSAccess databases. Remember: when downloading the setup use the mirror already updated. You can use our forums to report bugs and give suggestions or request new features. What is DBTools Manager Professional? DBTools manager Professional is a FREE Windows application to manage MySQL, PostgreSQL, SQLite and Xbase Tables, full of features. Information get be found at http://www.dbtools.com.br. Support / DBTools Software == DBTools Forums can easily give you access to bug reports and feature requests. User registration is free. Anonymous users are allowed to browse all messages. http://www.dbtools.com.br/EN/forums == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Populating a Table with Data by Inserting a Textfile
What I'd like to do is create a textfile and then import the whole thing into a table. So, naturally, I've a few questions. Do I need to include the column heads as a line in my textfile, or can I simply go straight to the data? Assuming, no column heads are necessary--because they're already there in the table I've previously created--I'm looking at something like this (the double quotes at the start of each line are deliberately empty because the first column is an auto_increment column): , 'jack', 'sprat', '1 Main St', 'apt 2L', 'Anytown', 'NY', '1', '20030912154545' , 'john', 'doe', '45 Hoover St', 'apt 8B', 'Anytown', 'NY', '1', '20030912154555' , 'jane', 'smyth', '9 Fifth Ave', 'apt 2L', 'Anytown', 'NY', '1', '20030912154615' Now, do I put items in the single quotes, or is that only for when I'm typing stuff directly into the table via a command line situation? Do I separate entries using \t--no quotes, of course--without any spaces, commas, or tabs? And end each line with \r? (Or \n? Or both?) Like so: \t'jack'\t'sprat'\t'1 Main St'\t'apt 2L'\t'Anytown'\t'NY'\t'1'\t'20030912154545'\r , 'john'\t'doe'\t'45 Hoover St'\t'apt 8B'\t'Anytown'\t'NY'\t'1'\t'20030912154555'\r , 'jane'\t'smyth'\t'9 Fifth Ave'\t'apt 2L'\t'Anytown'\t'NY'\t'1'\t'20030912154615'\r Steve Tiano
LEFT JOIN question
Hi all; I was given a query today of the following: SELECT record_id, record_title,artist_name,label_name,record_catalog FROM record_profile LEFT JOIN artist_profile,label_profile ON record_profile.artist_id = artist_profile.artist_id OR record_profile.label_id = label_profile.label_id GROUP BY record_id The user is trying to LEFT JOIN the artist and label tables to the record table, and I realized that it has been quite a while since I did a LEFT JOIN two tables to the same source table. Anyone know how to do this? I can't remember if this is how it would be done: SELECT record_id, record_title,artist_name,label_name,record_catalog FROM record_profile LEFT JOIN artist_profile ON record_profile.artist_id = artist_profile.artist_id LEFT JOIN label_profile ON record_profile.label_id = label_profile.label_id GROUP BY record_id -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Install MySQL Help Tables
I'm confused... The 4.1 alpha features says that MySQL now has help files installed with the server. I did a clean install (Win2K), following all directions to the best of my ability, and find no help files. I did discover a SQL file that purported to fill the help files: fill_help_tables.sql. All they seem to do, however, is create empty tables. What am I missing? It's not critical, of course, I seem to find most of the help I need either in the documentation or on the internet. But it would be nice to have the server based help when I just need a quick reminder of parameters or the exact name of a function or whatever. Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight install (rpm -Uvh) failed on a bunch of dependencies -- including the fact that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on the existing installation, tried again on the new distributions and got failed dependencies for libcrypto 0.9.6 and libssl (don't remember the version number). The Redhat 9 installation has libcrypto 0.9.7a, so I'm not sure why the dependency check fails. I whent ahead with a --nodeps install and the basic server seems to run alright. However, when I then tried to install -Max, the service wouldn't start. I haven't pursued that problem -- simply went back to the basic server install. Actually, I had to do a complete reinstall of the server to get it to work. One question: do I need Max to get the transaction type capabilities for committing, roll back, etc? The documentation seems to imply yes in some places and no in others. Is the InnoDB in MySQL-server, enough to get these capabilities? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install MySQL Help Tables
At 10:46 PM -0400 9/13/03, Randy_Chrismon/[EMAIL PROTECTED] wrote: Also, I did a clean install using RPMs on a Redhat 9.0 machine. A straight install (rpm -Uvh) failed on a bunch of dependencies -- including the fact that apparently MySQL 3.2.? was installed with Redhat. I did an rpm -e on the existing installation, tried again on the new distributions and got failed dependencies for libcrypto 0.9.6 and libssl (don't remember the version number). The Redhat 9 installation has libcrypto 0.9.7a, so I'm not sure why the dependency check fails. I whent ahead with a --nodeps install and the basic server seems to run alright. However, when I then tried to install -Max, the service wouldn't start. I haven't pursued that problem -- simply went back to the basic server install. Actually, I had to do a complete reinstall of the server to get it to work. One question: do I need Max to get the transaction type capabilities for committing, roll back, etc? The documentation seems to imply yes in some places and no in others. Is the InnoDB in MySQL-server, enough to get these capabilities? InnoDB is standard in MySQL precompiled distributions (including RPMs) as of MySQL 4. Before MySQL, you needed to install MySQL-Max to get InnoDB support. Note that you still need MySQL-Max if you want BDB support. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Won't Shut Down
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'func ADD type enum ('function','aggregate') NOT NULL' at line
1
@hadShowDbPriv:=1
Documentation didn't say nuthin' about no 1064 error. (Wonder if it's
related to William the Conqueror?) Also, on a couple of occasions, I've
tried to shut the MySQL process down, either from the gui or using net
stop mysql and I get error messages that the server is not responding to
the shutdown message, a time out or some other error. I have to re-boot to
shutdown the MySQL server process (I have the process set to start
manually -- usually using net start mysql. This is just a
test/develoment environment. The latest error message was:
The service could not be controlled in its present state.
More help is available by typing NET HELPMSG 2189.
Although, in this case, this came after I aborted (ctl-C) net stop mysql
and it filled up half the screen with dots while waiting for the shutdown.
Interestingly, in most (all?) cases, the mysql.err log says MySQL shut
down successfully even though it still shows as a process in the Win2K
Task List, and can't be restarted without a reboot.
What's going on here?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 Script Shut Down Issues
After installing MySQL 4.1 on a Win2K machine, I tried to run the
mysql_fix_privilege_tables.sql script. I got the duplicate column name
errors which the documentation says I can safely ignore. However, I also
got this error:
ERROR 1064 at line 67: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax
to use near 'func ADD type enum ('function','aggregate') NOT NULL' at line
1
@hadShowDbPriv:=1
Documentation didn't say nuthin' about no 1064 error. (Wonder if it's
related to William the Conqueror?) Also, on a couple of occasions, I've
tried to shut the MySQL process down, either from the gui or using net
stop mysql and I get error messages that the server is not responding to
the shutdown message, a time out or some other error. I have to re-boot to
shutdown the MySQL server process (I have the process set to start
manually -- usually using net start mysql. This is just a
test/develoment environment. The latest error message was:
The service could not be controlled in its present state.
More help is available by typing NET HELPMSG 2189.
Although, in this case, this came after I aborted (ctl-C) net stop mysql
and it filled up half the screen with dots while waiting for the shutdown.
Interestingly, in most (all?) cases, the mysql.err log says MySQL shut
down successfully even though it still shows as a process in the Win2K
Task List, and can't be restarted without a reboot.
What's going on here?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
