Re: Cannot start MySQL under Win2000
You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. Octavian Rasnita wrote: Hi, Is it possible to install 2 versions of MySQL on the same computer? I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a time. I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine, however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first. When I try to: net start mysql (where mysql is the name of MySQL 4.1 service) or tried to start the service from the Windows management console (Services), the following error appears: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly. Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database in Thai
Best groupmember, I am in the situation to develop an web site for a Thai school and it will be in Thai and English. How can I setup so that my tables understand the Thai decoding (think it is UTF-8)? Thanks
Re: Database in Thai
UTF-8 is the encoding would want to use for Thai. Also see: http://dev.mysql.com/doc/refman/4.1/en/charset-asian-sets.html Cory. Peter Lauri wrote: I am in the situation to develop an web site for a Thai school and it will be in Thai and English. How can I setup so that my tables understand the Thai decoding (think it is UTF-8)? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database in Thai
Nope it 's tis-620. Man. Please feel free to reply to this email if you have additional questions or concerns ??? 01-7499093 ? ???, ???, ? ???. 01-749-9093, 02-938-8301 http://www.EasyHorpak.com - ???, ?, ??, ??? http://www.EasyHorpak.com/webdesign - ??? http://www.EasyHorpak.com/internet - http://www.EasyHorpak.com/software - http://www.EasyHorpak.com/move - ?? http://www.EasyHorpak.com/coin - ? - Original Message - From: Peter Lauri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 3:25 PM Subject: Database in Thai Best groupmember, I am in the situation to develop an web site for a Thai school and it will be in Thai and English. How can I setup so that my tables understand the Thai decoding (think it is UTF-8)? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
important! help plsss
hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
user to start/stop mysql without db access?
Hi, This may be a strange question, but I was wondering if it is possible to have a user starting/stopping the mysql server who wouldn't have access to the data. To explain: I want to set up a server as user Groupinstaller for example. This is a virtual user to allow other people of my group to start/stop the server by becoming Groupinstaller. But I don't want this user to be able to see the different databases of the different people, nor touch the data directory. For example, I have a database called db1 and my coworker has a db called db2. I am root of mysql, so I have access to all the databases, but he is just a user with access to his db and not to mine. If no other solution, I could eventually do with a read access, but I really don't want to allow write. I was thinking at replacing the typical mysql user by the Groupinstaller one, but this user owns the data directory... Does anybody know if it is possible, and how? thanks, melanie _ The new MSN Search Toolbar now includes Desktop search! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: user to start/stop mysql without db access?
mel list_php wrote: Hi, This may be a strange question, but I was wondering if it is possible to have a user starting/stopping the mysql server who wouldn't have access to the data. To explain: I want to set up a server as user Groupinstaller for example. This is a virtual user to allow other people of my group to start/stop the server by becoming Groupinstaller. But I don't want this user to be able to see the different databases of the different people, nor touch the data directory. For example, I have a database called db1 and my coworker has a db called db2. I am root of mysql, so I have access to all the databases, but he is just a user with access to his db and not to mine. If no other solution, I could eventually do with a read access, but I really don't want to allow write. I was thinking at replacing the typical mysql user by the Groupinstaller one, but this user owns the data directory... Does anybody know if it is possible, and how? thanks, melanie _ The new MSN Search Toolbar now includes Desktop search! http://toolbar.msn.co.uk/ Hi, If you are using a *nix operating system, then consider using sometbing like sudo or ssu to allow the other user access to the startup/shutdown script only. sudo can be found at http://www.sudo.ws/sudo/ not sure where ssu comes from though. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: important! help plsss
Umit tas wrote: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Google: ADO, ODBC, and MyODBC Should get you down the right path :-D -- Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQLDUMP not responding to the PORT option
Hi all, I'm trying to use mysqldump over SSH. I'm pretty familiar with port forwarding in and of itself, so I doubt that's the issue. No matter what port I forward (or to where for that matter), mysqldump still connects to the local MySQL server and dumps local data. It's as if it completely disregards my PORT option. Any ideas? My commands are as follows: %ssh -L 8080:localhost:3306 remote_server_ip %mysqldump -u user_name --port=8080 --compact --quick --all- databases dumpfile Depending on the user_name it either fails or dumps my local data. It doesn't even use --port Regards, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: important! help plsss
Umit tas wrote: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Private Function dbConnect() '{ 'If we hit an error, go on to the next command On Error Resume Next 'Create a new instance of the ADODB connection onject Set conn = New ADODB.Connection 'Control the cursors on the client side conn.CursorLocation = adUseClient 'Create the DSN string using properties from the preference file conn.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER= strDBHost ; _ DATABASE= strDBName ; _ UID= strDBUser ; _ PWD= strDBPass ; _ OPTION= 1 + 2 + 8 + 32 + 2048 + 163841 'SET ALL PARAMETERS 'Open the MySQL database connection conn.Open 'Sanity check - verify we have a connection to the database If conn.State 1 Then '{ MsgBox Error connecting to the database) '} Else '{ MsgBox(Connected to the database.) '} End If 'Return a reference to the database connection object Set dbConnect = conn '} End Function -- Erich Beyrent -- http://www.beyrent.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
install multiple versions of MySQL?
Hello everyone, I've ever seen some document about how to install multiple versions of MySQL on the same server. But I don't remember where I saw the document. Anybody know anything about it and happen to have some pointers? If I want to install multiple versions, I have to install from source rather than from RPM, right? I'm running RHEL 3. Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: wieldy question
wangxu [EMAIL PROTECTED] wrote on 12/01/2005 09:40:27 PM: I do a select with command-line.But the results can't show in a screen because there are a lot of rows.Can i show the results with separated pages? I don't know about the other shells but in a CMD or COMMAND shell (either on Win32) you can change the virtual width of your screen by changing the screen buffer settings. Right-click somewhere and go to properties. Check out the buffers tab. I set mine to be about 2000 columns wide and about 6000 rows tall and I hardly get any table wrapping any more (embedded newlines in text data still wrap some rows of data but that's about it). Unless I get more than 6000 rows back from a query, I can scroll up and down to my heart's content. Every shell I know has some form of the MORE command. If you pipe the output of a command-line query through the MORE utility on your system, it will give you the page-by-page output I think you are asking for. An alternative to displaying your output to screen is to either tee your output to a file or redirect it through the shell's command modifier. Once you have your results in a file, you can view them any way you like. For information on using the tee command built into the CLI: http://dev.mysql.com/doc/refman/4.1/en/mysql-commands.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Probelm with date grouping
Hi, I am having a problem with using dates grouped by week where it spans over 2 months. I would like the query to return all hours worked by week number, however week 48 is causing problems because it spans 2 months - actually I am presuming this is the problem! mysql SELECT DATE_FORMAT(T.Date, '%x-%v-%m') AS 'YearWeek', T.Status, U.User_ID, U.User_Firstname, U.User_Lastname, SUM(T.Hours) AS Total_Hours FROM Users U, Timesheets T WHERE T.User_ID = U.User_ID AND U.User_ID = 1 GROUP BY YearWeek, T.User_ID ORDER BY YearWeek DESC; +++-++---+-+ | YearWeek | Status | User_ID | User_Firstname | User_Lastname | Total_Hours | +++-++---+-+ | 2005-48-12 | Open | 1 | Shaun | x| 14.75 | | 2005-48-11 | Open | 1 | Shaun | x|23.5 | | 2005-47-11 | Unapproved | 1 | Shaun | x| 20.75 | +++-++---+-+ 3 rows in set (0.00 sec) mysql DESC Timesheets; +---+-+--+-+++ | Field | Type| Null | Key | Default| Extra | +---+-+--+-+++ | Timesheet_ID | int(11) | | PRI | NULL | auto_increment | | Type | varchar(40) | YES | | NULL | | | Project_ID| int(11) | YES | | NULL | | | Unavailability_ID | int(11) | YES | | NULL | | | User_ID | int(11) | | | 0 | | | Hours | float | | | 0 | | | Date | date| | | -00-00 | | | Status| varchar(40) | YES | | Open | | +---+-+--+-+++ 8 rows in set (0.00 sec) mysql SELECT * FROM Timesheets WHERE User_ID = 1; +--+-++---+-+---+++ | Timesheet_ID | Type| Project_ID | Unavailability_ID | User_ID | Hours | Date | Status | +--+-++---+-+---+++ |9 | Project | 71 | NULL | 1 | 8.25 | 2005-11-25 | Unapproved | | 10 | Project | 71 | NULL | 1 | 4.5 | 2005-11-26 | Unapproved | | 11 | Project | 66 | NULL | 1 | 8 | 2005-11-24 | Unapproved | | 54 | Project | 66 | NULL | 1 | 4.75 | 2005-11-28 | Open | | 53 | Project | 67 | NULL | 1 | 7.5 | 2005-12-02 | Open | | 52 | Project | 67 | NULL | 1 | 7.25 | 2005-12-01 | Open | | 51 | Project | 67 | NULL | 1 |10 | 2005-11-30 | Open | | 50 | Project | 67 | NULL | 1 | 6.25 | 2005-11-29 | Open | | 55 | Project | 66 | NULL | 1 | 2.5 | 2005-11-29 | Open | +--+-++---+-+---+++ 9 rows in set (0.00 sec) mysql Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: important! help plsss
Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Having a MySQL server and its client programs on different machines is probably the most common configuration. There is nothing wrong with the setup you propose. What exactly is the problem you are having? What have you read? What have you tried? Which connection library are you using to connect your program to the server? What error messages are you getting? We need more information in order to help. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: install multiple versions of MySQL?
Bing Du [EMAIL PROTECTED] wrote on 12/02/2005 09:41:21 AM: Hello everyone, I've ever seen some document about how to install multiple versions of MySQL on the same server. But I don't remember where I saw the document. Anybody know anything about it and happen to have some pointers? If I want to install multiple versions, I have to install from source rather than from RPM, right? I'm running RHEL 3. Thanks in advance, Bing Here you go: http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Probelm with date grouping
Shaun [EMAIL PROTECTED] wrote on 12/02/2005 10:09:44 AM: Hi, I am having a problem with using dates grouped by week where it spans over 2 months. I would like the query to return all hours worked by week number, however week 48 is causing problems because it spans 2 months - actually I am presuming this is the problem! mysql SELECT DATE_FORMAT(T.Date, '%x-%v-%m') AS 'YearWeek', T.Status, U.User_ID, U.User_Firstname, U.User_Lastname, SUM(T.Hours) AS Total_Hours FROM Users U, Timesheets T WHERE T.User_ID = U.User_ID AND U.User_ID = 1 GROUP BY YearWeek, T.User_ID ORDER BY YearWeek DESC; +++-+ +---+-+ | YearWeek | Status | User_ID | User_Firstname | User_Lastname | Total_Hours | +++-+ +---+-+ | 2005-48-12 | Open | 1 | Shaun | x| 14.75 | | 2005-48-11 | Open | 1 | Shaun | x| 23.5 | | 2005-47-11 | Unapproved | 1 | Shaun | x| 20.75 | +++-+ +---+-+ 3 rows in set (0.00 sec) mysql DESC Timesheets; +---+-+--+-+++ | Field | Type| Null | Key | Default| Extra | +---+-+--+-+++ | Timesheet_ID | int(11) | | PRI | NULL | auto_increment | | Type | varchar(40) | YES | | NULL | | | Project_ID| int(11) | YES | | NULL | | | Unavailability_ID | int(11) | YES | | NULL | | | User_ID | int(11) | | | 0 | | | Hours | float | | | 0 | | | Date | date| | | -00-00 | | | Status| varchar(40) | YES | | Open | | +---+-+--+-+++ 8 rows in set (0.00 sec) mysql SELECT * FROM Timesheets WHERE User_ID = 1; +--+-++---+- +---+++ | Timesheet_ID | Type| Project_ID | Unavailability_ID | User_ID | Hours | Date | Status | +--+-++---+- +---+++ |9 | Project | 71 | NULL | 1 | 8.25 | 2005-11-25 | Unapproved | | 10 | Project | 71 | NULL | 1 | 4.5 | 2005-11-26 | Unapproved | | 11 | Project | 66 | NULL | 1 | 8 | 2005-11-24 | Unapproved | | 54 | Project | 66 | NULL | 1 | 4.75 | 2005-11-28 | Open | | 53 | Project | 67 | NULL | 1 | 7.5 | 2005-12-02 | Open | | 52 | Project | 67 | NULL | 1 | 7.25 | 2005-12-01 | Open | | 51 | Project | 67 | NULL | 1 | 10 | 2005-11-30 | Open | | 50 | Project | 67 | NULL | 1 | 6.25 | 2005-11-29 | Open | | 55 | Project | 66 | NULL | 1 | 2.5 | 2005-11-29 | Open | +--+-++---+- +---+++ 9 rows in set (0.00 sec) mysql Any ideas? You are correct, this function: DATE_FORMAT(T.Date, '%x-%v-%m') is returning a second value for 2005-48 exactly because it spans two months. I think if you just simplified your format string to '%x-%v' you will get the behavior you want. Here is how I would rewrite it: SELECT DATE_FORMAT(T.Date, '%x-%v') AS 'YearWeek' , GROUP_CONCAT(month(t.Date)) as 'Month(s)' , T.Status , U.User_ID , U.User_Firstname , U.User_Lastname , SUM(T.Hours) AS Total_Hours FROM Users U INNER JOIN Timesheets T ON T.User_ID = U.User_ID AND U.User_ID = 1 GROUP BY YearWeek, T.User_ID ORDER BY YearWeek DESC; Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: important! help plsss
First - always CC: the list for every response (I just click - REPLY TO ALL - so I don't accidentally forget). In case I had become unavailable, anyone else could have answered. This is mostly volunteer help here. Hardly anyone that contributes to this list actually works for MySQL. Second - the address 127.0.0.1 is a special address that always points to just the machine you are on. It's known as the local loopback address and every TCP/IP machine has it. If your MySQL server is actually on the network it must have some address other than 127.0.0.1. Unfortunately, only you can find out what that address really is (it probably starts with 10.0.0. ). Once you figure out what the server's ip addres really is, put that in your connection routine and try again. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 10:19:06 AM: Error is: Runtime error '40003' server error detected. number:2003 description: Can't connect to MySQL server on '127.0.0.1'(10061) my computer ip 10.0.0.3 i'm trying host's ip adress('127.0.0.1' or computer ip:'10.0.0.2') and i'm created new user on MySQL('asd',pswrd:'123456',host:'10.0.0.2'(not localhost) but i can't do it From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 10:11:41 -0500 Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Having a MySQL server and its client programs on different machines is probably the most common configuration. There is nothing wrong with the setup you propose. What exactly is the problem you are having? What have you read? What have you tried? Which connection library are you using to connect your program to the server? What error messages are you getting? We need more information in order to help. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
Calling MySQL often risk of performance problems?
Hi, When I started out I used to do a single query and store the data in a Perl/PHP datastructure. I've noticed with time that I'm treating MySQL as though it were part of PHP/Perl. ie I call a MySQL primitive everytime I need to read a table/lookup table etc. I develop Shoppingbaskets/CMS systems for smaller client websites etc where speed is not the top criteria. What are your views/experience. -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start MySQL under Win2000
From: Stephen Cook [EMAIL PROTECTED] Subject: Re: Cannot start MySQL under Win2000 You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. I have installed MySQL 4.1 in e:\mysql and MySQL 5.0 in e:\mysql5. MySQL 4.1 service name is mysql and MySQL 5.0 service name is mysql5, so they are 2 totally separate programs. However, I want them both use the same port, because I will run only one of them in a certain moment, and not both, so there should be no conflict. I want this because I want to test the speed difference between MySQL 4 and MySQL 5 and I don't want to make any change in the program, but change only the service that listen to MySQL port... However, I've just read that the port should be different, even though I don't know why, and maybe this is the reason I cannot start MySQL 4 even if MySQL 5 is stopped. Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQLDUMP not responding to the PORT option
Michael Williams wrote: Hi all, I'm trying to use mysqldump over SSH. I'm pretty familiar with port forwarding in and of itself, so I doubt that's the issue. No matter what port I forward (or to where for that matter), mysqldump still connects to the local MySQL server and dumps local data. It's as if it completely disregards my PORT option. Any ideas? My commands are as follows: %ssh -L 8080:localhost:3306 remote_server_ip %mysqldump -u user_name --port=8080 --compact --quick --all- databases dumpfile Depending on the user_name it either fails or dumps my local data. It doesn't even use --port Regards, Michael Assuming you're on some version of Unix, it is completely disregarding your port option, because you are not specifying a host. The default is localhost, which means to connect via the unix socket. Port is meaningless with unix socket connections. To use your ssh tunnel, you have to make a tcp connection, which means you need to specify a host IP: mysqldump -u user_name -h 127.0.0.1 -P 8080 --compact --quick \ --all-databases dumpfile Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trojan Horse in MySQL
Hello. May be it is an UDF worm? See: http://dev.mysql.com/tech-resources/articles/security_alert.html Gary wrote: I have installed Apache PHP and MySQL over a year ago on a WINXP machine and suddenly a file, presumably there all that time is found to be infected by an upto date Norton anti virus program. Norton does not say what trojan horse. It cannot quarantine nor delete the file so I stopped the MySQL process and renamed the file myself. File is: C:\mysqldata\erqed.dll Anything known about this? please reply to [EMAIL PROTECTED] Gary -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help executing DDL.
Hello. music mysql -u root -p .. music untz$ mysql music_development db/create.sql Why haven't you added -uroot -p for you second action ? See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html untz wrote: Hello there! I am experiencing an error trying to make a DDL execute Am using Mac OS X Tiger and MySQL 5.. This is what I did: music mysql -u root -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. mysql create database music_development; mysql create database music_test; mysql create database music_production; mysql grant all on music_development.* to 'untz'@'localhost'; mysql grant all on music_test.* to 'untz'@'localhost'; mysql grant all on music_production.* to 'untz'@'localhost' identified by 'dolphin'; mysqlexit Then I placed a create.sql DDL file in music/db When I tried to run this file, I got the following error: music untz$ mysql music_development db/create.sql ERROR 1045 (28000): Access denied for user 'untz'@'localhost' (using password: NO) Any suggestions, hints, and tips are highly appreciated! Kindest regards, Unnsse -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to resolve this conflict?
Hello. Because you're using MySQL not from RHEL shipment you might have to install the required packages manually. For MySQL install MySQL-shared-xxx rpm. BTW - upgrade to 5.0.16 - it has a lot of bug fixes and is much more stable. Because of for php-mysql and other packages you might need to use --force option for rpm command. Bing Du wrote: Hello, 5.0.11-beta-standard is already running. Now I need to install php-mysql which requires mysql-3.23.58-15.RHEL3.1.i3. Here is what I did and the errors I got: $ sudo up2date -i php-mysql Password: Fetching Obsoletes list for channel: rhel-i386-ws-3... Fetching Obsoletes list for channel: rhel-i386-ws-3-extras... Fetching Obsoletes list for channel: dag-ws... Fetching Obsoletes list for channel: isl-channel-ws... Fetching Obsoletes list for channel: dag... Fetching rpm headers... NameVersionRel -- php-mysql 4.3.2 26.ent= i386 Testing package set / solving RPM inter-dependencies... Downloading headers to solve dependencies... php-mysql-4.3.2-26.ent.i386 ## Done. mysql-3.23.58-15.RHEL3.1.i3 ## Done. Preparing ### [100%] An error has occurred: Failed running transaction of packages: ('file /usr/bin/comp_err from install of mysql-3.23.58-15.RHEL3.1 conflicts with file from package MySQL-devel-standard-5.0.11-0.rhel3', (7= , '/usr/bin/comp_err', 0L)) ('file /usr/bin/mysql_config from install of mysql-3.23.58-15.RHEL3.1 conflicts with file from package MySQL-devel-standard-5.0.11-0.rhel3', (7= , '/usr/bin/mysql_config', 0L)) See /var/log/up2date for more information /// More information I found in /var/log/up2date is: // [Thu Dec 1 12:50:02 2005] up2date updating login info [Thu Dec 1 12:50:02 2005] up2date logging into up2date server [Thu Dec 1 12:50:03 2005] up2date successfully retrieved authentication token from up2date server [Thu Dec 1 12:50:03 2005] up2date availablePackageList from network [Thu Dec 1 12:50:03 2005] up2date Unable to import repomd support so repomd support w ill not be available [Thu Dec 1 12:50:15 2005] up2date solving dep for: ['libmysqlclient.so.1= 0'] [Thu Dec 1 12:50:19 2005] up2date solving dep for: ['libmysqlclient.so.1= 0'] [Thu Dec 1 12:50:22 2005] up2date installing packages: ['php-mysql-4.3.2-26.ent', 'mysql-3.23.58-15.RHEL3.1'] [Thu Dec 1 12:50:25 2005] up2date Failed running transaction of package= s: ('file /usr/bin/comp_err from install of mysql-3.23.58-15.RHEL3.1 conflicts with file from package MySQL-devel-standard-5.0.11-0.rhel3', (7= , '/usr/bin/comp_err', 0L)) ('file /usr/bin/mysql_config from install of mysql-3.23.58-15.RHEL3.1 conflicts with file from package MySQL-devel-standard-5.0.11-0.rhel3', (7= , '/usr/bin/mysql_config', 0L)) [Thu Dec 1 12:50:25 2005] up2date File /usr/sbin/up2date, line 1265, in ? sys.exit(main() or 0) File /usr/sbin/up2date, line 800, in main fullUpdate, dryRun=3Doptions.dry_run)) File /usr/sbin/up2date, line 1137, in batchRun batch.run() File /usr/share/rhn/up2date_client/up2dateBatch.py, line 90, in run self.__installPackages() File /usr/share/rhn/up2date_client/up2dateBatch.py, line 174, in __installPackages self.kernelsToInstall =3D up2date.installPackages(self.packagesToInstall, self.rpmCallback) File /usr/share/rhn/up2date_client/up2date.py, line 749, in installPackages runTransaction(ts, added, removed,rpmCallback, rollbacktrans =3D rollbacktrans) File /usr/share/rhn/up2date_client/up2date.py, line 634, in runTransaction rpmUtils.runTransaction(ts,rpmCallback, transdir) File /usr/share/rhn/up2date_client/rpmUtils.py, line 520, in runTransaction Failed running transaction of packages: %s) % errors, deps=3Drc) // So any way to walk around this conflict? Thanks in advance for any suggestions. Bing -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: user to start/stop mysql without db access?
Hello. Use mysqlmanager. MySQL Instance Manager is included in MySQL distributions from version 5.0.3, and can be used in place of the mysqld_safe script to start and stop the MySQL Server, even from a remote host. See: http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html mel list_php wrote: Hi, This may be a strange question, but I was wondering if it is possible to have a user starting/stopping the mysql server who wouldn't have access to the data. To explain: I want to set up a server as user Groupinstaller for example. This is a virtual user to allow other people of my group to start/stop the server by becoming Groupinstaller. But I don't want this user to be able to see the different databases of the different people, nor touch the data directory. For example, I have a database called db1 and my coworker has a db called db2. I am root of mysql, so I have access to all the databases, but he is just a user with access to his db and not to mine. If no other solution, I could eventually do with a read access, but I really don't want to allow write. I was thinking at replacing the typical mysql user by the Groupinstaller one, but this user owns the data directory... Does anybody know if it is possible, and how? thanks, melanie _ The new MSN Search Toolbar now includes Desktop search! http://toolbar.msn.co.uk/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQLDUMP not responding to the PORT option
Hello. mysqldump connects to the local host by default though the Unix socket.. Add -h127.0.0.1 to its options. Michael Williams wrote: Hi all, I'm trying to use mysqldump over SSH. I'm pretty familiar with port forwarding in and of itself, so I doubt that's the issue. No matter what port I forward (or to where for that matter), mysqldump still connects to the local MySQL server and dumps local data. It's as if it completely disregards my PORT option. Any ideas? My commands are as follows: %ssh -L 8080:localhost:3306 remote_server_ip %mysqldump -u user_name --port=8080 --compact --quick --all- databases dumpfile Depending on the user_name it either fails or dumps my local data. It doesn't even use --port Regards, Michael -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can't connect to the MySQL server from remote machine?
Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message and how to solve it? Thanks, Jenny
rollback after crash on OS X
Hello, Something weird happened on Wednesday: My Mac OSX Server unexpectedly restarted itself around 7PM. Everything seemed to be functional after that. However, I just noticed that basically a week worth of changes to a MySQL database have disappeared. Gone. Vanished. Objects that were created within a week leading to the crash have completely disappeared. Objects that were changed during that time show no sign of those changes. I could maybe understand if data from one session somehow was lost, but these changes were done over multiple sessions over a period of a week. The mysql log shows no shutdown info. The last error entry before restart is from the 21st. It definitely was an unclean shutdown. However, there are no startup errors. - 051130 19:01:15 mysqld started 051130 19:01:15 [Warning] Setting lower_case_table_names=2 because file system for /var/mysql/ is case insensitive 051130 19:01:26 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.13a' socket: '/var/mysql/mysql.sock' port: 3306 Source distribution - I not familiar enough with MySQL to even know where to begin looking for what could have happened. Any thoughts/suggestions? thanks, Jaime -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: important! help plsss
Sorry, but no. a) I do not accept attachments from people I do not know. b) I will help you to learn how to use MySQL. Unless you want to pay me for consulting, I will not take the risk of compiling and running your source code. c) You need to learn how to do this, yourself. Part of that is learning to how communicate the way other IT professionals communicate. If English is not your native language (and I do not think it is) you can try posting parts of your code (not the whole thing) to the list and letting us help you to find what isn't configured. There are several online translation services (babelfish comes to mind) that may be able to auto-translate for you. The problem, as I understand it so far, is that you don't have the actual IP address of your server. That is a networking issue, not a MySQL issue. If you solve that part of the problem and still have MySQL issues, please come back. There are many very intelligent people who monitor this list and you will probably get a fast and helpful response. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 10:56:24 AM: please install and try atachments but MySQL and programme must have different computers.( i can't do this connections) From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 10:35:55 -0500 First - always CC: the list for every response (I just click - REPLY TO ALL - so I don't accidentally forget). In case I had become unavailable, anyone else could have answered. This is mostly volunteer help here. Hardly anyone that contributes to this list actually works for MySQL. Second - the address 127.0.0.1 is a special address that always points to just the machine you are on. It's known as the local loopback address and every TCP/IP machine has it. If your MySQL server is actually on the network it must have some address other than 127.0.0.1. Unfortunately, only you can find out what that address really is (it probably starts with 10.0.0. ). Once you figure out what the server's ip addres really is, put that in your connection routine and try again. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 10:19:06 AM: Error is: Runtime error '40003' server error detected. number:2003 description: Can't connect to MySQL server on '127.0.0.1'(10061) my computer ip 10.0.0.3 i'm trying host's ip adress('127.0.0.1' or computer ip:'10.0.0.2') and i'm created new user on MySQL('asd',pswrd:'123456',host:'10.0.0.2'(not localhost) but i can't do it From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 10:11:41 -0500 Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Having a MySQL server and its client programs on different machines is probably the most common configuration. There is nothing wrong with the setup you propose. What exactly is the problem you are having? What have you read? What have you tried? Which connection library are you using to connect your program to the server? What error messages are you getting? We need more information in order to help. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement [attachment personel_visual_basic.rar deleted by Shawn Green/Unimin] [attachment ptform.rar deleted by Shawn Green/Unimin] [attachment VBMySQLDirect_Setup.rar deleted by Shawn Green/Unimin]
Re: Cannot start MySQL under Win2000
Octavian Rasnita [EMAIL PROTECTED] wrote on 12/02/2005 10:39:16 AM: From: Stephen Cook [EMAIL PROTECTED] Subject: Re: Cannot start MySQL under Win2000 You must not install 5.0 over 4.1, put it somewhere else. Also, instead of naming the service MySQL both times, call it something else (i.e. MySQL41 and MySQL50). If you use the Windows installer distribution, it is one of the options; if you are doing it by hand then you already know how to name the services whatever you like. HTH. I have installed MySQL 4.1 in e:\mysql and MySQL 5.0 in e:\mysql5. MySQL 4.1 service name is mysql and MySQL 5.0 service name is mysql5, so they are 2 totally separate programs. However, I want them both use the same port, because I will run only one of them in a certain moment, and not both, so there should be no conflict. I want this because I want to test the speed difference between MySQL 4 and MySQL 5 and I don't want to make any change in the program, but change only the service that listen to MySQL port... However, I've just read that the port should be different, even though I don't know why, and maybe this is the reason I cannot start MySQL 4 even if MySQL 5 is stopped. Thank you. Teddy They only need to use different ports if they are both running at the same time. The documentation describes how to set up multiple, simultaneously operating MySQL servers. As you describe it, you should be able to get them both running (one at a time) on the default port of 3306. The moment you try to allow both of them to bind to that socket at the same time, one of them will puke (usually the one you are just starting) so make sure that one is completely down before you start the other. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: can't connect to the MySQL server from remote machine?
Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM: Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message and how to solve it? Thanks, Jenny The value after the -h must either be a valid hostname in your organization or an IP address. If you can ping the server you want to reach by name, that's the name to use. Otherwize use the IP address of the machine you are trying to reach. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: can't connect to the MySQL server from remote machine?
Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM: Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message and how to solve it? Thanks, Jenny The value after the -h must either be a valid hostname in your organization or an IP address. If you can ping the server you want to reach by name, that's the name to use. Otherwize use the IP address of the machine you are trying to reach. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
DOT.NET Connector and Stored Procedures: Exception trying to retrieve parameter info
I'm having a problem getting parameters working. Mysql 5.0.16 mysql-connector-net-1.0.7 VB.NET 1.1 mysql SHOW CREATE PROCEDURE tbl_slct \G *** 1. row *** Procedure: tbl_slct sql_mode: Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64)) READS SQL DATA BEGIN SET @s = CONCAT('SELECT * FROM ' , tbl); PREPARE stmt FROM @s; EXECUTE stmt; END 1 row in set (0.00 sec) Public Function Test() As DataTable If myConn.State ConnectionState.Open Then myConn.ConnectionString = myConnString myConn.Open() End If Test = New DataTable Dim myCmd As New MySql.Data.MySqlClient.MySqlCommand(tbl_slct, myConn) myCmd.CommandType = CommandType.StoredProcedure myCmd.Parameters.Clear() myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter(tbl, escdofficer)) myCmd.Parameters(tbl).Direction = ParameterDirection.Input Dim myAdapter As New MySqlDataAdapter(myCmd) myAdapter.Fill(Test) '*** raises MySqlException End Function Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined What am I missing? Thanks, Steve
Re: important! help plsss
sorry :( but thanks. From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 13:29:35 -0500 Sorry, but no. a) I do not accept attachments from people I do not know. b) I will help you to learn how to use MySQL. Unless you want to pay me for consulting, I will not take the risk of compiling and running your source code. c) You need to learn how to do this, yourself. Part of that is learning to how communicate the way other IT professionals communicate. If English is not your native language (and I do not think it is) you can try posting parts of your code (not the whole thing) to the list and letting us help you to find what isn't configured. There are several online translation services (babelfish comes to mind) that may be able to auto-translate for you. The problem, as I understand it so far, is that you don't have the actual IP address of your server. That is a networking issue, not a MySQL issue. If you solve that part of the problem and still have MySQL issues, please come back. There are many very intelligent people who monitor this list and you will probably get a fast and helpful response. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 10:56:24 AM: please install and try atachments but MySQL and programme must have different computers.( i can't do this connections) From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 10:35:55 -0500 First - always CC: the list for every response (I just click - REPLY TO ALL - so I don't accidentally forget). In case I had become unavailable, anyone else could have answered. This is mostly volunteer help here. Hardly anyone that contributes to this list actually works for MySQL. Second - the address 127.0.0.1 is a special address that always points to just the machine you are on. It's known as the local loopback address and every TCP/IP machine has it. If your MySQL server is actually on the network it must have some address other than 127.0.0.1. Unfortunately, only you can find out what that address really is (it probably starts with 10.0.0. ). Once you figure out what the server's ip addres really is, put that in your connection routine and try again. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 10:19:06 AM: Error is: Runtime error '40003' server error detected. number:2003 description: Can't connect to MySQL server on '127.0.0.1'(10061) my computer ip 10.0.0.3 i'm trying host's ip adress('127.0.0.1' or computer ip:'10.0.0.2') and i'm created new user on MySQL('asd',pswrd:'123456',host:'10.0.0.2'(not localhost) but i can't do it From: [EMAIL PROTECTED] To: Umit tas [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: important! help plsss Date: Fri, 2 Dec 2005 10:11:41 -0500 Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B computer in LOCAL area network :( pls help Having a MySQL server and its client programs on different machines is probably the most common configuration. There is nothing wrong with the setup you propose. What exactly is the problem you are having? What have you read? What have you tried? Which connection library are you using to connect your program to the server? What error messages are you getting? We need more information in order to help. Shawn Green Database Administrator Unimin Corporation - Spruce Pine _ Donââ¬â¢t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement [attachment personel_visual_basic.rar deleted by Shawn Green/Unimin] [attachment ptform.rar deleted by Shawn Green/Unimin] [attachment VBMySQLDirect_Setup.rar deleted by Shawn Green/Unimin] _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To
what happened to error log in MySQL 4.1x/Windows XP
Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database in Thai
I did nothing special to the mysql database for my english-chinese multi-language web applications. And it worded just fine. column 'first_name' in this case is replaced by multiple columns according to the number of languages: first_name, b5_first_name, gb_first_name Language is a session variable and the application will based on it to select the right value(column) to compose the web page or update the data from inputs. The only thing important is to make sure the web page forcing the client browser to switch to the right language encoding. Especially when pulling data from client, you need to make sure the db table column for certain language will be feed by that language. +---+---+--+-+ | Field | Type | Null | Key | +---+---+--+-+ | first_name| varchar(24) | YES | | | gender| char(1) | YES | | | last_name | varchar(24) | YES | | | middle_name | varchar(12) | YES | | | person_id | mediumint(8) unsigned | NO | PRI | | b5_first_name | varchar(12) | YES | | | b5_last_name | varchar(12) | YES | | | gb_first_name | varchar(12) | YES | | | gb_last_name | varchar(12) | YES | | | property_dict | text | YES | | | added_date| datetime | YES | | | birth_date| date | YES | | | status_code | tinyint(4)| YES | | +---+---+--+-+ - Original Message - From: Peter Lauri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 1:25 AM Subject: Database in Thai Best groupmember, I am in the situation to develop an web site for a Thai school and it will be in Thai and English. How can I setup so that my tables understand the Thai decoding (think it is UTF-8)? Thanks Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.11/191 - Release Date: 12/2/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DOT.NET Connector and Stored Procedures: Exception trying to retrieve parameter info
This fixes my problem. Thanks!. Now to figure out where I got the ampersand from I thought it was in an example. On 12/2/05, Jesse Castleberry [EMAIL PROTECTED] wrote: Have you tried using ? instead of ? I'm very new to both MySQL and Stored Procedures, but I've got seversl stored procedures working right now, and I had to put a question mark in front of the parameters before it would work: myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter(?tbl, escdofficer)) myCmd.Parameters(?tbl).Direction = ParameterDirection.Input Jesse - Original Message - From: Rehcra [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 2:28 PM Subject: DOT.NET Connector and Stored Procedures: Exception trying to retrieve parameter info I'm having a problem getting parameters working. Mysql 5.0.16 mysql-connector-net-1.0.7 VB.NET 1.1 mysql SHOW CREATE PROCEDURE tbl_slct \G *** 1. row *** Procedure: tbl_slct sql_mode: Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64)) READS SQL DATA BEGIN SET @s = CONCAT('SELECT * FROM ' , tbl); PREPARE stmt FROM @s; EXECUTE stmt; END 1 row in set (0.00 sec) Public Function Test() As DataTable If myConn.State ConnectionState.Open Then myConn.ConnectionString = myConnString myConn.Open() End If Test = New DataTable Dim myCmd As New MySql.Data.MySqlClient.MySqlCommand(tbl_slct, myConn) myCmd.CommandType = CommandType.StoredProcedure myCmd.Parameters.Clear() myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter(tbl, escdofficer)) myCmd.Parameters(tbl).Direction = ParameterDirection.Input Dim myAdapter As New MySqlDataAdapter(myCmd) myAdapter.Fill(Test) '*** raises MySqlException End Function Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl' is not defined What am I missing? Thanks, Steve -- Rehcra
Re: what happened to error log in MySQL 4.1x/Windows XP
[EMAIL PROTECTED] wrote: Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] Manual: http://dev.mysql.com/doc/refman/5.0/en/error-log.html |log-error in my.ini should work. kgt | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql on OS X tiger
I'm setting up a mysql server on OS X Tiger powerbook for development. I've also a mysql server on my win2k pro machine. Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101 Both db servers work fine locally but I can connect from Tiger to Win2k while not from win2k to Tiger. The version of mysql on Tiger is 5.0.16, the version of mysql on win2k is 5.0.15. Other than that, I did almost nothing in configuring mysql on Tiger and win2k. Can anyone tall me what to do in order to make mysql connection from win2k to tiger? Thanks
Re: can't connect to the MySQL server from remote machine?
Hi, I tried with telnet localhost 3306 locally, and got the message as: Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. = 5.0.16-standard!QS//?.e,7~9iw;]E!r=Connection closed by foreign host. What is this meaning? Thanks, Jenny On 12/2/05, Fernando Antunes [EMAIL PROTECTED] wrote: To test if the 3306 is listening, try this command from client : telnet hostname 3306 If MySQL return some string, it´s there and listening If not, two possibilities : 1) A firewall between or on client and server 2) MYSQL is stopped or listening in a different port. What is the version of your MYSQL ? On 12/2/05, Jenny Chen [EMAIL PROTECTED] wrote: Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM: Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message and how to solve it? Thanks, Jenny The value after the -h must either be a valid hostname in your organization or an IP address. If you can ping the server you want to reach by name, that's the name to use. Otherwize use the IP address of the machine you are trying to reach. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: mysql on OS X tiger
I'm guessing that you are running 10.4.3 on your Powerbook. In this latest update, Apple took extra security measures and starts MySQL with the --skip-networking option. This means only processes running on the local machine can connect to it (through a Unix socket file), like PHP running under Apache or the mysql client. This is a good security measure. You can change this by editing the /etc/my.cnf file, comment out the skip-networking line and restart mysql. On Dec 2, 2005, at 3:54 PM, YL wrote: I'm setting up a mysql server on OS X Tiger powerbook for development. I've also a mysql server on my win2k pro machine. Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101 Both db servers work fine locally but I can connect from Tiger to Win2k while not from win2k to Tiger. The version of mysql on Tiger is 5.0.16, the version of mysql on win2k is 5.0.15. Other than that, I did almost nothing in configuring mysql on Tiger and win2k. Can anyone tall me what to do in order to make mysql connection from win2k to tiger? Thanks -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on OS X tiger
YL [EMAIL PROTECTED] wrote on 12/02/2005 03:54:44 PM: I'm setting up a mysql server on OS X Tiger powerbook for development. I've also a mysql server on my win2k pro machine. Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101 Both db servers work fine locally but I can connect from Tiger to Win2k while not from win2k to Tiger. The version of mysql on Tiger is 5.0.16, the version of mysql on win2k is 5.0.15. Other than that, I did almost nothing in configuring mysql on Tiger and win2k. Can anyone tall me what to do in order to make mysql connection from win2k to tiger? Thanks Servers do not talk to other servers except under very special circumstances: a) Replication b) FEDERATED engine operations c) NDB Cluster operations Unless you are trying to create one of those situations, your servers will not talk to each other. See the manual for details on how to establish one of those types of connections if that is what you are trying to do. Are you actually having problems connecting from a Win2K _*client*_ to the server running on your Tiger machine? Or is it something else entirely? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: can't connect to the MySQL server from remote machine?
That means that the MySQL server installed on the machine on which you issued the command is running AND that it can be connected to by the local loopback address (127.0.0.1). This still does not mean that you can connect to it from any other machine as your firewall may permit local (within the machine) communication but still block access from all other addresses. If your server is on a different machine, substitute 127.0.0.1 with the actual address or DNS name of the machine you are trying to connect to (localhost CANNOT be it unless the server is on the same machine you are). Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 04:28:51 PM: Hi, I tried with telnet localhost 3306 locally, and got the message as: Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. = 5.0.16-standard!QS//?.e,7~9iw;]E!r=Connection closed by foreign host. What is this meaning? Thanks, Jenny On 12/2/05, Fernando Antunes [EMAIL PROTECTED] wrote: To test if the 3306 is listening, try this command from client : telnet hostname 3306 If MySQL return some string, it´s there and listening If not, two possibilities : 1) A firewall between or on client and server 2) MYSQL is stopped or listening in a different port. What is the version of your MYSQL ? On 12/2/05, Jenny Chen [EMAIL PROTECTED] wrote: Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jenny Chen [EMAIL PROTECTED] wrote on 12/02/2005 12:27:33 PM: Hi, I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote Solaris SPARC box. When I run the command: mysql -h HOSTNAME I got the error as ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145) Could anyone please explain what the mean of the error message and how to solve it? Thanks, Jenny The value after the -h must either be a valid hostname in your organization or an IP address. If you can ping the server you want to reach by name, that's the name to use. Otherwize use the IP address of the machine you are trying to reach. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: MYSQLDUMP not responding to the PORT option
It's my understanding that when you specify localhost, the mysql client program will use the UNIX socket (ie, mysql.sock), and not look at port information. cheers, jenni Michael Williams wrote: Hi all, I'm trying to use mysqldump over SSH. I'm pretty familiar with port forwarding in and of itself, so I doubt that's the issue. No matter what port I forward (or to where for that matter), mysqldump still connects to the local MySQL server and dumps local data. It's as if it completely disregards my PORT option. Any ideas? My commands are as follows: %ssh -L 8080:localhost:3306 remote_server_ip %mysqldump -u user_name --port=8080 --compact --quick --all- databases dumpfile Depending on the user_name it either fails or dumps my local data. It doesn't even use --port Regards, Michael -- Jennifer Snyder Database Administrator Tribe Networks, Inc. www.tribe.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving databases from backups not working . . .
Greetings all, I've got some headaches I need to make go away over the weekend. I used phpMyAdmin to backup some small mysql databases. (So I've got a bunch of _dbname_.sql files) I have a different machine with a newer version of MySQL (4.1.13a) running and configured so that I can connect from the command line (as -u root) or via phpMyAdmin. I've copied the _dbname_.sql files to the new server. Now, from the UNIX prompt, I'm doing a: [terminal]mysql -u root -p emptydatabase _dbname_.sql[/terminal] I get no errors, but when I go back to look at the database (using phpMyAdmin - reloading the page) there are still no tables in emptydatabase. What am I doing wrong? Assuming that I get this part figured out, is it possible to also update the _mysql_.sql database so that all of the mysql users with mysql permissions to those databases will be replicated, as I had them on the other machine? I should probably mention that phpMyAdmin is on the same machine as the MySQL 4.1.13a and is connecting via TCP (not socket). I'm logged into the machine as Admin. My MySQL database directory (/var/mysql) AND EVERYTHING INSIDE IT has been chown'd to mysql:www. The /var/mysql directory is 755. If there is something wrong with my setup/permissions or any other part of what I'm doing here, please let me know. I have never moved databases before (obviously). : \ Thanks in advance for any insights! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing MySQL on Mac OSX 10.4.3
Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg, all give the same result... Can anyone help me? I think the previous person using this Mac screwed up some things, I've found traces of mySQL on the system, but I cannot find anything usable anymore. Any help is welcome! warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.com
Re: rollback after crash on OS X
Jaime, please post the COMPLETE UNEDITED .err log. The log sequence number would mean that your InnoDB tablespace has not been used after it was created: 051130 19:01:26 InnoDB: Started; log sequence number 0 43634 Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: Jaime Magiera [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, December 02, 2005 8:07 PM Subject: rollback after crash on OS X Hello, Something weird happened on Wednesday: My Mac OSX Server unexpectedly restarted itself around 7PM. Everything seemed to be functional after that. However, I just noticed that basically a week worth of changes to a MySQL database have disappeared. Gone. Vanished. Objects that were created within a week leading to the crash have completely disappeared. Objects that were changed during that time show no sign of those changes. I could maybe understand if data from one session somehow was lost, but these changes were done over multiple sessions over a period of a week. The mysql log shows no shutdown info. The last error entry before restart is from the 21st. It definitely was an unclean shutdown. However, there are no startup errors. - 051130 19:01:15 mysqld started 051130 19:01:15 [Warning] Setting lower_case_table_names=2 because file system for /var/mysql/ is case insensitive 051130 19:01:26 InnoDB: Started; log sequence number 0 43634 /usr/libexec/mysqld: ready for connections. Version: '4.1.13a' socket: '/var/mysql/mysql.sock' port: 3306 Source distribution - I not familiar enough with MySQL to even know where to begin looking for what could have happened. Any thoughts/suggestions? thanks, Jaime -- 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: Clear Screen in MySQL?
- Original Message - From: untz [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 10:47 PM Subject: Clear Screen in MySQL? Hello there, Is there a way to clear the screen in MySQL's command line prompt (mysql)? I am using OS X Tiger with MySQL 5 I don't have a Mac and I'm not running MySQL 5 but when I was at the MySQL prompt in Linux running MySQL Version 4.0.15 just now, the following worked fine: \! clear Since 'clear' is a Linux operating system command and Linux and Mac OS X are both forms of Unix, this command might very well work fine for you too. Please note that the '\! ' in front of the clear command is used to tell MySQL to pass the command back to the OS to handle. Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.10/189 - Release Date: 30/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Clear Screen in MySQL?
Rhino wrote: - Original Message - From: untz [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 02, 2005 10:47 PM Subject: Clear Screen in MySQL? Hello there, Is there a way to clear the screen in MySQL's command line prompt (mysql)? I am using OS X Tiger with MySQL 5 I don't have a Mac and I'm not running MySQL 5 but when I was at the MySQL prompt in Linux running MySQL Version 4.0.15 just now, the following worked fine: \! clear Since 'clear' is a Linux operating system command and Linux and Mac OS X are both forms of Unix, this command might very well work fine for you too. Please note that the '\! ' in front of the clear command is used to tell MySQL to pass the command back to the OS to handle. Rhino That does work in OS X, but it's simpler to just press ctrl-L. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CocoaMySQL v0.7b2 Connection Help, Part II
untz wrote: Hello there! This is a continuation of a previous posting of mine... I noticed that that the CocoaMySQL v0.7b2 client lists the Database, Socket, and Port fields as optional, so I filled the other fields and when I clicked on Connect, I received this error message: Unable to connect to host localhost. Be sure that the address is correct and that you have the necessary privileges. MySQL said: Client does not support authentication protocol requested by server; consider upgrading MySQL client Has anyone used CocoaMySQL v0.7b2 with MySQL 5 on OS X Tiger? What is the default port number? Kindest regards, Unnsse If you are connecting to the mysql server on localhost, the port is irrelevant as you are connecting via unix socket. The error message indicates that your client (CocoaMySQL v0.7b2) was compiled against the mysql 4.0 library. Authentication was changed to make it more secure in 4.1. See the manual for details and workarounds http://dev.mysql.com/doc/refman/5.0/en/old-client.html. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]