RE: Newbie Q: Booleans??
There is a BOOLEAN type, which really is a TINYINT. Any non-zero value is true and zero is false. I use this columnt type with all my checkboxes in Visual Basic. HTH JFernando * sql * -Original Message- From: David Hefford [mailto:[EMAIL PROTECTED]] Sent: January 31, 2003 06:46 To: [EMAIL PROTECTED] Subject: Newbie Q: Booleans?? Have used many databases but am just getting into MySQL and am totally rapt about it :) I am writing a front end in realBasic that needs to be able to run on various backends, MySQL being the main one. All of the others have a boolean type of column. What is the general practice to mimic¹ a BOOLEAN field in MySQL? PS: I do not need NULL or date for example, I just need true or false, yes or no etc... Regards David Hefford Power On Solutions Web: http://www.poweron.com.au Email: [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: sql query using select and row functions
Try ordering the records backwards, e.g ORDER BY id DESC and then limit 0, 5 HTH JFernando * sql * -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: January 28, 2003 11:26 To: [EMAIL PROTECTED] Subject: sql query using select and row functions I am trying to do an sql query and am trying to select the last x rows from the database. I see the limit function but that seems like that is from the first row down. I want to start from the last row to the first row. So, selecting the last 5 rows for instance? Can this be done? - 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
Red Hat/Mandrake or Other
I would like to know which Linux Distribution is best suited to run MySQL 4.0.9. I was thinking of Red Hat or Mandrake so if someone could tell me which of these is better for a production system or if there is a better distro other than these two Your comments are really appreciated. Thank you, JFernando * sql * - 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 and SQL
MySQL is a relational database managament system (DBMS) that uses the SQL language for doing queries to get the inforamtion stored in it. MySQL is the equivalent as saying Oracel, or DB2. HTH JFernando * sql * -Original Message- From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]] Sent: January 17, 2003 15:01 To: '[EMAIL PROTECTED]' Subject: mySQL and SQL Hi I am new to mySQL, Can someone explain to me the difference between SQL and mySQL? I know a little bit of SQL, select statments, insert statments and such, but I ahve no idea what is mySQL? - 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: Backups mechanism
You can do the same thing in Win32 using a vb script. Just use the Run command of the shell object to run mysqldump. This is the way I back up our database to text files that get burnt into a CD. HTH JFernando ** sql ** -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: January 7, 2003 15:49 To: mysql users Cc: Jonas Widarsson Subject: Re: Backups mechanism -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonas -- ...and then Jonas Widarsson said... % % Hello world! Hi! % Every attempt I have made to find a decent way of backing up a database % ends up with tons of reading to show hundreds of ways to do database % backups. Heh :-) And you expect less from a mailing list? % % I want to know which way to do complete backups is most commonly used by % professional users. (Windows and Linux) I can't speak for Windows, but I can speak for Linux -- or at least count as a voice. There is, of course,, more than one way to do it :-) % % I have pleasant experience from Microsoft SQL Server 2000 where backung % up is very confident, easy to understand and just a matter of a mouse click. "Gosh, that sounds terrible. Only one way to back up? Having to use a mouse? Who would want that?" Perhaps that casts some light on the UNIX "philosophy": have small tools that do few things and do them well, and then interconnect them to make whatever you need. % % Is there any similarily convenient way to do this with mysql, for example: % * a shell script (windows / Linux) that works as expected without days % of configuration? % * scheduled backups, complete or differential? % * GUI-solution ??? (mysql control center does not even mention the word % backup) I don't know about similar, but definitely convenient. A little shell script to do your backup (using whatever means you like; more in a moment) and a cron job (think "task scheduler" if you are not familiar with cron) to run the script periodically. So you have to figure out how you want to back up the database. You might generate an sql dump of the whole thing with mysqldump and save the results to a file (on disk or on a tape). You might connect to the database, lock the tables, copy the filesystem files themselves, and then unlock. You might store the files on mirrored disks and then temporarily break the mirror and back up from the quiet copy. You might set up a slave server to replicate the database and then back up *that* version instead. Our needs are simple; I use mysqldump. I've created a database user (let's call it backups for this example, because I didn't really) with SELECT privileges on everything so that it can read every column of every row of every table of every database in the system. Then I just run OUT=`date +%Y-%m-%d` mysqldump --user=backups --opt --all-databases | \ gzip -9 > \ /path/to/backups/dump.$OUT.sql.gz once a day and there we go. I won't write a password in a shell script file, but I *would* like to have a secure way of authenticating the user, like "only root@localhost can connect as dumper@localhost" through some certificate or the like, but I haven't gotten around to that yet. % % Backup is such an important issue. Why does it seem like it is something % that the developers don't care about? Well, there again you're crossing functionality... The developers care about the database engine and how to get data in and out quickly; backup is an entirely separate issue. Yes, it's important, but it's very much a different animal -- and so it shouldn't be part of the same package. HTH & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+Gz1FGb7uCXufRwARAibPAKDm6kfYnl1RzI107xS/juKLQBwfQgCgtFOf MbIB7v9bZgjMRJOjKAtjznU= =+W9p -END PGP SIGNATURE- - 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: Admin/Client GUI - Win32 and Linux
I like SQLyog http://www.webyog.com/ JFercan ** sql ** -Original Message- From: Nilza Lafayette [mailto:[EMAIL PROTECTED]] Sent: January 2, 2003 14:59 To: [EMAIL PROTECTED] Subject: Admin/Client GUI - Win32 and Linux I'm running MySQL onto a Windows Advanced Server. I4m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? Thanks. Janine. = Janine __ 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: Connecting M. Access Forms to insert data into mysql
Have you tried Linking the MySQL tables into access? I do not know why you would still have a memo field. Also if you need it you could map the memo field in Access to a TEXT or a BLOBTEXT in MySQL. If you have access to Visual Basic it could be a bettere option. HTH JFernando ** sql ** -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: December 14, 2002 22:11 To: MySQL List Subject: Re: Connecting M. Access Forms to insert data into mysql I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for management - but the shit for a single user wanting to add data like access in forms. My problem is if I use Access for the front end it doesn't always out put the memo fields right. So I want a client GUI that specifically will allow one record / page. Making it very user friendly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: "Grant Cooper" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to insert data into mysql > I am trying to find a package to insert data. And was wondering if I can use > odbc drivers to connect Access to mysql in real time? > > > - > 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: start value in table
I believe it is CREATE TABLE{ id AUTOINCREMENT=1000, fld TYPE } HTH JFernando ** sql ** -Original Message- From: Martin Skjöldebrand [mailto:[EMAIL PROTECTED]] Sent: December 27, 2002 16:34 To: MySQL epostlista Subject: start value in table Sorry for this newbie question (my MySQL-book is at work). I want my ID field to start with value 1000 and (preferably) auto-increment to 2000 is this possible to specify in my table somehow? (I know auto-increment, just how do I set the starting value). What would the appropriate SQL-sentence to update the table be? Cheers, Martin S. -- Martin Skjoldebrand http://www.skjoldebrand.org - 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: What terminates a query?
What about the semi-colon (;) or (\g)? JFernando ** sql ** -Original Message- From: Matt Young [mailto:[EMAIL PROTECTED]] Sent: December 23, 2002 12:53 To: [EMAIL PROTECTED] Subject: What terminates a query? My sql command pipes its result to a perl program (in batch mode) . but the perl program has no waf to tell when the query is finished. HTTP uses a blank line to signal the end. but there is no such thing for mysql. - 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: MyODBC with text files
I think you need the ODBC driver for plain text files to do so. It is generally installed in Win32, but I do not know about Linux. As to use MyODBC for that, I do not think it will work. HTH JFernando ** sql ** -Original Message- From: Nikola Pentchev (ESA) [mailto:[EMAIL PROTECTED]] Sent: December 20, 2002 02:11 To: '[EMAIL PROTECTED]' Subject: MyODBC with text files Hello, I am writing this e-mail just to ask about the following: I plan to implement some data storage in flat ASCII files. I want to work with SQL in order to automate requests from/to the files. Can I use MyODBC in order to work against flat files? If yes, what do I need to install (can I just install MyODBC and use the C API)? I am working on Solaris 8 Thanks Nikola Pentchev Lead Designer Ericsson South Africa (Pty) Ltd Tel: +27 11 844 2254 Fax: +27 11 844 2279 Mobile: +27 83 222 6063 ECN: 820 2254 - 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: ADODB XML Update Recordset
How are you working with them? They are working form me doing the following: In one side this is what I do. Set rst = dbConn.Execute("SELECT STATMENT") strFileName = "C:\\Path\file.xml" rst.Save strFileName, 1 'adPersistXML Then to read it back I just do this? strFileName = "C:\\Path\file.xml" rst.Open strFileName That works for me HTH JFernando ** sql ** -Original Message- From: Karl Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: December 15, 2002 00:46 To: [EMAIL PROTECTED] Subject: ADODB XML Update Recordset Has anyone any luck performing batch update with a persisted ADO XML recordset? I'm trying to save data from one MySQL server and then upload/insert to another. I'm trying to get these persisted XML recordsets to work, but having no luck. Any ideas? Karl - 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 MS Access as front end to mysql database
Just be careful because the connection can be looked at and if there is sensitive data going through someone who wants to can get their hands on it. The data travelling from the server to the client is not encripted and as far as I know there are not any hosts that will offer MySQL with the SSL support as it is not 100% working yet. Just something to think about. JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 14, 2002 16:33 To: JamesD Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Using MS Access as front end to mysql database Yup, agreed. MySQLODBC works over TCP/IP fine. I'm currently tunneling through a Linksys router to a database I have at home. If your provider is unwilling to compromise, it maybe time to look for another host. There are plenty of MySQL and MS SQL hosts who allow TCP/IP connections. At 11:56 AM 12/14/2002 -0800, JamesD wrote: >they can do it. they just dont want to. >firewall rules can be established to allow >connects to the mysql port from only the ip's >assoc with your remote offices, etc etc > >the answer is you can do what you want. You >just need a business partner who can service >his customer properly. > >mysqlODBC can do what you want. where mysql is >located is irrelevant, in the grand sense. >you just point to an ip and a port. etc etc > >James Danforth > > >-Original Message- >From: Donna Flanders [mailto:[EMAIL PROTECTED]] >Sent: Friday, December 13, 2002 6:59 AM >To: [EMAIL PROTECTED] >Subject: Using MS Access as front end to mysql database > > >We have been informed by our web hosting site that we cannot connect >remotely to our mysql database using any kind of connection other than a >script from >a web page or phpMyAdmin. It is our intent to have our data stored in a >mysql >database on the web and use MS Access as the front end to the database. > >Our reasons are - we have an existing Access database with a small number of >users at different locations that need to be entering data, running reports >and queries. We also have a large number of agencies that would hit the >database. It was our intent to migrate the data tables to mysql and leave >MS Access as the front end. When we asked our web host about this, they >responded this way: > >Due to security concerns you would not be able to connect to our mysql >server thru an external terminal directly as a mysql client. You would >be able to use mysql services only thru Web sevices i.e either thru php >scripts or thru phpmyadmin in Control panel-->Advanced Menu-->Sql >Databases >_ > >My questions are - Is this true of all web hosts or just the one we are >using? Our current hosting plan is a shared hosting plan. Do we have to >have a dedicated database server to do this? Knowing that we want to keep >MS Access as the front end, are there other options we have not explored? > > > > >- >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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Why do you have to do it that way? Could you do it in a loop? Do Until rst.EOF dbConn.Execute("INSERT STATMENT"); Loop JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: "INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1);"? If I submit multiple statements I get a SQL error. At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote: >Have you try this: > >dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1, >val2),(val1,val2),(val1,vla2);") > >JFernando >** sql ** > >-Original Message- >From: Michael She [mailto:[EMAIL PROTECTED]] >Sent: December 10, 2002 12:08 >To: Fernando Grijalba >Cc: MySQL Help >Subject: RE: ADO Bulk Inserts > > >Same table, but it shouldn't matter right? > >I'm getting a SQL syntax error once I start combining my statements >together. If I submit the statements separately they're OK. > > > >At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: > >Are the inserts to the same table or different tables and columns? > > > >JFernando > >** sql ** > > > >-Original Message- > >From: Michael She [mailto:[EMAIL PROTECTED]] > >Sent: December 9, 2002 14:56 > >To: MySQL List > >Subject: ADO Bulk Inserts > > > > > >Hi All, > > > > > >Does MySQL allow for Bulk Inserts via ADO? > > > >I can get a single insert statement to be inserted, but if I try t > >concatenate multiple inserts, I get a sytax error. > > > >I tried putting a space between each statement, return charater, > >semi-colon, etc, but it doesn't work. > > > >I'm doing the inserts through a ADODB.Connection. > > > >Thanks. > >-- > >Michael She : [EMAIL PROTECTED] > >Mobile : (519) 589-7309 > >WWW Homepage : http://www.binaryio.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 > >-- >Michael She : [EMAIL PROTECTED] >Mobile : (519) 589-7309 >WWW Homepage : http://www.binaryio.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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Have you try this: dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1, val2),(val1,val2),(val1,vla2);") JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Same table, but it shouldn't matter right? I'm getting a SQL syntax error once I start combining my statements together. If I submit the statements separately they're OK. At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: >Are the inserts to the same table or different tables and columns? > >JFernando >** sql ** > >-Original Message- >From: Michael She [mailto:[EMAIL PROTECTED]] >Sent: December 9, 2002 14:56 >To: MySQL List >Subject: ADO Bulk Inserts > > >Hi All, > > >Does MySQL allow for Bulk Inserts via ADO? > >I can get a single insert statement to be inserted, but if I try t >concatenate multiple inserts, I get a sytax error. > >I tried putting a space between each statement, return charater, >semi-colon, etc, but it doesn't work. > >I'm doing the inserts through a ADODB.Connection. > >Thanks. >-- >Michael She : [EMAIL PROTECTED] >Mobile : (519) 589-7309 >WWW Homepage : http://www.binaryio.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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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: ADO Bulk Inserts
Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a single insert statement to be inserted, but if I try t concatenate multiple inserts, I get a sytax error. I tried putting a space between each statement, return charater, semi-colon, etc, but it doesn't work. I'm doing the inserts through a ADODB.Connection. Thanks. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
Parece que el user mysql no tiene permiso para escribir en el directorio donde le has puesto que ponga el soket. Asegurate de que el directorio data el dueño sea mysql. Espero que te ayude JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]] Sent: December 5, 2002 12:47 To: [EMAIL PROTECTED] Subject: MySQL Server Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente: bind on unix socket : permission denied Donde reside el problema? Gracias ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
En que sistema lo instalaste? Yo hice la instalacion en Red Hat 8.0 y lo instalo en /usr/local/mysql(version infor) y luego tuve que crear un link (/usr/local/mysql) que apuntara a ese directorio. JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]] Sent: December 4, 2002 07:27 To: MySQL List Subject: MySQL Hola, He instalado MySQL 3.23.53a y en numerosos documentos veo referencias a '/usr/local/lib/mysql' cuando dicho directorio en mi sistema no existe, así como a la libreria libmysqlclient.so He hecho algo mal en la instalación? Puedo crear dicho directorio consiguiendo los archivos de algun lugar? Gracias Vicente --- Hello, I have installed MySQL 3.23.53a and I have seen in a lot of places references to '/usr/local/lib/mysql' directory, and this doesn't exist in my system. Also I have seen references to 'libmysqlclient.so' in this directory. Have I made something wrong during the installation? Can I create these directory and copy its files from somewhere? Thank you Vicente ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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: Graphical client
I really like SQLyog. You can find it at http://www.webyog.com/ JFernando ** sql ** -Original Message- From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] Sent: November 27, 2002 10:26 To: [EMAIL PROTECTED] Subject: Graphical client Does anyone know a good graphical mysql client for windows and linux? Massimo Bandinelli System Administrator mob +39 335 7324615 - Register.it S.p.A. - Gruppo DADA tel +39 199 REGIST (+39 199 734478) fax +39 035 3230312 http://we.register.it 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: getting InnoDB running on windows 2000
In your InnoDB Section you need: innodb_data_home_dir = c:/mysql/innodbdatapath set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/mysql/innodblogspath set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=3M innodb_log_arch_dir = c:/mysql/innodblogspath innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 make sure that the paths used exist before you bring the server back up otherwise innodb will not create the files because the directories do not exists. HTH Jfernando ** sql ** -Original Message- From: Bruce Kuppers [mailto:[EMAIL PROTECTED]] Sent: November 22, 2002 22:36 To: mysql help email Subject: getting InnoDB running on windows 2000 I have mysql running using its standard myisam database. The server is version 3.23.39-max, clien 3.23.36 Operating system Windows 2000 5.00.2195 Service pack 2 I am using the following my.ini #This File was made using the WinMySQLadmin 1.1 Tool #11/21/2002 9:16:12 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.100 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # my.ini file to invoke InnoDB option for mysql # - example form page 508 of manual # innodb_data_file_path = ibdata1:50M:autoextend # # set buffer pool size to 50- 80% (for now less) # #set-variable = innodb_buffer_pool_size=60M #set-variable = innodb_additional_mem_pool_size=10M # # log file 25% of buffer pool size # #set-variable = innodb_log_file_size=20M #set-variable = innodb_log_buffer_size=8M # # flush log commit - value of 0 loses transactions #innodb_flush_log_at_trx_commit=1 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=Bruce password=Lillian1 I get the following message: - 020329 1:07:55 Aborted connection 1 to db: 'test' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 020329 12:55:30 Aborted connection 4 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html the database will not come up or generate the files needed for InnoDB, and when I bring up in default - haveinnodb = DISABLED Can anyone tell me what I am doing wrong? Thanks Bruce A R Kuppers B.Sc.(Hons), M.Sc., Ph.D. Phone: (250) 656-3678 Toll Free: (866) 605-0259 E-Commerce -- Wave of the Future! Get Involved! Claim Your Future! Ask How! Visit: www.bww.com/kuppers Password: bruce - 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: why so slow?
What version of MySql? Are you connecting from Access? Are the server and the front end on the same machine? Jfernando ** sql ** -Original Message- From: Weiwei Wang [mailto:[EMAIL PROTECTED]] Sent: November 22, 2002 11:51 To: [EMAIL PROTECTED] Subject: why so slow? Hi,all: I am running my project based on the MySql ODBC connection. Now the operations including select,update and delete to the tables are so slow compared with the former MS Access ODBC connection. COULD U TELL ME HOW TO FIX THIS? thanks a million!! weiwei - 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: SELECT Statement Question
You should write: SELECT postcode FROM TABLE_NAME; This will display the postcode from your table? Jfernand ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: November 20, 2002 16:12 To: [EMAIL PROTECTED] Subject: SELECT Statement Question Hi I am a beginner in using mysql on Windows platform, and I have a question regarding the use of "SELECT * from TABLE_NAME" statement within the mysql prompt. I have a table of consisting of three columns POSTCODE, SUBURB, STATE where the primary key is a composite of all three fields. When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of data and some of my data is not shown. However when viewed from within a tool like PHP MYADMIN all the data is displayed correctly. Is this a bug or a limitation of mysql? Or am I doing something wrong? Any advice/help would be most appreciated. Thanks Best regards Boris - 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: yo
Hola Roberto, Si tu vas a http://www.free-translator.com/ y le ponse http://www.mysql.com/documentation/mysql/full/ en Systran, traducira la documentacion de MySQL a la lengua que seleciones. Entonces asi lo puedes grabar en to computadora y ya vas a tener por donde empezar. Se va a demorar un poco porque es toda la documentacion en una sola pagina. Si quiere puede ver el Ingles en partes y luego ir a free-translator y poner la direccion de solamente esa pagina. Espero que esto the ayude. JFernando ** sql *** -Original Message- From: Roberto Ramos [mailto:rramos@;almagro-norte.ucentral.cl] Sent: November 12, 2002 14:16 To: [EMAIL PROTECTED] Subject: yo Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows. - 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 Query
Is this line correct? MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Or should it be: MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE JFernando ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] Sent: November 7, 2002 16:18 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: SQL Query Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Mar ke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 Regards, Sam - 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: ActiveX error Visual Basic Integration MySQL
Either you are not referencing the correct library for the database access or you cannot doit from the Learning Edition. HTH JFernando ** sql *** -Original Message- From: Oliver Gottwald [mailto:goto1@;enteract.com] Sent: November 6, 2002 22:26 To: [EMAIL PROTECTED] Subject: ActiveX error Visual Basic Integration MySQL Hi, I'm attempting to get the MySQL ODBC Drive to work with Visual Basic 6.0 Leaning version I'm getting the following error: Run-time error '429': ActiveX component can't create object On the following line cnMySql.CursorDriver = rdUseOdbc Does anyone have any idea what I might be doing wrong? Oliver - 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
InnoDB row level locking?
In the documentation it says that InnoDB supports row level locking. How can I ensure that rows are locked using ADO in a VB Applications communicating with MySQL through MyODBC? I have tried setting my Recordsets to adLockPessimistic, but that does not seam to work. Any help will be really appreciated. Thank you, JFernando ** sql ** - 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: behaviour of WHERE clause with empty fields
I think this is because a NULL is not and empty string. They are different things. to match NULL you got to do: WHERE grp IS NULL or to exclude NULL: WHERE grp IS NOT NULL. I think that NULL values are excluded from string comparisons. I might be wrong though! JFernando ** sql ** -Original Message- From: Gonzo McMuppet [mailto:gonzo@;raq566.uk2net.com] Sent: November 1, 2002 16:29 To: [EMAIL PROTECTED] Subject: behaviour of WHERE clause with empty fields >Description: Empty fields are not matched using where clause NOT IN NOT LIKE NOT REGEXP Also not matched using regular expression negation [^] >How-To-Repeat: SELECT * FROM bugtest WHERE grp REGEXP '[^AB]' Returns only grp = 'C' not grp undefined (presumably NULL) SELECT * FROM bugtest WHERE grp REGEXP '[AB]' Correctly returns rows where grp = 'A' or 'B' SELECT * FROM bugtest WHERE grp NOT REGEXP '[AB]' Returns only rows where grp = 'C' and not undefined Similar behaviour with LIKE and IN >Fix: Puzzled? Am I not understanding something? >Submitter-Id: >Originator:Kevin McManus ([EMAIL PROTECTED]) >Organization: The University of Greenwich Park Row Greenwich London SE10 9LS > >MySQL support: none >Synopsis: behaviour of WHERE clause with empty fields >Severity: serious >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribution) >Environment: System: Linux raq566.uk2net.com 2.2.16C28_III #1 Mon Jul 30 22:07:58 PDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jan 20 2001 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273284 Sep 5 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 5 2000 /usr/lib/libc.so lrwxrwxrwx 1 root root 19 Sep 26 2001 /usr/lib/libc-client.a -> /usr/lib/c-client.a Configure command: ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/tmp/mysql.so ck --with-mysqld-user=mysql Perl: This is perl, version 5.005_03 built for i386-linux - 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: Creating users through SQL
Create the record for the user in the user table (do not forget to do password=PASSWORD('pastext')) Then insert a record in the db table with the db name you want them to access and the options. HTH. JFernand ** sql ** -Original Message- From: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Sent: October 31, 2002 16:49 To: [EMAIL PROTECTED] Subject: Creating users through SQL How do I create users for a specific database using SQL? - 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 UPDATE question
Why not only do: conn.beginTrans(); //Statments conn.commit(); or conn.rollback(); -Original Message- From: David Shanes [mailto:dshanes@;san.rr.com] Sent: October 31, 2002 12:12 To: [EMAIL PROTECTED] Subject: SQL UPDATE question Filter: SQL, UPDATE Is there a way to do the following in one single statement? I know I can get all of the info from the three tables in a single query using joins... // Start a transaction conn.setAutoCommit(false); // Do the work. stmt = conn.createStatement(); // Update general acct info sSQL = "UPDATE t_account " + "SET fkCustomerId=" + cdVO.getIdCustomer() + ", " + "dateCreated=" + cdVO.getDateCreated() + ", " + "dateClosed=" + cdVO.getDateClosed() + ", " + "balance=" + cdVO.getBalance() + " " + "WHERE id=" + cdVO.getIdAccount() + ";"; stmt.executeUpdate(sSQL); // Update investment specific acct info sSQL = "UPDATE t_accountinvestment " + "SET investmentObjective=" + cdVO.getObjective() +" " + "WHERE id=" + cdVO.getIdAccount() + ";"; stmt.executeUpdate(sSQL); // Update cd specific acct info sSQL = "UPDATE t_accountcd " + "SET dateMaturity=" + cdVO.getDateMaturity() + ", " + "isDivReinvested=" + cdVO.getIsDivReinvested() + " " + "WHERE id=" + cdVO.getIdAccount() + ";"; stmt.executeUpdate(sSQL); conn.commit(); Thanks, David - 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 import a database
How about exporting the data to text files and then importing them into MySql. Also you can try to write a VBScript (If you are using Win32) that connects to both databases and select a table from one and run inserts to the other. HTH. JFernando *** sql *** -Original Message- From: tosca ballerini [mailto:ballerini@;faunalia.it] Sent: October 31, 2002 08:18 To: [EMAIL PROTECTED] Subject: how to import a database hello everybody, I just started working with mysql and php and I want to import a database from filemaker to mysql: is that possible? and how? thanks in advace for the help Tosca - 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]: Start Transaction in InnoDB
This is what I think. When Autocommit is set you DO NOT have to enter COMMIT after you update your DB (Update, Insert Delete), but you will be changing the DB after every statement, therefore you cannot change your mind after the command is execute. Now as for BEGIN, it will begin a Transaction regardless of the Autocommit value. Therefore if you have Autocommit set, but you do: BEGIN; SQLCOMMANDS; COMMIT OR ROLLBACK; The changes will be save only at the COMMIT or if you do not want the changes to take effect you can ROLLBACK. When Autocommit is not set you MUST COMMIT after your SQL statement in order for the changes to be written into the DB regardless as to you start or not with BEGIN. HTH JFernando *** sql *** -Original Message- From: Peter Brawley [mailto:peter.brawley@;artfulsoftware.com] Sent: October 30, 2002 12:38 To: Dyego Souza do Carmo; Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: Re[2]: Start Transaction in InnoDB Dyego, BEGIN, not set begin. My understanding is that BEGIN is a synonym for SET autocommit=0. PB - > AB>> I would like to know, how can I start a new transaction using InnoDB Tables? > > EE> Use BEGIN statement: > EE> http://www.mysql.com/doc/en/COMMIT.html > > EE> Don't forget to SET AUTOCOMMIT=0; > > > What is the diference of SET AUTOCOMMIT=0; > > and set BEGIN; ? > > If I start the transaction with "BEGIN" and without "SET AUTOCOMMIT=0" what will happen ? > > what is the diference ? - 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: ODBC problem
Make sure that Return matching rows is checked in your DSN Configuration. Also you can try a DSN-Less Connection like sql_connection.ConnectionString="Driver={MySQL};server=localhost;DB=DBName;U ID=;PWD=" For MySQL 3.51.04 you have to write Driver={MySQL 3.51.04} for it to work. HTH JFernando *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 09:55 To: MySQL Help Subject: RE: ODBC problem It's ADODB. Here is the "open" code : [...] Set sql_connection = New ADODB.Connection sql_connection.ConnectionTimeout = 10 sql_connection.CommandTimeout = 10 sql_connection.ConnectionString = "Data Source=MoniteurReseau" sql_connection.Open [...] In my ODBC data source "MoniteurReseau" I only specify the database name and the host (localhost). At home (on my own computer) I specify no user (no restriction for any user), and at work I specify "root" as user and the password. The open is done without error, except if I close it and reopen. But the first time the "bug" is on my update request. Sam. -Message d'origine- De : Fernando Grijalba [mailto:fernando@;ggtours.on.ca] Envoyé : mercredi 30 octobre 2002 15:47 À : MySQL Help Objet : RE: ODBC problem How are you connecting your app? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request, exactly copied from VB debug : --- update adresses_a_surveiller setetat_reseau =1, etat_point_acces=1 where adresse_reseau='10.0.1.253' --- The error message I get is : --- [MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max-nt-log]MySQL server has gone away --- The request is ok according to the table structure, I tried to cut/paste it and run the reqest in MySQL interpreter, and my update is done ! The table structure is (I added a timestamp according to the documentation about ODBC) : --- CREATE TABLE IF NOT EXISTS adresses_a_surveiller ( adresse_reseau VARCHAR(128)NOT NULL, libelleVARCHAR(128), adresse_point_accesVARCHAR(128), etat_reseauINTEGER(1) DEFAULT 1 , etat_point_acces INTEGER(1) DEFAULT 1 , odbc_timestamp timestamp, PRIMARY KEY (adresse_reseau) ) TYPE=InnoDB; --- Another problem : when I restart my VB projet, or if I force to close an reopen my ODBC link to the database before the update, I get this error message : --- [MySQL][ODBC 3.51 Driver]Can't create TCP/IP sicket (10093) --- I don't understand why it doesn't work... any advice ? Thanks in advance. Sam. - 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 - 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: access2mysql data types
I use TINYINT. it stores 0 for false and 1 for true. I tried with enum, but the communication with MS Access was not happening. In Code you can treat this as a Boolean and in the UI if you have checkboxes the values of 1 or 0 also work. HTH. JFercan *** sql *** -Original Message- From: Angelo Carmo [mailto:angelocarmo@;horta.com.pt] Sent: October 29, 2002 20:37 To: [EMAIL PROTECTED] Subject: access2mysql data types Hi people, what is the best type to substitute the boolean type of msaccess tables. Or mysql databases support the boolean type? Angelo. - 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: ODBC problem
How are you connecting your app? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request, exactly copied from VB debug : --- update adresses_a_surveiller setetat_reseau =1, etat_point_acces=1 where adresse_reseau='10.0.1.253' --- The error message I get is : --- [MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max-nt-log]MySQL server has gone away --- The request is ok according to the table structure, I tried to cut/paste it and run the reqest in MySQL interpreter, and my update is done ! The table structure is (I added a timestamp according to the documentation about ODBC) : --- CREATE TABLE IF NOT EXISTS adresses_a_surveiller ( adresse_reseau VARCHAR(128)NOT NULL, libelleVARCHAR(128), adresse_point_accesVARCHAR(128), etat_reseauINTEGER(1) DEFAULT 1 , etat_point_acces INTEGER(1) DEFAULT 1 , odbc_timestamp timestamp, PRIMARY KEY (adresse_reseau) ) TYPE=InnoDB; --- Another problem : when I restart my VB projet, or if I force to close an reopen my ODBC link to the database before the update, I get this error message : --- [MySQL][ODBC 3.51 Driver]Can't create TCP/IP sicket (10093) --- I don't understand why it doesn't work... any advice ? Thanks in advance. Sam. - 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: Query and export to a Excel file
If you have Excell you can use the Get External Data to get the data from MySQL using MyODBC. Also you can use MSQuery to query the database and send the result to Excel. Another way would be to write a macro that uses ADO and process the results into the workbook. HTH JFernando *** sql *** -Original Message- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: October 29, 2002 04:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - 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
Building MySQL 4.0.4 with Borland 5.0.2
Has anyone had any luck building MySQL 4.0.4 from the win32 source using the Borland 5.0.2 Compiler? Please let me know if it is possible and where can I find some guidance as to what I have to do. Thank you, JFernando *** sql *** - 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: innodb tablespace size
My guess is that you can not operate the db when space is required and you get error message. Like when trying to alter a table it will tell you that the table is full. This is because MySQL will create a temporary table drop the original and rename the new one. HTH JFernando -Original Message- From: Natale Babbo [mailto:natale_babbo75@;yahoo.it] Sent: October 25, 2002 08:51 To: [EMAIL PROTECTED] Subject: innodb tablespace size innodb_data_file_path=ibdata1:100M:autoextended:max:200M anyone knows what happen if the above innodb tablespace reach the limit of 200M? Thanks in advance. Natale Babbo sql __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.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
MySQL 4.0.4 Difference
I would like to know what is the difference between MySQL 4.0.4 MAX & PRO. Thank you JFernando *** sql *** - 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 execute sql commands from a file?
You can try this; mysql>source /path/source.sql or: $>mysql -uuser -ppassword DBname < filename.sql HTH JFernando ** sql *** -Original Message- From: Andre Kirchner [mailto:sieg1974@;yahoo.com] Sent: October 22, 2002 15:58 To: [EMAIL PROTECTED] Subject: How to execute sql commands from a file? Hi there, is there a way to execute sql commands from a file? What would be the syntax to do it? I was trying mysql> @theFile, but it doesn't work. Thanks, Andre __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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 execute sql commands from a file?
You can try this; mysql>source /path/source.sql or: $>mysql -uuser -ppassword DBname < filename.sql HTH JFernando ** sql *** -Original Message- From: Andre Kirchner [mailto:sieg1974@;yahoo.com] Sent: October 22, 2002 15:58 To: [EMAIL PROTECTED] Subject: How to execute sql commands from a file? Hi there, is there a way to execute sql commands from a file? What would be the syntax to do it? I was trying mysql> @theFile, but it doesn't work. Thanks, Andre __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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: Which files to download/install - problems running MySQL
Hello, This is the my.cnf that I use in my syste. It is located in C:\. You can use it as guide. Start ## #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=D:/MySql datadir=D:/MySql/data log-bin=D:/mysql/Data/mysqllogs/binarylog log-bin-index=D:/mysql/Data/mysqllogs/binaryindex binlog-do-db=GGData local-infile=1 #InnoDB Settings innodb_data_home_dir = D:/MySql/GGData innodb_data_file_path = ggdata1:20M;ggdata2:20M;ggdata3:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:/MySql/GGData/logs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=3M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:/MySql/GGData/logs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 ### End Make sure that the InnoDB directories exists in your computer, both the data_home_dir and the log_group_home_dir. Also make sure to delete the my.ini that was probably created in your windows directory. After you create the directories and the my.cnf file just open a dos windows and from the bin directory run mysqld or mysqld-max. Hope this helps JFernando *** sql *** -Original Message- From: Nikki Mason [mailto:nikki_mason@;btopenworld.com] Sent: October 21, 2002 15:22 To: Miguel Angel Solórzano Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Fw: Which files to download/install - problems running MySQL My email below was rejected for some reason, so I am trying again to send it. Regards, Nikki - Original Message - From: Nikki Mason <[EMAIL PROTECTED]> To: Miguel Angel Solórzano <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 20, 2002 8:41 AM Subject: Re: Which files to download/install - problems running MySQL > Miquel, > > I tried what you suggested, but still it didn't work properly. > > For the server: > C:\>cd mysql\bin > > C:\mysql\bin>mysqld-opt --standalone --console > 021020 8:20:30 InnoDB: Out of memory in additional memory pool. > InnoDB: InnoDB will start allocating memory from the OS. > InnoDB: You may get better performance if you configure a bigger > InnoDB: value in the MySQL my.cnf file for > InnoDB: innodb_additional_mem_pool_size. > > The cursor did not return to the prompt to allow anymore commands to be > typed. > (I haven't created a c:\my.cnf or c:\windows\my.ini) > > For the client: > C:\mysql\bin>mysql -uroot -p > Enter password: > > Again, nothing more was displayed on the screen and the cursor did not > return to the prompt to allow anymore commands to be typed. > > Regards, > Nikki Mason > > - Original Message - > From: Miguel Angel Solórzano <[EMAIL PROTECTED]> > To: Nikki Mason <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Saturday, October 19, 2002 9:29 PM > Subject: Re: Which files to download/install - problems running MySQL > > > At 15:16 19/10/2002 +0100, Nikki Mason wrote: > Hi, > >Hi, > > > >I wish to learn SQL, and as some of my friends already use MySQL, they > >recommended that I too use it. Please can you tell me what I need to > >download and install to get me going. > > > >I have: > >Pentium III 450Mhz, 256Mb Ram > >Windows 98 > >I don't have a C or C++ compiler installed. > >My PC is not connected to a network - it is standalone. > > > >I had earlier downloaded just the zip file for version 4.0.4-beta > (Windows). > >I unzipped it and ran the 'setup' program. > > > >Once setup had completed I tried the test on the server - at no point had I > >run the Admin program or created the my.cnf or my.ini. > > > >I opened a dos window and from the directory c:\mysql\bin entered: > >mysqld --standalone > > > >No other text was shown in the dos window and it appeared to hang. The > >whole computer also seemed to 'hang'. I had to use ctrl C to kill the > >application and get back normal operation to my PC. > > Why you had killed the mysqld server ?. The mysqld.exe is a console > application that when started with --standalone option it works in > the background. > > If you want to see the console screen then issue: > > C:\mysql\bin>mysqld-opt --standalone --console > 021019 17:25:31 InnoDB: Started > mysqld-opt: ready for connections > > and for to work with the mysql client: > > C:\>c:\mysql\bin\mysql -uroot -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 3.23.53-max > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > after a fresh installation left the root password blank. > > for to shutdown the server: > > > C:\>c:\mysql\bin\mysqladmin shutdown > > 021019 17:27:27 mysqld-opt: Nor
MySQL 4.0.4 Question
You guy recommend that I download the binaries instead of the source code. In the Win32 version of 4.0.4 is SSL enabled or do I need to download the source code and apply the flags that you mention in your sort version of the SSL Documentation so far. Also I would like to know if the Pro version has support of InnoDB or do I have to download the Max version Thank you, JFernando ** sql ** - 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
Is this possible - Remote Connection with SSL
I would like to know if this is at all possible using MySQL 4.0.4 in Windows. We want to be able to host our web site using either Windows and ASP or Linux and PHP in our service provider server. All the scripts will be in their machine away from our network. Then I would like for those scripts to have access to our MySQL Server in our internal network. The reason is that we sell airline tickets and we would like the travel agents to book on the site and be able to read the inventory as it changes either form bookings on-line or in site. I was wondering about using SSL from the ISP's machine to ours or using some kind of VPN. Please, any help in this matter will be really appreciated. Thank you, Fernando *** 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