Re: Mysql Linux can't auto flush-tables
TTBMK, there is no such thing as 'auto flush' in MySQL. When you say Everytime I add some record on my local computer then upload ... are you saying you upload the raw database files (from your data directory), or are you inserting/updating the data in your Linux databases with a query? If you are uploading the raw files, that is not a good practice. If you are updating/inserting it with a query, you shouldn't need to flush tables anyway. G. Jensen - Original Message - From: starofframe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 8:23 PM Subject: Mysql Linux can't auto flush-tables Hi, I have problem with Mysql 3.23.58 on Linux Mysql can't auto Flush-Tables I work with Mysql 3.23.58 windows version on my local computer... Then I upload to web-hosting that working with Mysql 3.23.58 on Linux.. Everytime I add some record on my local computer then upload to web-hosting... The table can't auto flush-tables... I have to ssh to server then type in mysql/bin - mysqladmin -u root -p flush-tables Then the table refresh... So anyone know how to configure Mysql to auto run flush-tables?? Thanx Nicholas Kho -- 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]
OPTIMIZE and REPAIR in MySQL-Front 3.0
Buyer beware ... I was a bit surprised when I learned there was a version 3.0 of MySQL-Front ... the developer of MySQL-Front shut down the project after version 2.5. As it turns out, this new version is unrelated to the original project created by Ansgar Becker. Though it has many of the same attributes, it does not support OPTIMIZE or REPAIR for MyISAM tables, which I feel is critical shortcoming. Worse, the developers of this new project are unwilling to consider implementation of these functions. Several users (myself included) posted requests in their forum, asking for implemnetatyion of OPTIMIZE and REPAIR. Their first response was to claim they did not understand the need for OPTIMIZE and REPAIR. After various responses to clarify the need, one of them wrote: ... A (sic) serios developer uses an other database type if MyISAM has problems like this or writes a feature in his application to handle this problem ... . In other words, they are telling those of us with systems using MyISAM tables to go fish. They are charging $25.00 for this utility ... not a great deal of money, but wasted money if the buyer thinks they are buying an enhanced version of Ansgar Becker's work. Gerald Jensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 5.0
Jamie: I don't think your problem has anything to do with version 5.0 ... though there have been some enhancements in security and user privs, the fundamentals (IMHO) have not changed. The problem is most likely with the application itself ... it needs to pass the user ID and password, and the user ID needs to have been granted the correct privs. G. R. Jensen - Original Message - From: jamie murray [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 04, 2004 9:22 AM Subject: mysql 5.0 Hi guys, I posted a similar question on this the other day but received no answers. I'm running 5.0 and have a possible security/password problem. If i run from command line all users work with or without passwords. If I try and connect to mysql through php,perl,python or odbc with a user that has a password I get client authentication protocol error. If I connect with any of the above with a user who has no password everything works fine. Does this have to do with 5.0 change to the password hash. If you have advice to offer it would be greatly appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: new install - command prompt doesn't work
Try c:\mysql\bin\mysql.exe If that works, then put c:\mysql\bin the system's path. - Original Message - From: Betta Jazzy Brown [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Betta Jazzy Brown [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 13, 2003 8:48 AM Subject: Re: new install - command prompt doesn't work i have done that C:\mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois [EMAIL PROTECTED] wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: I have installed MySql on my PC and I was trying to run the program by going to the command prompt typing: C:\net start mysql it says The MySql service has started successfully. the problem is that the command prompt doesn't read mysql but still reads C:\ What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\ mysql i have installed MySql Database Server Standard Clients (4.0) and MySql Control Center and I'm using Win2K OS... -- As well...what specifically can I use MySql for? I have a website that I'm trying to learn a lot of things through to make my resume more beefy and to make myself more marketable...What do you all suggest? Thanks, b-jazzy -- 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: new install - command prompt doesn't work
Why don't you check the Help utility for your particular operatiing system? This is not a MySQL issue, and there are several ways you can accomplish it depending on which version of the Microsoft Windows O/S you have. - Original Message - From: Betta Jazzy Brown [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 13, 2003 1:09 PM Subject: Re: new install - command prompt doesn't work ok...i set the path properly... in the command line, i did this: C:\C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND then, i am able to just type in mysql and it will begin... BUT...after i close the command prompt, once i reopen it, and type in mysql, it goes and says that mysql is not a command or recognizable... is there something that i'm still missing? Paul DuBois [EMAIL PROTECTED] wrote: At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: i have done that C:\mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. Paul DuBois wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: I have installed MySql on my PC and I was trying to run the program by going to the command prompt typing: C:\net start mysql it says The MySql service has started successfully. the problem is that the command prompt doesn't read mysql but still reads C:\ What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\ mysql i have installed MySql Database Server Standard Clients (4.0) and MySql Control Center and I'm using Win2K OS... -- As well...what specifically can I use MySql for? I have a website that I'm trying to learn a lot of things through to make my resume more beefy and to make myself more marketable...What do you all suggest? Thanks, b-jazzy -- 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: What is code and what's not?
Swedish should not be a problem ... the chief software architect behind MySQL is a Swedish-speaking Finn. If you want the password to be bubba, then the syntax is: /usr/local/mysql/bin/mysqladmin -u root password bubba If the computer (host) name is snickers, it would be written as: /usr/local/mysql/bin/mysqladmin -u root -h snickers password bubba - Original Message - From: Lost Idols [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 05, 2003 4:06 PM Subject: What is code and what's not? I found a script on this help page, that should be used when giving the root user a password, but I really don't understand what of this is words and what is just an example. /usr/local/mysql/bin/mysqladmin -u root password password /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password Where in this script am I supposed to write my password and where is the word supposed to acctually be written as the word password? And what about hostname? Is that a command or should I write the host name of my computer? Since I'm a newbie it's hard to understand. Can someone please mark this for me? Is this the right way? /usr/local/mysql/bin/mysqladmin -u root password xyxyxyxy /usr/local/mysql/bin/mysqladmin -u root -h `this_is_me` password xyxyxyxy Weird question maybe... but I guess I'm not the only one here. It would've been easier with underscored or different colours here... I guess ;-) _ Hitta rätt köpare på MSN Köp Sälj http://www.msn.se/koposalj -- 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: MySQL Win32 Service
Robert ... An excellent suggestion. Our best Programmer / Analyst has already reviewed the source code, and his conclusion is that there is absolutely nothing 'non-standard' about the way MySQL installs/removes services. G R Jensen -Original Message- From: Robert Rowe [SMTP:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 8:05 PM To: Gerald R. Jensen; Stefan Hinz Cc: [EMAIL PROTECTED]; robert_rowe Subject:Re: MySQL Win32 Service If I understand correctly, the MySQL source is available. If you are familiar with the code that registers/starts/stops services you might want to take a look at it. You might even try sending that section of the code to the vendor and challange him to tell you how it is non-standard. Robert Rowe --- Gerald R. Jensen [EMAIL PROTECTED] wrote: Stefan: I think you have just reinforced my position ... our contention is that MySQL works the same way as any other application that installs as a service. We have a number of applications (written by our own programming staff) that all use exactly the same procdure used in MySQL to install the service. I think the vendor in question has buggy/incomplete code, and is blaming MySQL for their problems. G R Jensen - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; robert_rowe [EMAIL PROTECTED] Sent: Friday, November 28, 2003 5:38 PM Subject: Re: MySQL Win32 Service Gerald, How closely does the MySQL Service on Win32 platforms conform to any known standard for installing/removing services? I raise the question because the vendor that provides the utility we use to create our installation package claims that MySQL uses non-standard commands for installing and removing services. As a result, they say, we cannot expect their program to install or remove the service. The irony is ... their program **does** install the service. It just can't stop the service and remove it. We use a third-party installer because we package the six databases our software suite requires with MySQL. I'm not sure I'm getting what you're after, but here's what MySQL does: shell mysqld --install # installs a service with the name Mysql shell mysqld --install MyMySQL # installs a service with the name MyMySQL shell mysqld --remove # removes a service with the default name (Mysql) shell NET START Mysql # starts the service called Mysql shell NET STOP Mysql # stops the service called Mysql shell would be something like c:\mysql\bin, depending on where you've installed MySQL. mysqld may as well be a different flavour of the MySQL server, e.g. mysqld-max-nt. What --install does is write a couple of entries to the Windows registry, and --remove will delete those entries. I don't know whether that procedure is considered standard on Windows systems or not; if it isn't, you might want to have a look at what --install actually writes, and then use a standard way of writing those entries (using a .reg file or whatever). Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Win32 Service
How closely does the MySQL Service on Win32 platforms conform to any known standard for installing/removing services? I raise the question because the vendor that provides the utility we use to create our installation package claims that MySQL uses non-standard commands for installing and removing services. As a result, they say, we cannot expect their program to install or remove the service. The irony is ... their program **does** install the service. It just can't stop the service and remove it. We use a third-party installer because we package the six databases our software suite requires with MySQL. G R Jensen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Win32 Service
Stefan: I think you have just reinforced my position ... our contention is that MySQL works the same way as any other application that installs as a service. We have a number of applications (written by our own programming staff) that all use exactly the same procdure used in MySQL to install the service. I think the vendor in question has buggy/incomplete code, and is blaming MySQL for their problems. G R Jensen - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; robert_rowe [EMAIL PROTECTED] Sent: Friday, November 28, 2003 5:38 PM Subject: Re: MySQL Win32 Service Gerald, How closely does the MySQL Service on Win32 platforms conform to any known standard for installing/removing services? I raise the question because the vendor that provides the utility we use to create our installation package claims that MySQL uses non-standard commands for installing and removing services. As a result, they say, we cannot expect their program to install or remove the service. The irony is ... their program **does** install the service. It just can't stop the service and remove it. We use a third-party installer because we package the six databases our software suite requires with MySQL. I'm not sure I'm getting what you're after, but here's what MySQL does: shell mysqld --install # installs a service with the name Mysql shell mysqld --install MyMySQL # installs a service with the name MyMySQL shell mysqld --remove # removes a service with the default name (Mysql) shell NET START Mysql # starts the service called Mysql shell NET STOP Mysql # stops the service called Mysql shell would be something like c:\mysql\bin, depending on where you've installed MySQL. mysqld may as well be a different flavour of the MySQL server, e.g. mysqld-max-nt. What --install does is write a couple of entries to the Windows registry, and --remove will delete those entries. I don't know whether that procedure is considered standard on Windows systems or not; if it isn't, you might want to have a look at what --install actually writes, and then use a standard way of writing those entries (using a .reg file or whatever). Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- 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: .bin.### files in /var/lib/mysql
Are you running Replication? - Original Message - From: jon yeargers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 10:12 AM Subject: .bin.### files in /var/lib/mysql The /var/lib/mysql directory is collecting server name-bin.### files. What are these? Should I be saving them? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL
Might also help if he would specify the O/S ... - Original Message - From: Martin Gainty [EMAIL PROTECTED] To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 01, 2003 1:12 PM Subject: Re: Can't start MySQL Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: Bob Demers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL I've clearly done something worng but, novice that I am, I'm at a dead end to figuring out just where I've gone astray. I've scoured the help files and faqs locally and online but can't seem to find anything I recognize as relevant. Perhaps someone can point me in the right direction. Have installed (actually twice) MySQL-PHP-Apache from CD included with Sams Teach Yourself PHP, MySQL and Apache in 24 Hours on Windows 98. Machine: Compaq Presario 5610, 192MBram Problem:#1 When I attempt to start Apache I get The system cannot find the file specified What file would that be? Service Status is dev4_423 (whatever that means). Problem #2: When clicking on MySQL stoplight icon in startup I get the MySql admin window AND a blank DOS window (MySqld)the cursor slows to a useless crawl and properties shows only an entry in Cmd Line = c:\windows\system\conagent.exe. Cursor doesn't return to normal speed until I close the MSDOS window, which also closes MySQL. Haven't got far enough along to do anything about configuring PHP. Bob Demers --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/03 -- 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: Contributing to MySQL
Why not post it here, or give us a link to download it from your server? - Original Message - From: Francesc Guasch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:47 AM Subject: Contributing to MySQL I have a script that dumps the grants of a MySQL Database and I want to contribute this. What should I do now ? -- 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: Moving DB
You didn't say which version of MySQL you are using, or if you are using InnoDB tables. I'll assume you are using MyISAM tables, and are **adding** a drive to the system. 1. Install / mount the new drive so it is available to the O/S and assign it a drive letter. 2. Stop the MySQL Server (in DOS: NET STOP MYSQL) 3. Copy the entire \data directory from \mysql to the new drive. 4. In DOS, CD\WINNT and EDIT MY.INI 5. Locate the line with datadir ... i.e.: datadir = C:/mysql/data/ ... and edit to reflect the new location of your data on the new drive ... i.e.: datadir = E:/mysql/data/ 6. In DOS, start the MySQL server (NET START MYSQL) G. Jensen - Original Message - From: Sparky Kopetzky [EMAIL PROTECTED] To: My Sql List [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 12:24 AM Subject: Moving DB I have a database that is getting too big for the drive it's on. How do change my.ini to make it see everything after I move the mysql/data folder?? or is there more to it than that?? BTW - I'm running on Windows NT 4.0 SP6 w/ gig of ram... Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recursive sql statement
Benny: What do you mean by 'recursive sql statements'? If you are talking about triggers and stored procedures, the answer is no. Gerald Jensen - Original Message - From: Bernhard Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:58 AM Subject: recursive sql statement hi i searched the mysql doc for support of recursive sql statements, but found nothing. i am right that mysql does not support such kind of statements? best regards benny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import Batch syntax error
I just ran your query (create and both inserts), and it worked like a charm on a Win32 MySQL 3.23.52. Just out of curiousity, why are putting the \r in? - Original Message - From: Tab Alleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:51 AM Subject: Import Batch syntax error Still trying to get all the way through my import batch file. Now I'm getting a syntax error on a certain line of the file, and a subsequent run produced the same exact error on the same exact line, but I can't see anything wrong with that line. Here's the line that produces the error: INSERT INTO `tmphotelinfo` VALUES(yvr100058,yvr,Holiday Inn Metrotown,4405 Central Blvd.,,Burnaby,BC,V5H 4M3,,(604) 438-1881,(604) 438-1883,AE D MC V \r); Here's the error: ERROR 1064 at line 1036960: You have an error in your SQL syntax near '' at line 1 Here's the previous line, which apparently doesn't cause an error: INSERT INTO `tmphotelinfo` VALUES(yvr100057,yvr,Holiday Inn Hotel Suites,1110 Howe Street,,Vancouver,BC,V6Z 1R2,,(604) 684-2151,(604) 684-4736,AE D MC V \r); I see no appreciable difference between the lines. Here's the line which creates the tmphotelinfo table: CREATE TABLE `tmphotelinfo` ( `OrgID` varchar(9) default NULL, `MetroCode` char(3) default NULL, `Name` varchar(100) default NULL, `Address1` varchar(100) default NULL, `Address2` varchar(100) default NULL, `City` varchar(50) default NULL, `State` varchar(10) default NULL, `Zip` varchar(16) default NULL, `Country` varchar(50) default NULL, `Phone` varchar(24) default NULL, `Fax` varchar(24) default NULL, `CCs` varchar(32) default NULL, KEY `OrgID` (`OrgID`) ) TYPE=MyISAM; ...and finally, there's nothing in the mysql.err file to give me a further clue. Does anybody here see something I don't? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best way to dump for daily archiving
Try ... /usr/local/bin/mysqldump -uUserName --opt $db $location$db.sql - Original Message - From: Scott Haneda [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; MySql [EMAIL PROTECTED] Sent: Saturday, March 01, 2003 5:18 PM Subject: Re: Best way to dump for daily archiving on 03/01/2003 3:03 PM, Cal Evans at [EMAIL PROTECTED] wrote: use the -opt flag. Can you tell me how to add in the username as well, I get a ./bin/mysqldump: invalid option -- o error Here is the pertinent line /usr/local/bin/mysqldump -uUserName $db $location$db.sql - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NEWBIE to mysql
Did you start the server? Normally, error 1064 means the server has not been started. - Original Message - From: jsp [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 07, 2003 6:49 PM Subject: NEWBIE to mysql Can anyone tell me why I keep getting an ERROR 1064 with this command ? I just would like to create a table with two fields, name and messages for a Simple guestbook but I want to store the data in a mysql database. mysql CREATE TABLE info - ( - name varchar(50) - message varchar(255) - ) - ; thanks, -wiley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows Users FeedBack
Clyde: I don't know what percentage of MySQL users are running on Windows servers, but I suspect it is higher than you might think. IMHO, you would also find a number of situations where MySQL is being used on Win32 platforms for development, while production databases are being served up on Linux, BSD, Unix, Solaris, etc. In our case, we have a cadre of about 90 clients running MySQL. At last count, 85 of them were running on Win32 servers, 4 on Linux, and 1 on True64 Unix. Internally, we develop on Linux, test on Windows, and give customers the option of server platforms when they install. At one time, we offered customers their choice of RDBMS (M$ SQL Server 7/2000 or MySQL). A little more than two years ago, we stopped offering the M$ servers, and have focused all of our efforts on developing our applications to use MySQL. We have never looked back! Gerald Jensen - Original Message - From: Clyde [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 4:02 AM Subject: Windows Users FeedBack Hi, I have installed Version 4.07 gamma on a windows 2000 server. Install went like a dream and I was up and running within a few minutes. I have run several tests of my own using Delphi and Zeos Data base controls - again all this works perfectly. ( I get nervous when things work this well !) I have been reading the list and come to the conclusion that MySql is used very much in a Linux/Unix web environment. I am looking at converting over our company legacy systems (debtors, creditors, assets, etc) to MySql. (we are a small company that would only have a maximum of 40 users logged on to the data base) Though everything I have tried works fine - this is only in a test environment and not a production one. Speed and Usability are a given, my only concern now is stability. So my questions basically are: 1. Am I on the wrong track here using MySql/Windows for these types of applications. 2. Are there other users out there with similar usage 3. Do windows users find MySql stable - Good or bad comments here please Perhaps this should be another thread, but would anyone have some indication as to what % of MySql installations are Windows based - my gut felling is that it would be lucky to be 5% but I would sure like to know if someone has some statistical data on this. Thanks Clyde England - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to establish database connection via PHP3
Did you configure your web server (Apache?) for MySQL and PHP? - Original Message - From: Mohammed Fouwaaz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 11:59 AM Subject: Unable to establish database connection via PHP3 Hello mysql gurus I am fairly new to mysql and php3. mysql server is running ok and I created a table and inserted a few records. php3 is also working ok and I am able to run a regular 'Hello World' script. BUT when I include a phpinfo() and call that -- I don't see an entry with the extension MySQL. Does this mean that the MySQL connection was not successful? I am unable to query using PHP3. I know that there could be any of hundreds of things wrong with the set-up but would be happy to receive some pointers to trouble shoot. Best Wishes for the Season to Everybody Fouwaaz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to establish database connection via PHP3
Don't know anything about PWS ... - Original Message - From: Mohammed Fouwaaz [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 12:36 PM Subject: Re: Unable to establish database connection via PHP3 It is Personal Web Server -- but I am not sure whether any special configuration is necessary for MySQL and PHP3. I installed PWS first and then MySQL and lastly PHP3. Thanks Regards Fouwaaz [EMAIL PROTECTED] wrote: Did you configure your web server (Apache?) for MySQL and PHP? - Original Message - From: Mohammed Fouwaaz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 25, 2002 11:59 AM Subject: Unable to establish database connection via PHP3 Hello mysql gurus I am fairly new to mysql and php3. mysql server is running ok and I created a table and inserted a few records. php3 is also working ok and I am able to run a regular 'Hello World' script. BUT when I include a phpinfo() and call that -- I don't see an entry with the extension MySQL. Does this mean that the MySQL connection was not successful? I am unable to query using PHP3. I know that there could be any of hundreds of things wrong with the set-up but would be happy to receive some pointers to trouble shoot. Best Wishes for the Season to Everybody Fouwaaz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql corruption probelm - urgent
MySQL is not the problem.
Are you shutting down MySQL before you shutdown/restart the machine?
When you say Win9x, which flavor or Win9x do you really mean ('95, 98,
98SE?)
- Original Message -
From: Lalit Chandwani [EMAIL PROTECTED]
To: MySql Mail [EMAIL PROTECTED]
Sent: Saturday, December 21, 2002 8:18 AM
Subject: mysql corruption probelm - urgent
hi all ,
i am facing a great trouble of mysql corruption on
windows
i am using mysql 3.23.53-max-debug version on win 9x
plateform
i am using both PHP and VB as a client
mysqld is running
some the the cause of the table corruption is the
sometimes improper shutdown
sometimes normal shutdown
sometimes unknows
their is no virus on the system and i tried the same
installtion in diffrent systems
along with the PHP , i am using the mysqlfront for
database manupulations.
thire is nothing data length or process with the table
, i don't know why mysql is so sensitive
tell the stable version of mysql for windows plateform
or also suggest the
secured and accurate way to communicate with mysql via
PHP so that it can be prevent
for the data corruption
it's very urgent ,
please reply
=
---
Dream Team Network Solutions Pvt. Ltd.,
C-97 , shastri nagar,Opp. PNB,
jodhpur. ( india ) - 342001
PHONE : 91-0291-308074 , 75
VISIT http://www.dreamteamonline.com
---
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to xfr Windows MySQL db to Linux ?
Technically, the files can work. But the best way (IMHO) is to use mysqldump out of the Win32 box, copy that file to the Linux box and pipe it in. Make sure you use options in mysqldump to do complete table creation, etc. Gerald Jensen - Original Message - From: tmb [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 16, 2002 5:30 PM Subject: How to xfr Windows MySQL db to Linux ? Will MySQL/Windows db files work on a Linux box? I'm guessing they will, but then someone questioned me. I'm creating a MySQL/PHP db prototype on a Windows box running Apache... but it will end up on a Linux/Apache server some day. Thanks for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can u us a source code file to setup a db in MySQL ?
Try:
mysql -u{username} -p {databasename}filename.sql
Make sure you put full create statements in the file, along with nay data
you wish to insert into the database.
Gerald Jensen
- Original Message -
From: TopMailBox [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, December 08, 2002 6:43 PM
Subject: Can u us a source code file to setup a db in MySQL ?
When created a complicated db in MySQL can you first create a source file
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the source file and then create the db accordingly ??
Or, must you input/key in one command at a time to the program in real time?
Thanks for any info.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to delete MySQL db ?
Open the mysql monitor, and ... DROP DATABASE databasename; - Original Message - From: Will Standley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 5:56 PM Subject: How to delete MySQL db ? I have a couple of test MySQL data bases on my Linux/Apache box and want to delete them for a clean start... How do I delete all the files associated with the two db's ? Thanks, Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trigger
Neal: What you are really asking is: Does MySQL support stored procedures? The answer is ... at this point ... no. Implementation of stored procedures is on the 'to-do' list, but it will be awhile before you see it. There are some work-arounds ... do a search of the archive for this list, or perhaps others reading your post can offer some pointers. In my case, I run a cronjob that calls a shell script which runs an SQL query that does cleanup and backup work. Gerald Jensen - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:23 PM Subject: Trigger Is there an equivilent to a trigger in mySQL? I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such tasks - I am looking for the functional analog on MySQL. Thanks. Neal Cabage - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why would MySQL server shutdown?
What would cause the MySQL server to just shutdown, apparently on its own? This server is running on a Linux (RH 7.3) (Dell) box with 512mb RAM and a SCSI RAID array. The MySQL version is 3.23.53, installed from RPM's. The RPM's were downloaded from a MySQL mirror (did not install the versions on the RH CD). The installation was done with RH's GUI and is a straight server install (not a custom). When the server was installed, the server started as one would expect and we gave root a password then ran a set of scripts to create and populate some databases. The server ran for about 7 days, then abruptly shutdown. A check of the log (/var/log/mysqld.log) indicated it was simply a shutdown, and we could find no further information. The tech restarted the box (he works with Windoze a lot), thinking mysql would restart. It did not. At first, I thought there may be a runaway cronjob (the first shutdown was about 24 hrs after one of the students tried to setup a cronjob do a database backup with a shell script he had written), but that doesn't seem to be the case. He uninstalled MySQL with the RH Package Manager, then re-installed the same RPM set. It came up normally, he set a root password, and recreated/populated the databases. It ran fine for about 5 days, then shutdown again, and would not start on a restart. Again, no error messages, no evidence of an unclean shutdown, no ??? Again, we removed/reinstalled, it came up and is running fine. Needless to say, this is driving us nuts. Any suggestions or ideas will be most welcome. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql replication problem
Just a guess, but I would say the problem rests in the network or network configuration. We have a number of installation running replication (both Win32 and Linux), and have never seen anything like this. Gerald Jensen - Original Message - From: Vaso Koutsonikola [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Vaso Koutsonikola [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 1:10 PM Subject: Mysql replication problem Hello, I use mysql version 3.23.49 and I have set up replication but once in a while I get the error below on the slave.. Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013) Then the slave reconnects to the master and the replication goes on... Does anyone have any idea why is this happening and what can I do to solve this problem?? Thank you.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on windows
MySQL is good on the Win32 platform ... slower than on Linux / Unix / BSD etc., but nonetheless it is a good performer. We have several of our Win32 clients who have switched to Linux servers or have augmented their Win32 servers with Linux servers to specifically handle database duties... the migration from one platform to another was a snap. - Original Message - From: Simon Windsor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:02 AM Subject: MySQL on windows Hi I have been asked to support/bug-fix a Windows based web site using MySQL. I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows. How does MySQL compare on Linux and Windows for stability and performance ? Simon -- Simon Windsor mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Replication Issues
Yes, you can replicate from Linux to Win2K ... but both servers have to be properly configured. Did you edit my.cnf on your Linux machine so it knows it is the Master (Win2K would be the Slave)? - Original Message - From: Rick Root [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 18, 2002 2:45 PM Subject: Newbie Replication Issues I have a few questions about Replication. I've already read the basic replication page here: http://www.mysql.com/doc/en/Replication_HOWTO.html I am running MySQL-MAX 3.23.53 for Linux on my master server, and the same version on Windows 2000 for the slave. #1 - Can I replicate from Linux to Windows 2k? I followed the instructions and put the appropriate things into the my.ini located in C:\MYSQL But... I can't tell if it actually read the my.ini The instructions also refer to an error log. I see C:\MYSQL\data\mysql.err - is this the file they are referring to? If so, the file makes no mention of replication. - RIck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Connection type, network configuration, operating system, ODBC configuration, etc. can be factors. You haven't shared any of that information, so it is hard to speculate. - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 2:54 PM Subject: Re: Lost connection to MySQL server during query Gerald R. Jensen wrote: Network problems ... something is breaking TCP/IP. Gerald, I can view the webpages on the server, though. Doesn't it use the same TCP/IP? - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Offsite Apps won't run
John: How are you connecting the nodes running Mascon, etc. to the server ... MyODBC, libmysql, etc.? If the problem started when you changed the server name, then check the DNS settings on the client machines. It would seem they are trying to connect to a non-existant DNS name. Gerald Jensen - Original Message - From: John Hinton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 11:12 PM Subject: Offsite Apps won't run I'm running a Linux Redhat 7.2 webserver. Recently, after making a change to the server name, I found that I can no longer connect to MySQL via programs such as Mascon or MACSQL (think that is the customer's app?). All on machine functions seem to be operational. phpMyAdmin still works for the several users and I have my full access to the entire database. MySQL functions via PHP pages. I've looked high and low and can't find anywhere to fix this. Any ideas? Other info... the server had not been rebooted for a looo time prior to my name change... perhaps there is something else that could have been done which might have interferred and maybe it was co-incidence that it only appeared after this name change? TIA -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Network problems ... something is breaking TCP/IP. - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures
MySQL does not support stored procedures. - Original Message - From: Ian Hagan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 13, 2002 7:10 PM Subject: Stored Procedures Hello All List Members, My name is Ian Hagan. I am a database developer specialising in Delphi. I am new to Mysql. (Using a Windows 98 platform; installed version 3.23.51-max) Can anyone help me with stored procedures in Mysql?? The Manual does not contain much info and refers me to several examples, none of which I can find in my installation or on the Mysql website. I am looking for general guidance only at this stage; some examples and install info would be of a great help. Thanks, Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create table if not exists from mysqldump?
Or your could ... mysqldump -uusername -p -hhostname --all --add-drop-table --add-locks -- complete-insert --compress --extended-insert --flush-logs --force --opt --ve rbose --databases databasename tablename test.sql - Original Message - From: swati sandhya [EMAIL PROTECTED] To: John Kelly [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, October 04, 2002 5:19 AM Subject: Re: Create table if not exists from mysqldump? Hi, Do u mean when u take a dump you need to add before each table drop table if exists then here is the command. mysqldump -uusername -p -hhostname --add-drop-table databasename tablename test.sql regards, Praveen --- John Kelly [EMAIL PROTECTED] wrote: Hi, I am trying to use mysqldump to dump the structure of a single database and want the output to make create table commands that include the IF NOT EXISTS switch so that when the file is imported into an existing database it does not write over tables with the same name. Does anyone know if this is possible with mysqldump and if so what option achieves this? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How much stable is MySQL in a production environment?
How stable is MySQL? Here's a quick case study ... Our clients are organizations involved in Electronic Journalism ... Radio and TV news. We produce a suite of applications that permit them to do word processing, document organization, data management (from news wire services), archives, planning and scheduling, etc under a single umbrella. Everything we do is written in C++ with Win32 applications (no Linux front-ends ... yet!). Originally (1998), we used M$ Server 7 and 2000. Support was a problem, and though the product was relatively stable, we had constant problems because of the complexity of the database server and some quirks that we found to be illogical. Installation was a pain, and customer updates were dreaded by our tech support staff. Getting the right combination of OLE, ODBC, DCOM, etc. was more luck than skill, and the 'middle-tier' approach (using M$'s Option Pack) was always temperamental. In 1999, we began development of some alternatives, including MySQL. At first, our intention was to support several database servers (M$, Oracle, Informix, MySQL, etc.) with a common interface. As our work progressed, it became obvious that MySQL was really the best choice for our target market, so we signed up as an OEM and re-focused our development so we could incorporate MySQL's native interface. Four things happened: - Our applications became far less bloated and began running faster ... even on older hardware - Our installation was greatly simplified, with fewer components to install on servers and client workstations. - Customers who converted from M$ to MySQL began commenting on improved system performance and recommending our product to their peers. - MySQL ... in our experience ... never crashes. Support, on the few occasions we have needed it, has been superb. The ability to converse directly with the software's chief architect (Michael Widenius) as well as the key programmers is unprecedented in my experience (10 years in software development). We now have 86 systems running MySQL. Most are running WinNT or Win2K servers, but a growing number are using Linux, BSD, and True64 Unix servers. We get frequent comments/compliments on stability, and in a few cases, the only time we hear from customers is when the Sales Department contacts them to renew their support agreements. Gerald Jensen - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: José Fernández [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 7:27 PM Subject: Re: How much stable is MySQL in a production environment? On Tue, Sep 24, 2002 at 05:08:30PM +0200, José Fernández wrote: Do you know if is a frequent problem that the mysql database damages suddenly? It is not. Have you experience with this type of problems? Never. Even running alpha MySQL code I don't see anything that nasty happening. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 49 days, processed 1,042,072,083 queries (242/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way?
Urial: Why are you so phobic about running MySQL as a service? I can think of no reason to not run it as a service if the operating system will permit you to do so. Since you can configure the service to either run automatically or be controlled manually, it would seem as though you have the best of both worlds. Running as a service has nothing whatever to do with serving any other machines on the network. You can run MySQL locally whether it is running as a service or not. If you don't want to use the service control manager (or whatever M$ calls it in WinXP) then write a set of batch files to start/stop the service. Gerald Jensen -Original Message- From: Uriel Wittenberg [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 3:24 AM To: Ed Carp; Gerald R. Jensen; [EMAIL PROTECTED]; Paul DuBois; [EMAIL PROTECTED] Subject:Re: Starting/stopping server on WinXP Home standalone -- what's appropriate way? I generally read responses to my requests for help with care ... and gratitude! So I did read Paul's post. To my knowledge it doesn't answer my (subsequent) question: Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is appropriate for standalone? But then I don't know what registered is and can't see any reference to this word in the WinXP Computer Management utility, or the MySQL service's properties there. I am asking in case having the server as a Win service is only needed when serving other machines on a network but there's a better way of running the server for local use. Is this Computer Management utility what Paul's referring to as the Services Manager? Do I have to use that tool to manually start the server (as per Paul), or can I do C:NET START - Original Message - From: Ed Carp [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:28 PM Subject: RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way? I want to have manual startup/shutdown but still am not sure of the appropriate way to do this. Change the startup type from Automatic to Manual. The Computer Management utility allows me to stop the service and/or change the service startup type to manual or disabled. Is disabled the same as removing the service? No. Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is appropriate for standalone? Read Paul's previous post. Like Paul said: Alternatively, if the service is registered, you can change it to be a manual service rather than an automatic service. Then you use the Services Manager to start it up as a service, but you have to do so yourself. It won't start whenever Windows starts. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting/stopping server on WinXP Home standalone -- what's appropriate way?
If you set it to 'Manual', then you should be able to start/stop the service with the appropriate NET START/STOP MYSQL command. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED]; Ed Carp [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 6:12 AM Subject: Starting/stopping server on WinXP Home standalone -- what's appropriate way? Using WinXP Home's Computer Management utility (which you get via: Start / Settings / Control Panel / Administrative Tools / Computer Management), I can see, under Services and Applications / Services, that MySQL's startup type is Automatic. I didn't set this so apparently this is what happens automatically on normal install of MySQL onto WinXP Home (or maybe on running WinMySQLAdmin the first time). The command being run is C:\mysql\bin\mysqld-nt. I want to have manual startup/shutdown but still am not sure of the appropriate way to do this. The Computer Management utility allows me to stop the service and/or change the service startup type to manual or disabled. Is disabled the same as removing the service? Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is appropriate for standalone? Given that I want manual startup and shutdown and am running standalone, should I disable/remove the service? After doing that, how should I start and stop the server? The manual says that under NT you do: NET START mysql NET STOP mysql but only when mysqld is installed as a service. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED]; Ed Carp [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 11:04 AM Subject: Re: Default Win install -- mySQL autostarts when booting? At 10:43 +0800 9/11/02, Uriel Wittenberg wrote: Sorry for not specifying: I'm using WinXP HOME. I did the normal default install. It seems to start up the mySQL server automatically when I start up Windows. Hence my question: Is there a standard way to change that so the server only runs when explicitly invoked? Start the Services Manager and see if it lists an entry for the MySql service. If so, tell the service to stop and close the window. Then open a DOS window and issue this command: C:\ mysqld --remove That will remove the service. Then it will run only when you invoke it explicitly. Alternatively, if the service is registered, you can change it to be a manual service rather than an automatic service. Then you use the Services Manager to start it up as a service, but you have to do so yourself. It won't start whenever Windows starts. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need help on DROP.
Clarify your question ... are you trying to drop TABLES, DATABASES, or modify user privileges? If you are trying to modify user privileges, use GRANT or REVOKE. - Original Message - From: Daniel Curry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:26 PM Subject: need help on DROP. I am unable to find the specific DROP command to remove only test@%, test\_%@%, snort@localhost, and snort@%. I am trying to clean up my db information. Thank you. mysql select * from db; +---+--++-+-+--- --+-+-+---++-+-- --++ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--++-+-+--- --+-+-+---++-+-- --++ | % | test || Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | test\_% || Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | localhost | snort| snort | Y | Y | Y | Y | Y | N | N | N | N | N | | % | snort| snort | Y | Y | Y | Y | Y | N | N | N | N | N | | localhost | snort_db | snort | Y | Y | Y | Y | N | N | N | N | N | N | | % | snort_db | snort | Y | Y | Y | Y | N | N | N | N | N | N | +---+--++-+-+--- --+-+-+---++-+-- --++ 6 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default Win install -- mySQL autostarts when booting?
Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - finishing up previous topic: --- I don't understand. In your previous message, you said: At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: Also, per advice here, I tried putting local-infile=1 in the [mysqld] and [mysql] sections of my.cnf(my.ini), but that does not change the behavior. Which seems to contradict what you're saying now. Yes, sorry -- I corrected my error in a previous message in this thread. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Default Win install -- mySQL autostarts when booting?
You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit! -Original Message- From: Paul DuBois [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:32 PM To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED] Subject:Re: Default Win install -- mySQL autostarts when booting? At 18:47 -0500 9/10/02, Gerald R. Jensen wrote: Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, ??? Have to, or have the option to? in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: Uriel Wittenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 6:14 PM Subject: Default Win install -- mySQL autostarts when booting? Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Uriel Wittenberg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:59 PM Subject: Re: Confused, discombobulated, weirded out, upset! --Windows standalone user Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. It might be installed as a service. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Manager Connection Config Problem
Odds are you have not granted your 'root' user rights to login from a node on the network. Instea dof using root, I would suggest you create another user with rights to login across the network. - Original Message - From: John Hanley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 3:12 PM Subject: MySQL Manager Connection Config Problem Hello. I'm running MySQL 3.23.29a-gamma on RH Linux 7.0. I would like to administer my database from a Win98se client on the same network and installed EMS's MySQL Manager 1.8. This appears to be an excellent tool and can't wait to get started. Unfortunately I'm having a problem getting the connection configuration setup correctly. Note that accessing the database from the Linux side works perfectly. The local NIC on my Linux server is assigned 192.168.0.1 and my Win98 workstation is 192.168.0.12. In the Configuration Info dialog, I enter 192.168.0.1 for Host, Port 3306, User Name Root, Password [mypass] and Database mysql. I know that MySQL Manager sees my MySQL server because it reports that Host '192.168.0.12' is not allowed to connect to this MySQL server. The weird thing about this message is that I'm trying to connect to 192.168.0.1 and not 192.168.0.12. It seems this is a permissions issue. Any suggestions would be appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stocking pictures in mysql database ?
Pierrot: Do a search on the archive (http://lists.mysql.com/) for this list ... look for images and blobs ... you should find numerous topics with the info you are looking for. Gerald Jensen - Original Message - From: navarra/mail.satori.fr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 3:57 AM Subject: stocking pictures in mysql database ? Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc. i've done an 'insert into table set field='datas'' but doesn't work please help me Pierrot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2004
Sounds like TCP/IP is not running on your machine. - Original Message - From: guilherme.afm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 10:45 AM Subject: ERROR 2004 I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following error message: ERROR 2004: Can´t create TCP/IP socket (10047) I did the same thing with my computer at my job place, but in the computer i have at home i get this error. What could it be? Thanks, Guilherme __ AcessoBOL, só R$ 9,90! O menor preço do mercado! Assine já! http://www.bol.com.br/acessobol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Command Line
Trevor ... Do you want to drop the tables, or simply delete the data in them and retain the table structure? To delete data ... USE databasename; DELETE * FROM tablename; To drop tables ... DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT | CASCADE] If you drop a table, then need to store data in it, you will have to re-create it. - Original Message - From: Trevor Tregoweth [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED]; PHP [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 8:12 PM Subject: Re: Command Line Hi I am very new to mysql, so any help please how to drop tables from a database from the command line i have 6 tables in there, and need to be able to flush all the data out, (of 2 tables only) so there might be another way Thanks Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup script
I use a shell script and set up a cron job. Here's the shell script (I call it mydbbak.sh) # #!/bin/sh # # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database1/dbbakup/database1.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database2/dbbakup/database2.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases database3/dbbakup/database3.sql # And here's the line from the crontab ... # Make backups of databases at 3am daily 0 3 * * * /usr/local/bin/mydbbak.sh Gerald Jensen - Original Message - From: Ilyas Keser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 26, 2002 5:26 PM Subject: backup script Has anyone a shell script example to backup all mysql databases at 3 o'clock at the night? Thanks... ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: WWW-Authenticate question!
Jerry:
This is really off-topic for this forum, but why not set a cookie with a
short life (expiration). Each page can check for the valid cookie. Then in
your logout page, delete the cookie.
Gerald Jensen
- Original Message -
From: JeRRy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 10:52 PM
Subject: WWW-Authenticate question!
Hi,
I am using the following code for a username /
password combination. A java box appears which the
user needs to input a username/password. This works
fine, BUT how do I make it so if the user wishes to
logout they can? I've tried closing the browser on
many browsers but on some you remain logged in even
when you visit the site again, resetting the PC works
to logout but really is not what I want. I would
prefer a logout button/link to clear their session
out. Here is my code below:
?
function auth () {
Header(WWW-Authenticate: Basic realm=\ArmFN
public
site\);
Header(HTTP/1.0 401 Unauthorized);
echo You have to authentificate yourself
first \n;
exit;
}
mysql_connect(localhost,USERMAME,PASSWORD) or
die(Unable to connect to SQL server);
mysql_select_db( MY_db) or die( Unable to select
database);
if(!isset($PHP_AUTH_USER)) {
$timeout =
mktime(date(G),date(i)+10,0,date(m),date(d),date(Y));
mysql_query(update users set id='$timeout' where
user='$user' and
password='$pass') or die(k1);
auth();
} else {
$pass = $PHP_AUTH_PW;
$user = $PHP_AUTH_USER;
$nowtime =
mktime(date(G),date(i),0,date(m),date(d),date(Y));
$quer2 = mysql_query(select * from contacts where
user='$user' and
Password='$pass' and id '$nowtime') or die(kuk2);
if (mysql_num_rows($quer2) == 0) {
$timeout =
mktime(date(G),date(i)+10,0,date(m),date(d),date(Y));
mysql_query(update contacts set id='$timeout' where
user='$user' and
password='$pass') or die(k);
auth();
}
}
?
ALSO, if I have more than one page for the members how
do I protect these? So if they have not got a valid
login they get asked for it or referred back to the
login / main page? Or is there a way to have all my
pages in the one PHP file? (I think this is possible
somehow)
Thankyou!
Jerry
http://digital.yahoo.com.au - Yahoo! Digital How To
- Get the best out of your PC!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
Our application (Win32) gives MySQL a real pounding, but we have never had it die on a server with proper resources. On Win32 systems, you can not underestimate the importance of virtual memory (swap file) and drive defragmentation. On Win32 systems with SCSI RAID, we set the virtual memory to 20% or more of the total disk storage capacity. If the customer insists on cheaper EIDE drives, we install three ... two in a normal mirrored config, and a third drive that contains nothing more than a big swap file. We make the swap files static (same min and max) to reduce file fragmentation. We no longer support servers that are not running DisKeeper (full version ... not the crippled one in M$ distributions). Gerald Jensen - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Shane Allen [EMAIL PROTECTED]; Georg Richter [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 7:14 PM Subject: Re: Crashing under high load Jeremy Zawodny wrote: On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. That's not normal at all. MySQL shouldn't care about the system load. It may run *slower* but it shouldn't die. Generally if it dies. Its because the operating system reached some limit. Often if you look at the hostname.err file in /var/lib/mysql there will be some clue as to what resource you ran out of. Some possibilities are o Virtual memory (swap space) o Open file descriptors o Address space o Stack space I think you need to examine your system when its underload and see if any of these resources are near exhaustion. Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using MySQL for a destop application
First, make sure you purchase the necessary licenses and support contract. Building your own installer is a piece of cake. We use InstallConstruct, but InstallShield, Wise, etc. will do just fine. Create the database(s) the way you want them, and include them in your installer package. Make sure you create a small app to create and write out the my.ini file ... ours is written in WinBatch, but there are many ways to accomplish this. In our case, the person doing the install runs the setup wizard, clicks through a few screens, and voila ... they're done. Gerald Jensen - Original Message - From: [XG]Boomer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 6:23 AM Subject: Using MySQL for a destop application Hi, What I would like to do is use MySQL for a desktop application. So not with a remote SQL Server. I'm using VB.NET and Native MySQL support to connect to mysql servers, which works just fine. But I would like to distribute an application which runs only on the local machine and uses mySQL as a backstorage. (Instead of lets say an access database) What would be the best way to do this ? I don't want to have the user installing MySQL seperatly and then having to configure it and creating the database and stuff I just one 1 clean install with everything preconfigured and the server only running when the desktop application is running. Is there special support for this ? Please not that I can't use C/C++ code. Thnx. TP. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/08/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: dos trouble
What O/S are you using ... Win2k, WinXP, etc.? - Original Message - From: Shion D. Deysarkar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:15 PM Subject: dos trouble I'm trying to start up mysql through dos prompt. When I enter a command like c:\mysql\bin\mysqld or anything similar (any command in the bin directory), it just waits there. I can't Ctrl-C out of it. I can end the process to get out. What's happening? -- Shion Deysarkar http://www.contrib.andrew.cmu.edu/~sdd Be water, my friend. -- Bruce Lee - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with subqueries
MySQL does not support sub-queries. Take a look at JOINS (http://www.mysql.com/doc/J/O/JOIN.html) - Original Message - From: Luis Rodrigues [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 6:03 AM Subject: Problem with subqueries hi, I have some sql code that I need to use with mysql it uses nested queries and since mysql doesn't implement them I would like to know how to do this. SELECT * FROM apartamentos WHERE vendido=0 AND Concelho=$row[ConcelhoP] AND Localidade LIKE '$row[LocalidadeP]' ... WHERE Referencia NOT IN ( SELECT Referencia FROM historico_clientes WHERE NumCliente=$id) Best Regards, Luis Rodrigues - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Circle
No can do. Replication is one-way. You can, however, have multiple Slaves. - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 12:35 AM Subject: Replication Circle Hello, Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B is the slave. However, I also want to make DB-B the master and DB-A it's slave so that if I have to fail over to DB-B then DB-A is automatically following the changes. It doesn't seem probable that this is possible, but I wanted to know if there was a way to do this, that I don't know of. Thanks, Bhavin. sql, mysql, query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to mySQL questions.
Ray: The only database you shouldn't mess with is the mysql database ... it is the equivalent of the 'master' database found in other systems, and contains all of the rights and privileges you invoke. Get to know the 'GRANT' command in the MySQL Manual (http://www.mysql.com/manual.php) ... therein you will find the answers to questions about user rights and privileges and a whole lot more. For PHP script samples, it is hard to beat http://www.hotscripts.com/PHP. Gerald Jensen - Original Message - From: Ray Healy (Data Net Services) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 6:25 AM Subject: New to mySQL questions. Hi Just a quick question. I was reading the manuals on the MySQL web regarding the initial setup of the program. I have installed the program and all is going well and have a user called root with full access and another user called mysql with limited rights (used mainly for PHPmyAdmin). There is a database called mysql which contains all the users, rights and privalages. The question I would like to ask is that there is another database called test whcih I belive from reading is a databse that users can connect to annoymously. Can I delete this database as I do not want anyone to connect without a user profile and password. Does it cause a problem deleting this database. Also while I am here can any one advise or tell me where to go in respects of accessing data to/from the database in a php form if the database users have a password. Or am I totally off track and you do not need a password or user in the php page as it is running locally. If anyone has a sample database and some php forms to interact with the databse they could let me see to learn from, it would be very much appreciated. Thanks for all your help Ray Healy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create DataBase tabe for a user
Did you first create a database named 'poll'? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 19, 2002 4:33 AM Subject: Create DataBase tabe for a user Hello, When I run grant all on poll.* to edward@localhost identified by 'edward'; command... I found there is no poll directory at /var/lib/mysql/poll ! So, can you help me ? PS : My system is Linux RH 6.2 Thanks, Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need Help with mysqlimport please-urgent!
Don't use 'root' ... create a new user, and make sure you GRANT the proper privs (i.e.: USE mysql; GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'password' WITH GRANT OPTION; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 5:42 AM Subject: Need Help with mysqlimport please-urgent! Hello, Here is my problem, I would like to use mysqlimport (which i have compiled as a batch file to run) from a client side to load data onto the database on a server side, meaning that I would normally access my server through the pc and running the batch file. Problem is that there are no errors but the tables on the server side does not get updated but instead points to updating my local database, data are loaded into my tables instead (i have the exact replica database on my own pc). Here is a sample command line from my batch file @h:\mysql\bin\MYSQLI~1.EXE --replace --host=host_name --user=root --fields-terminated-by=, --fields-enclosed-by=\ --lines-terminated-by =\r\n BO h:\mysql\data\BO\outnum i've mapped h:\ as pointing to the c:\ of my server..is that possible? [The error relates to 'access denied for @pc_id (i think its the same network id used for login to a NT domain) to BO database' or at times 'the mysql does not support this version'] P.S. My table name is outnum which is the same as the file name, MySQL version is 3.23.51. What am i doing wrong here? Need help please (could someone guide me what to do from the very beginning. I need to run mysqlimport as if i'm running any program from the console itself but only from a remote terminal). To simplify, what i need here is a way to run mysqlimport from my pc to pump data into the tables on the MySQL server instead of the data being thrown in my local MySQL server.Urgent! Thank you. Regards, Eric Loe. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: internal MYSQL clock?
MySQL doesn't have an internal clock. It uses the O/S's clock. Each of our servers (both Linux and Win32) running MySQL logs into a time server to set the system clock twice a day. Time references in the MySQL databases are always dead-on. - Original Message - From: Paul Wallace [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 9:07 PM Subject: internal MYSQL clock? Hi, I just encountered a problem when entering a datetime field. Using 'now()' in my SQL string input a time about 13 minutes before my other method (a JSP System.currentTimeMillis() method - one that generates the time from the CPU clock) Can anyone tell me why the time generated by now() differed significantly to the time generated by the method above that uses the CPU clock?! To me, that would suggest MySQL has some kind of internal clock? Or am I barking up the wrong bush? Thanks for any input P. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Read-Only MySQL
Kristian: Possible? I suppose, but not very practical. It would be ssllooww, you'd need to supply an application to permit access to the data, and how would you handle licensing? Gerald Jensen - Original Message - From: Kristian Koehntopp [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 6:48 AM Subject: Read-Only MySQL I want to create a CD-ROM which contains a copy of MySQL (for Windows) and a set of MySQL databases. Is it possible to set up a read-only MySQL, that is, a MySQL running from a r/o media? Kristian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing images in MySQL bad idea, performance-wise?
Rene: I think a good deal depends on the size of the image files themselves. There are a number of apps that store small files (i.e.: icons, small gif's, etc.), which seems to make sense. Larger files may be problematic. There was quite a discussion on this issue here just last week ... do a search of the list archive for 'blob versus file' and read some informed opinions. Gerald Jensen - Original Message - From: René Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 5:34 PM Subject: Storing images in MySQL bad idea, performance-wise? I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem: Do I store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dreamweaver MySql Databases
MySql won't report case mismatches as errors. MySQL can be configured to convert all table names to lower case on storage and lookup. Add the line: set-variable = lower_case_table_names=1 to my.ini (or my.cnf) -Original Message- From: William R. Mussatto [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 11:39 AM To: Gerald R. Jensen Cc: Ben Bennett; [EMAIL PROTECTED] Subject:Re: Dreamweaver MySql Databases Does your server support .jsp pages? Does your version of dreamweaver support editing .jsp pages? If yes to both questions, you can install a copy of MySql on your development box and develop there and move the pages up when you are ready to go live. Make sure both databases have the same structure, if you are developing under windows, keep the table names lower case as windows does not respect case and MySql won't report case mismatches as errors. I do the same with Forte/Sun One. However, a page artist friend use dreamweaver this way (avoids beans however) and recommends it. On Thu, 4 Jul 2002, Gerald R. Jensen wrote: Date: Thu, 4 Jul 2002 17:45:29 -0500 From: Gerald R. Jensen [EMAIL PROTECTED] To: Ben Bennett [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Dreamweaver MySql Databases Ben: Is your website on the same server as the MySQL database? If so, you should be able to install your HTML/ASP/PHP/Perl code with the query, and connect via the localhost. With the most popular (server-side) scripting languages, the query is actually executed on the server. Gerald Jensen - Original Message - From: Ben Bennett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 7:10 PM Subject: Dreamweaver MySql Databases I can't upload my sql query to my remote MySQL database. I'm using Dreamweaver and need to use a database for a few pages. My hosting doesn't allow for remote Sql connections. What do I need to do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How best to store queries
Tim: From the DB side, it is pretty easy to do ... a table with 3 columns will suffice: CREATE TABLE queries ( q_id int(11) NOT NULL auto_increment, q_name varchar(30) default NULL, q_text text, PRIMARY KEY (q_id) ); Your app needs to be able to select/load/execute the queries. A good example of this is the Win32 app Appgini (http://www.appgini.com) ... it is a commercial app, but has a free eval for download. Gerald Jensen - Original Message - From: Tim Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 11:44 AM Subject: How best to store queries Hello All: I believe that MySQL does not have the ability to directly store procedures, but I need to develop a process for clients to have an option to store queries that they have just made. The most obvious solution (to me) would be to store the entire query as a string of test. Does anyone have any thought on this, including creative alternatives and could anyone recommend a data type appropriate for storage? Regards -- Tim Johnson [EMAIL PROTECTED] Partner: http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql install on W2K server running Apache ver2.0.39
Marvin ... It is a lot easier than you may be thinking. Just make sure you download the Win32 binaries, and run the setup wizard. In most cases, the installer's defaults are fine, but you can put the server on any drive/partition you like. Check out the MySQL Manual's Win32 installation (http://www.mysql.com/doc/W/i/Windows_installation.html) and go for it! Gerald Jensen - Original Message - From: Marvin Cummings [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 8:01 PM Subject: MySql install on W2K server running Apache ver2.0.39 Hello all... I'm new to the list and to MySql and would like to get some advice on approaching my first mysql install. I've just installed Apache ver2.0.39 onto my W2K server and I'm currently attempting to get PHP4 going. Can anyone provide me with some ideas on how to approach the mysql install? Is it anything like installing SQL 2000? Or should I treat it like Apache and approach it with a Linux Unix mentality? Which version should I choose? Let me say that I am still navigating my way through the mysql site, so I'm pretty sure that I'll eventually come across the answer to some of these questions. I'm mainly looking for hands on experience. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.1 with Stored Procedure release date?
Julian: In my experience, MySQL doesn't project release dates. The surest way to avoid pulling a Microsoft (miss release dates) is not to project release dates in the first place. As I understand it, they are working through the to-do list (http://www.mysql.com/doc/T/O/TODO_MySQL_4.0.html) in 4.0.x, then will begin work on 4.1.x. Could be awhile ... but then again, it will likely be worth the wait. Gerald Jensen - Original Message - From: Julian Htun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 9:34 AM Subject: MySQL 4.1 with Stored Procedure release date? Does anybody knows estimated release date of MySQL ver 4.1 with Stored Procedure? Thanks, -Julian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Case Sensitivity for CHECK TABLE TABLENAME??
Mark: Do you have my.ini (or my.cfg) set to ignore case in table names? set-variable = lower_case_table_names=1 Gerald Jensen - Original Message - From: Mark Weiler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:56 PM Subject: Case Sensitivity for CHECK TABLE TABLENAME?? Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql php question
Taylor ... Check out ... http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html ... or ... http://vtwebwizard.com/tutorials/mysql/ - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 1:16 PM Subject: mysql php question Does anyone have some simple sample code using php to access a mySQL database? Could you post it or send someit to me please? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using web forms and webpages to access/view mysql data
Emma: It really depends on the language you wish to use ... could be Perl, ASP, PHP, etc. If you choose PHP, check out http://www.phpbeginner.com. You can obtain PHP (and find other useful links) from http://www.php.net Gerald Jensen - Original Message - From: Emma Grant [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 6:43 PM Subject: Using web forms and webpages to access/view mysql data Hi all, I successfully created and added data to my database! Does anyone know any good websites where I can learn to insert, update data using a web form and CGI? How does mysql perform when displaying images (jpg, gif) on a web page, that have been stored as BLOB file? I am new to this stuff, and I am really having a good time with it. Thanks, Emma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Spams on MySQL mailing lists
Monty: Excellent idea. Gerald Jensen - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Cc: Gerald Clark [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 7:09 AM Subject: Spams on MySQL mailing lists Hi! I was going through some of the old emails on the MySQL mailing list and noticed the many threads that discussed spams. (There seemed to be more emails discussing spams than true spams, but this is a separate issue). We here at MySQL AB do a lot of work to avoid spam and we are working on new better methods to do this. Previously Sasha was in charge of tuning the spam filters for the email list, but as he has lately been working full time on new replication features he has not had time to actively work on improving the current filter and keeping it up to date. We hope however to soon have a new person working on this to improve the quality of the MySQL public mailing lists. We have several times considering making the email lists subscribers only, but as I have posted previously, we believe this is not a good solution as it will make it much harder for new MySQL users to get help for their problems. (According from previous experience, a big part of the new MySQL users are not going to subscribe to a mailing list just to post a problem). My personal opinion is to go with the solution where a new, not subscribed poster would have to confirm his email the first time would be a good enough solution for us at this point. (Like on the PHP lists) Regards, Monty CTO of MySQL AB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation Help
Stephen: The *best* help for the kind of questions you have is in the MySQL Manual. Gerald Jensen - Original Message - From: Stephen Brown [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 8:22 PM Subject: Installation Help I am installing MYsql under linux and need some one on one help if somoeone is willing.. Thanks, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Licenseing Issue
Somebody will ... make it clear in whatever licensing statement you have that the end-user is responsible for licensing third-party components. - Original Message - From: Michael Ivanyo [EMAIL PROTECTED] To: mysqllist [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 10:24 PM Subject: Licenseing Issue I do not fully understand the license requirements and have a question. The application that I am developing will be able to work with either MySql, Postgres, or Oracle. Will I still need a license if the user decides to connect to a MySql database? --Michael __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Apache 2.0
We use the current stable version of MySQL on a server running Apache 2.0 with no problem. - Original Message - From: Jeff Whitman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 10:55 AM Subject: Apache 2.0 Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main Manchester, MI 48158-0702 734-428-7770 877-341-7770 734-428-1777 (fax) a href= http://www.JWNetSource.com JW NetSource.com/a a href= mailto:[EMAIL PROTECTED] E-Mail/a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TextBox -- Database
Well, for starters, if you are trying to put data into the database, your
query should use INSERT ... not SELECT.
Here's a snippet from one of my scripts ...
$query_insert=INSERT INTO tablename (column1, column2, textdata) VALUE
('$column1','$column2','$textdata');
if (!($result_insert = mysql_db_query($DB, $query_insert)))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
exit() ;
}
- Original Message -
From: Patrick Hanes [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent: Saturday, June 08, 2002 10:05 PM
Subject: TextBox -- Database
How do I take input off of web page text boxes and put them on MYSQL
database. This is the page's script. I also named the file Input.phtml.
I'm very new to this... what am I doing wrong?
HTML
HEAD
TITLE
Input
/TITLE
/HEAD
BODY
PThese are the people I sell to:/P
TABLE BORDER=10
?
mysql_connect(localhost, kryste, ***);
$result = mysql(mydatabase, select * from Bidder);
$num = mysql_numrows($result);
$i = 0;
while($i $num) {
echo TRn;
echo TDn;
echo mysql_result($result,$i,Last);
echo /TDnTD;
echo mysql_result($result,$i,First);
echo /TDnTD;
echo mysql_result($result,$i,Price);
echo /TDn;
echo /TRn;
$i++;}
?
/TABLE
/BODY
/HTML
I get this error: These are the people I sell to:
Warning: Supplied argument is not a valid MySQL result resource in
/home/kryste/Input.phtml on line 16
Thanks,
Pat
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database and all backups lost at same time
Not to add insult to injury, but keeping backups on the same machine and media your databases are installed on is asking for trouble. And power outages are predictable, so UPS protection is critical. Enough said. I would speculate that one or more of the files in the /data/mysql/ folder were open for a write operation when the power went out, corrupting the file(s). Since the mysql database controls rights/privs for the other databases, problems with it could transcend to problems accessing the other DB's. We have a process in place to prevent data loss: - All database schema are installed via scripts, which are stored on CD-RW media. - All privileges on our MySQL servers are scripted. Once installed, these scripts are kept on the CD-RW with the database schema scripts. - Every morning at 2am, a cronjob creates a backup of each database (including mysql) - When the backups are safely created, the cronjob does an SSH connection to another server and ftp's the backups to the other machine. - The backups are moved to CD-RW This is not a bullet-prof plan, but it gets the job done for us. Gerald Jensen - Original Message - From: kibserv-FtS Setiqueue [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, May 18, 2002 3:44 PM Subject: Database and all backups lost at same time This is an odd one. I seem to have lost all databases and backups simultaneously. I keep daily backups for upto 7 days. This morning after a power outage I noted I was unable to login. Every user and password I tried was denied. I checked the files in the mysql data folder and they were all there and seemed fine. They matched exactly to those in the past 7 days of backups. I even tried to restore from each of the 7 days of backups with no result. I removed all the files in the data/mysql/ folder and restarted mysql again. I was able to login as root with no password but found every other database I tried to use came back with 'ERROR 1049: Unknown database'. I also checked these files and they are all there. I am now able to 'use mysql' since it is empty. Any ideas on what may have happened. Since it seems to affect all databases and all backups I have to believe there is some corruption within the mysql server itself and not the data files. -Jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BookMark
Bookmarking?! No, MySQL does not support bookmarking ... it is relational database manager, not a word processor. All you have to do is save the query you run, and it will return the same results. - Original Message - From: SB Lim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 17, 2002 5:42 AM Subject: BookMark I am using VB6 with MYSQL, Is MYSQL support Bookmarking ? How can I implement that on the MYSQL ? Regards SB Lim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to Load a Database to other Server
What platform (Win32, Linux, BSD, etc.) are you using? If you have Win32 machine in the mix (doesn't need to be a server), suggest you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/). We've replicated databases from Win32 to Linux and Linux to Linux with it many times. Gerald Jensen - Original Message - From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 4:05 AM Subject: How to Load a Database to other Server Dear all I had a mysql Database in one of my Server, now i want to transfer this whole Database to another Server, what should i do? 1. How i can export this Database to a file 2. How i can Load this File into my another Server which create a database exactly same as the old Server? Thx a lot! Jack [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: basic warning
Stuart: Something is wrong with your query. A little more detail? G Jensen - Original Message - From: Stuart Elston [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 5:35 AM Subject: basic warning on a valid dB, I get the following warnings. Warning: Supplied argument is not a valid MySQL result resource in xx on line 7 First Name: Any ideas where to start debugging? Thanks in advance. Stuart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't start mysql-service on Win XP
If a trailing slash were required, mine would not work: [mysqld] basedir=d:/mysql datadir=d:/mysql/data language=d:/mysql/share/english skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M - Original Message - From: Sabine Richter [EMAIL PROTECTED] To: Jan Peuker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:31 AM Subject: Re: Can't start mysql-service on Win XP Hi Jan, I suppose you already tried this: http://www.mysql.com/doc/N/T/NT_start.html I did! This could be problems w/ your path or your my.ini (overwritten my mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote basedir=mysql -without the last backslash! Can that be a reason? And how to change it? The same for datadir! telnet localhost 3306 says: Verbindungsaufbau zu localhost... Es konnte keine Verbindung mit dem Host hergestellt werden, auf Port 3306. Es konnte nicht, da der Zielcomputer die Verbindung verweigerte. (perhaps incorrect translation: connection to localhost on port 3306 wasn't possible. The computer didn't allow the connection) If it won't start anyway, put mysqladmin.exe to your autostart. I don't understand that. I thought that mysqladmin requires an already started server service. Isn't that right? However, I tried start mysqladmin/host=localhost It says that it needs mysqld running and tells me to check it with telnet. What I did. See above. I have no debug-version of mysqld-nt. Any other idea?? best regards Sabine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql server question
What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Could this be just a Windows problem, a MySQL problem, or both? 2. Connected with the first question, if in the future, I should encounter this problem again, how would I be able to access the data that's in the database? This time around, I fortunately didn't insert any data and haven't been using it in a production environment. But, I'll be doing that in the future and want to know how to access the data other than the obvious route of making sure to backup all data each night and then accessing it that way. Thanks, Tim Keefe __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql server question
What Operating System (WinNT / 2K / 98 / etc.) are you using? - Original Message - From: Timothy Keefe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 28, 2002 10:18 AM Subject: mysql server question Hi, all, Two questions . . . 1. Windows is giving me the 1067 error, which states that the MySQL server is terminating unexpectedly. I guess I'm going to have to reinstall it, unless there's some way to troubleshoot what's wrong and then fix the problem. Has anyone ever encountered this? Could this be just a Windows problem, a MySQL problem, or both? 2. Connected with the first question, if in the future, I should encounter this problem again, how would I be able to access the data that's in the database? This time around, I fortunately didn't insert any data and haven't been using it in a production environment. But, I'll be doing that in the future and want to know how to access the data other than the obvious route of making sure to backup all data each night and then accessing it that way. Thanks, Tim Keefe __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Multi Line SQL Statements
Michael: Then I would think the problem is with the application(s) you are using as opposed to MySQL. It doesn't appear you are doing anything wrong. Gerald Jensen -Original Message- From: Michael Grover [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 7:51 PM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject:Re: Multi Line SQL Statements It's The MySQL Control Center program. I can take and save the sql statements from Mycc to a text file and call MySql c:\sql.txt and it runs fine... wierd Gerald R. Jensen wrote: Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same results. How are you entering a multiple SQL statement? Gerald Jensen - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 6:59 PM Subject: Multi Line SQL Statements I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multi Line SQL Statements
Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same results. How are you entering a multiple SQL statement? Gerald Jensen - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 6:59 PM Subject: Multi Line SQL Statements I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create table ZIPSTATES (state char(2), zip char(5))' at line 1 What am I doing wrong? mike ps: I am using MySQL Control Center 0.8.2 alpha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting MySQL with Windows 2000
Joe: Here is what we do ... - Login as Administrator - Open DOS Prompt, switch to the drive with MySQL on it, and CD\MYSQL\BIN - Type MYSQLD-NT --INSTALL - Type NET START MYSQL If that doesn't do the trick, your C:\WINNT\MY.INI (or C:\MY.CNF) may not be correct. Most coomon mistake is to use the wrong slash in basedir or datadir directories. Use forward slash (/) instead of backslash (\). i.e.: basedir=d:/mysql datadir=d:/mysql/data Gerald Jensen - Original Message - From: Joe Meirow [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 10:05 AM Subject: Starting MySQL with Windows 2000 Can anybody explain how to start MySQL on Windows 2000? I've moved and renamed the my.ini file to C:\my.cnf - to no avail. I get the following messages displayed in the Err File tab of WinMySQLadmin: 020421 5:22:28 MySql: Got signal 11. Aborting! 020420 8:41:09 MySql: Shutdown Complete Any help is greatly appreciated. Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TZ setting
Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up? I have read the manual on this, and tried various combinations, but haven't hit the right syntax. Gerald Jensen - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 8:14 AM Subject: Re: TZ setting DL, Wednesday, April 17, 2002, 1:37:15 PM, you wrote: DN Manual References: A.4.6 Time Zone Problems, F Environment Variables, DN and 4.1.2 my.cnf Option Files, but no examples or real explanation of DN use. DN Has anyone made use of MySQL's TZ setting? DN Can the TZ setting be used to run a db in a different time zone to the DN underlying OpSys? Run mysqld with --timezone=# option ... Look at: # mysqld_safe --timezone=EET mysql select now(); +-+ | now() | +-+ | 2002-04-17 12:59:06 | +-+ 1 row in set (0.01 sec) # mysqld_safe --timezone=GMT mysql select now(); +-+ | now() | +-+ | 2002-04-17 10:01:38 | +-+ 1 row in set (0.00 sec) DN (Windows and/or Linux) DN Please advise, DN =dn -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: client dependent timezone
Per client? Per database? The only timezone setting in the MySQL manual is for the server (tz), and permits you to set it to your local timezone so it does not return values in GMT. If you want clients to have different timezones, perhaps you should write that capabilty into your front-end application. Gerald Jensen - Original Message - From: Maxim Vysotskiy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 6:46 PM Subject: client dependent timezone Hello mysql, So nobody here (even at MySQL AB) knows how to set a timezone for a MySQL client ? Not for whole server but per client? (or maybe for database???) I already posted this question here few days ago - and didn't get any reply. Please! Somebody help! -- Best regards, Maxim mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: client dependent timezone
Depends on the language you are writing in, and the level of your programming skills. If your users/guests have database entries, it would be a rather trivial task to set their timezone in a column in the database, then write your app to calculate their local time based on the offset from GMT. You would either have to rely on the user to use a form or image map of some sort to select a timezone (ala Red Hat's installer), or devise a way to ready the clock on their local machine. IMHO, this is a programming problem as opposed to a MySQL database issue. - Original Message - From: Maxim Vysotskiy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 7:14 PM Subject: Re[2]: client dependent timezone Hello Gerald, But how people build web-applications then ? How can you use web-hosting in GMT+1 if web-application will be in use in GMT+5 for example? Have anybody an experience of resolving this problem (without embedding this functionality to backend app, because backend app is allready contains ~2 lines of code, and somewhere near to 1000 queries). If someone knows how to play this around - please help! Friday, March 29, 2002, 3:02:57 AM, you wrote: GRJ Per client? Per database? The only timezone setting in the MySQL manual is GRJ for the server (tz), and permits you to set it to your local timezone so it GRJ does not return values in GMT. GRJ If you want clients to have different timezones, perhaps you should write GRJ that capabilty into your front-end application. GRJ Gerald Jensen GRJ - Original Message - GRJ From: Maxim Vysotskiy [EMAIL PROTECTED] GRJ To: [EMAIL PROTECTED] GRJ Sent: Thursday, March 28, 2002 6:46 PM GRJ Subject: client dependent timezone GRJ Hello mysql, GRJ So nobody here (even at MySQL AB) knows how to set a timezone for a GRJ MySQL client ? Not for whole server but per client? (or maybe for GRJ database???) GRJ I already posted this question here few days ago - and didn't get any GRJ reply. GRJ Please! Somebody help! GRJ -- GRJ Best regards, GRJ Maxim mailto:[EMAIL PROTECTED] -- Best regards, Maximmailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fresh RedHat 7.2 install
If you are running RH7.2, start your GUI and go to System / Service Manager. Locate mysqld, and make sure it is checked to automatically start on bootup, then save your settings, and click the start button. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 6:28 AM Subject: Fresh RedHat 7.2 install Hello, This is a newbie question for a reason...I am. I've installed the lastest RPM for mysql on a brand new redhat 7.2 installation. When I try to run mysqladmin to set my new password (or for any reason actually, even to see the version number) I get the following error. I am not able to update the database either. As this is a fresh install, I'm thinking somebody probably has a quick-fix for me (maybe something about the OS pops into your head). I haven't seen this addressed in the manual pages. mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Thank You, Corey Baldwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NT service problem
Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprüngliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. März 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server :-( Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Finally found mysql-nt service error 1061 1067
Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -Original Message- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To: [EMAIL PROTECTED] Cc: Gerald Jensen; [EMAIL PROTECTED] Subject:Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex -Ursprungliche Nachricht- Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 15:13 An: [EMAIL PROTECTED] Betreff: Re: NT service problem Then you may have a problem with services running under the System Account on this machine. Try this: - Go into the Control Panel's Service Control Manager - Click on the MySQL service - Click on the 'Startup' button - Make sure 'Automatic' is selected - Select 'This Account' (instead of 'System Account') - Choose an Admin-level user and set the correct password - Click 'OK' then click 'Start' Gerald Jensen - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:45 AM Subject: AW: NT service problem Thanks - my.ini is used. Tried to use come of your parameters - but nothing changed. The interesting part: the standalone run is fine, the service part is wrong - so it has something todo with the service ?!? So long A:lex -Ursprungliche Nachricht- Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 13:40 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: NT service problem Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprungliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server :-( Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get
Re: Script for Data base backup and recovery : Very essential
This has been covered here a number of times before ... a search of the archive avoids the need to repeat the same info. That being said ... We use a cronjob (root) that calls a shell script at 3am daily. The line in the cronjob is: * 3 * * * /usr/local/bin/dbbakup.sh username password The shell script: # #!/bin/sh # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup fi mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases account/dbbakup/account.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases payroll/dbbakup/payroll.sql mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases contact/dbbakup/contact.sql # If you wanted to ftp the resulting scripts to another server, you could add code to the shell script to run ncftpput, etc. Gerald Jensen - Original Message - From: Chetan Lavti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 11:16 PM Subject: Script for Data base backup and recovery : Very essential hi, Can anybody tell me how can I write script for MySQL backup and recovery.( i am newbie as per script is cencern) I am using Innodb table type and using all the default parameters specified in the my.cnf file (my-large.cnf) Looking for kind response.. Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create database if does not exist.
Try ... CREATE DATABASE /*!32312 IF NOT EXISTS*/ databasename; ... then try reading the manual! - Original Message - From: Radhakrishna Mohan Tadepalli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 11:40 AM Subject: Create database if does not exist. I want to create a database test_db1, if test_db1 does not exist in the server using sql script. Is it possible? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
This 'developer' is feeding you some BS. MySQL handles XML data as well as any other type of data. The functioanlity of a particular database has a lot to do with the programmer who designs the schema. Maybe this 'developer' doesn't know how to design an XML/MySQL application ... but that doesn't mean there is a problem with MySQL. - Original Message - From: Javier Gonzalo Gloria Medina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 11:21 AM Subject: xml hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I´m cofused. Some one can help me with this is that true, is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup
We us a shell script that calls a cronjob (root) at 3am daily. The line in the cronjob is: +ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password The shell script: +ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw- +ACMAIQ-/bin/sh +ACM- +ACQ-1 +AD0- Unix/MySQL Username +ACM- +ACQ-2 +AD0- Unix/MySQL Password if +AFs- +ACE- -e /dbbakup +AF0- then mkdir /dbbakup fi mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases account+AD4-/dbbakup/account.sql mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases payroll+AD4-/dbbakup/payroll.sql mysqldump -u+ACQ-1 -p+ACQ-2 -c --add-drop-table --add-locks --flush-logs --databases contact+AD4-/dbbakup/contact.sql +ACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIwAjACMAIw- If you wanted to ftp the resulting scripts to another server, you could add code to the shell script to run ncftpput, etc. Gerald Jensen - Original Message - From: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw-hasan+AEA-impex.com.mv+AD4- To: +ADw-mysql+AEA-lists.mysql.com+AD4- Sent: Sunday, February 24, 2002 10:31 AM Subject: backup Hello everyone, I am trying to do backups using the crond daemon on my Linux server. Can I write a similar line as below on my crontab file. Any examples would be appreciated. mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql Alternatively i am thinking of running a perl file ...which will find access to the database and then do the backing and add this file to the crontab. Has anyone got a file pre-written for this purpose. thank you so much. Hasan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail +ADw-mysql-thread100889+AEA-lists.mysql.com+AD4- To unsubscribe, e-mail +ADw-mysql-unsubscribe-autodata+AD0-execpc.com+AEA-lists.mysql.com+AD4- Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL PHP Development IDE
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Print file
Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename; Then run the query from the command line (mysql -uusername -p databasenamevirtusertable.sqlvirtusertable.txt) Gerald Jensen - Original Message - From: Christo Rademeyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 3:52 AM Subject: Fw: Print file Hi all How can I take info from one table and print it into a txt file. the table is (NAME) and all the names in it I want to print out to a file name virtusertable. Thanx Christo sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Print file
Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename; Then run the query from the command line (mysql -uusername -p databasenamevirtusertable.sqlvirtusertable.txt) Gerald Jensen - Original Message - From: Christo Rademeyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 3:52 AM Subject: Fw: Print file Hi all How can I take info from one table and print it into a txt file. the table is (NAME) and all the names in it I want to print out to a file name virtusertable. Thanx Christo sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can login only as root
Luie: Here is a grant script we use ... check the syntax against the query you were using: USE mysql; GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'userpwd'; GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'userpwd'; GRANT RELOAD,PROCESS ON *.* TO username@localhost; Be careful ... the use created with this script has full access to all databases on your server. Gerald Jensen - Original Message - From: Luie delos Santos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 19, 2002 3:03 AM Subject: can login only as root hello all, I recently installed mysql on a RedHat7.2 box. I was able to login to it as *root*. I created another user (user1) using GRANT all to user1 identified by 'password';, but when I tried to login as *user1*, access denied message is displayed. I've tried *flush privileges* but I'm still unable to login as user1. hope somebody can shed some light on this. thanks in advance... luie __ www.edsamail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Licensing
Frans: Legalities aside, why not let fairness and common decency prevail? The MySQL team has a created a powerful, functional DB server. If you use their product(s) in a commercial application for which you are being paid, why would you NOT want to purchase a license? If the US$200 price is too high, then perhaps you should re-examine the fee you are charging. Gerald Jensen - Original Message - From: Frans Englich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 13, 2002 2:15 PM Subject: Licensing I'm writing an adminstrative program for a hotel located in Sweden. This program uses an mysql database as backend(the implementation is not in use yet, but my intention is to use mysql). To be really sure about this: Do the hotel _have_ to get an MySql database License or will they stay legal without one? I know, mySql is released under the GPL license but I need to be really sure about this. I would love to buy an license to support the Mysql team but since the license would be drawn from my payment I'm hesitating.. 200USD is alot of money here in Sweden, atleast for me. regards, Frans Englich [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL security
Dear - -: I would revoke all permissions for dummy, then create new permissions for users on a database-by-database basis. If you look at the syntax for GRANT in the manual, you can stipulate which databases a user would have access to. A word of caution: don't use root. Create a user for yourself and give it full permissions, then use it to administer teh database. Gerald Jensen - Original Message - From: - - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 07, 2002 9:13 PM Subject: mySQL security Hi all, I have set up mySQL database server on my web server running on RH Linux7.2. There are 2 user accounts, root and dummy who can access to databases. I'm wondering how to restrict the accesss to mysql (the db which stores user id, password, etc...). Right now, both users can run select, delete, update... statements on this database. How do I set the permissions so that only root can view, modify, delete tables or data in this database? Thanks in advance, kaz _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using MYSQL and PHP With Vitual Apache Servers ?
Matthew: There is no 'twist' here ... once your Apache server is configured to support MySQL and PHP, just design the appropriate schema for each website and create a database for each site requiring MySQL support. I would suggest you pick up one (or more) of the books available on MySQL and PHP programming ... there are a number from publishers like New Riders, O'Reilly, WROX, etc. Gerald Jensen - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 7:06 AM Subject: Using MYSQL and PHP With Vitual Apache Servers ? Hi, I have a redhat server, running apache 1.3.20. The server is running a couple of virtual servers for different websites. I now wish to add a few new virtual servers/domains to the machine. However (here is the twist) these sites will need to use a different mysql schema each and have some of the content generated with php based on the data from the different mysql databases. Is this possible ??? if so what is needed to configure this setup (just brief), and I would be very interested in hearing from someone who is running virtual servers with each site using a different mysql database. Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Server 2000
You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site. Must be a commercial package or subscription service. Gerald Jensen - Original Message - From: Norman Khine [EMAIL PROTECTED] To: Stan Lester [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 3:06 AM Subject: RE: SQL Server 2000 try http://www.appsolute.nl/heraut/ you can use importerscript to run db_dump.sql from you M$ SQL Server into dezign and then change the db type to mysql. hth Norman -Original Message- From: Stan Lester [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 18:35 To: [EMAIL PROTECTED] Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Server 2000
Stan: I don't know as I would call anything involving MSSQL Server 'painless, but it can be done. Do a search of the list archive (http://lists.mysql.com/), looking for 'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of years describing different ways to approach the task. You should be able to use the same techniques port MSSQL Server 2000. Regardless of the technique you use, there will be some editing required on the table creation scripts. When you get to that, the MySQL Manual is your friend. Gerald Jensen - Original Message - From: Stan Lester [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 12:35 PM Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
