A Blob That's a String??

indicates to me that a binary file has indeed been loaded. What I am trying to ascertain is why is this longblob considered a string? How can I more properly test if a binary file has been loaded? TIA, Jack

RE: A Blob That's a String??

= cursor.fetchall()[0][0].tostring() to this: content = cursor.fetchall()[0][0] I get this error: What's frustrating is that this code had worked before. That is why I ask, how do I test that MySQL has uploaded a binary file? TIA, Jack

ordered list of titles, with fallback if title is only available in another language

value of column c? Much thanks, Jack signature.asc Description: This is a digitally signed message part

SQL for Subversion update-report

the database for a list of pages which changed since the current state of the working copy, and whether those pages are newly created? Much thanks, Jack signature.asc Description: Digital signature

LAMP Experts Needed

at [EMAIL PROTECTED] It is going to be a web interface interacting with a very large database. -- Jack Gates http://www.morningstarcom.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unknown command '\'' during load

or two in there, but apparently it doesn't work that way. On 3/17/06, Jack Baty [EMAIL PROTECTED] wrote: I'm trying to restore a database from a dump as part of my make-sure-this-will-restore-just-in-case process and I get the following error... ERROR at line 1189: Unknown command

Re: Unknown command '\'' during load

always something to look at when you start dealing in larger dumpfiles. I hadn't considered that. I think I'll also be dealing with net_buffer_length, since it seems that is what actually affects the dump insert statement size limit. I'll give it a whirl, thanks. -- Jack Baty Fusionary Media - http

Unknown command '\'' during load

to be able to restore it if necessary :) I'm just trying to figure out if it's a data problem, version problem, or something else. -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Query Question...

= 'TOW' GROUP BY w.WebsiteName, r.Cuisine Thanks. Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Question...

Sorry... I was having a brain fart. (I use entries in the web.xml file to generate a dropdown list of cuisines). The field cuisine is part of the restaurant table. And it does not accept a null value. It should be split out into it's own table. I do need to get a SUM of all the values

Query Question

RestaurantWebsites ON ( Restaurant.RestaurantID = RestaurantWebsites.RestaurantID ) WHERE RestaurantWebsites.WebsiteName = 'TOS' ORDER BY Cuisine ASC LIMIT 0 , 300 Thanks Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

ORDER by Question

it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER by Question

My thanks to all that responded. I used Mathias's suggestion to solve the problem. You can see the results here. http://www.tasteofwhatcom.com/restaurants-tow/filter.jsp?field=cityvalue=Blaine Thanks again for your help. Jack Mathias wrote: Selon Jack Lauman [EMAIL PROTECTED]: I'm

Calculate LONG/LAT from ZIP+4

A couple of months ago these was a discussion about ZIP code plotting on this list. Does anyone know how to calculate LONG/LAT coordinates from ZIP+4? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Can't create interrupt-thread (error 11, errno: 0)

hi ,guys. i tried to start mysqld it reports below ,can someone give me some advices? 050504 09:43:33 mysqld started 050504 9:43:33 [ERROR] Can't create interrupt-thread (error 11, errno: 0) 050504 09:43:33 mysqld ended Jack [EMAIL

can't start mysqld

jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Client Side Query cache

Hi, I was wondering if there is any query cache code/lib somewhere to cache certains queries ? I'm always doing the same queries, (and the result never change, so I could spare the round-trip to the server), but caching each tine the data for it is a bit of work. Thanks, for your suggestions --

Re: Warnings level

Hi, I got back warnings, event when started with mysql -v -v, I don't have the Warnings appearing on the console... Do I really have to insert SHOW WARNINGS; in the dump file after each statements ??? On Apr 7, 2005 6:10 PM, Mister Jack [EMAIL PROTECTED] wrote: Hi ! Thanks, for your answer

Re: Warnings level

'timestamp' at row 5407; (I still have to figure this out :) On Apr 8, 2005 6:08 PM, Mister Jack [EMAIL PROTECTED] wrote: Hi, I got back warnings, event when started with mysql -v -v, I don't have the Warnings appearing on the console... Do I really have to insert SHOW WARNINGS; in the dump file

Re: Warnings level

Hi ! Thanks, for your answer. Indeed, I didn't think about the verbose option. I tried it and used tee to log data. Well so far I haven't got anymore Warnings (strange though...) :-) On Apr 5, 2005 9:50 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Mister Jack [EMAIL PROTECTED] wrote

Warnings level

Hi, I've got a dump file from my main DB (MySQL 4.1.10a), when I load it with source backup.sql I can see some warnings around. Is there any way to log those warnings, or to stop on warnings ? (show warnings only show warnings for the _last_ query if there is any). Thanks for your help -- MySQL

Re: I am stupid

I would suggest to take a look at the documentation http://dev.mysql.com/doc/mysql/en/index.html 1. create a DB : http://dev.mysql.com/doc/mysql/en/index.html 2. using a SQL file to create those table. on the mysql commqnd line : source db.sql; So as a whole, you'll do something like : create

BDB storage engine

Hi, There is an extensive documentation for InnoDB, but I can't find any extensive for BDB (except http://dev.mysql.com/doc/mysql/en/bdb-storage-engine.html ). Can I change the isolation level in the same way than with InnoDB ? Can I also do SELECT FOR UPDATE ? thanks -- MySQL General

select timestamp + 0

Hi, i'm using the 4.1.10 version of mysql. If I do : select max(timestamp + 0 ) as timestamp from news; ++ | timestamp | ++ | 20050314194920 | ++ so i got the full timestamp(14), but if I do : select max(timestamp) + 0 as timestamp from news;

Re: select timestamp + 0

the max. is this a bug ? (the code rely heavily on a result as a timestamp(14), like MMDDHHmmss, so getting this work helps migrating from 4.0 to 4.1) thanks for your help On Wed, 16 Mar 2005 14:36:42 -0600, gerald_clark [EMAIL PROTECTED] wrote: Mister Jack wrote: Hi, i'm using

Re: How to add String to existing value of String

Look for concat : http://dev.mysql.com/doc/mysql/en/string-functions.html On Wed, 16 Mar 2005 15:51:34 -0500, David DeSana [EMAIL PROTECTED] wrote: I need to modify the value of file names in a table. The strings represent an image file path and are stored in a char column in the table. Here

Re: select timestamp + 0

(which is different from adding 0 to a timestamp). MIN/MAX operating on timestamp would have been more straightforward, no ? Or is there anything to coerce a string into a timestamp ? (appart a format ) On Wed, 16 Mar 2005 15:40:26 -0600, gerald_clark [EMAIL PROTECTED] wrote: Mister Jack wrote

Help with date query

= 1 WHERE TO_DAYS(NOW) - TO_DAYS(RenewalDate) 30; Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie question about blob data types ie. Storing .xls in blob

Is it possible to store an excel file into a blob field in mysql? If so how do I go about importing the file into the blob field, and get it back out into an .xls file? Thanks in advnace Jack Taffar AOG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Space is filling up

. And since hard drives are so cheap now, I'd be tempted to go that route even if he can age out data. I'm seeing ads for 200G drives for $90.00. Jack -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:06 PM To: 'Asif Iqbal' Cc: [EMAIL PROTECTED

RE: Space is filling up

If you database contains time-based data you could age out old records. I only need to keep data for 6 months so I run a nightly script to delete any records more than 6 months old. And before anyone asks...yes, I also run another script to ANALYZE/OPTIMIZE my tables. Jack -Original

RE: How to turn rows into columns

. Hope this helps, Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 2:34 PM To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: How to turn rows into columns What you are trying to create is called a pivot table or a cross-tab report

not unique table/alias

I have two complex subqueries that I need to join. I suspect this problem is due to using aliases instead of table names, but I don't know how to work around it (temporary tables?). Please help. SELECT col FROM (subquery-1) AS t1, (subquery-2) AS t2 JOIN t1 ON t2.col = t1.col; Not unique

DISTINCT query

runs fine. My problem is that I want to SELECT only DISTINCT values for interface.description and not display the descriptions in the result. Is this possible? And if so, how do I do it? Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

RE: DISTINCT query

and after data. Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 1:52 PM To: Jack Coxen Cc: MySQL List (E-mail) Subject: Re: DISTINCT query Jack, I am not sure what you want your output to look like... If you want the same columns

ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity

Re: Problem Installing MySQL Max

Lou Olsten wrote: I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

account for [EMAIL PROTECTED] with a password required to supplement the [EMAIL PROTECTED] with a password required. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com

RE: Case Sensitive

This isn't caused by MySQL. It's an OS issue. Linux and Unix are case sensitive operating systems so any program you run, unless it is specifically written to be NON-case sensitive, is case sensitive as well. Jack -Original Message- From: Andre MATOS [mailto:[EMAIL PROTECTED] Sent

RE: many updates really slow

by transmission time. Transferring the file in toto to the US server will be quicker than having the communications lag of doing sending a command from Europe to the US, having the command execute and then receiving the status back in Europe...times 5000 records. Hope this helps, Jack -Original Message

RE: many updates really slow

back to sleep. Jack -Original Message- From: William Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 1:43 PM To: Jack Coxen; [EMAIL PROTECTED] Subject: RE: many updates really slow Thanks Jack and Jeremy. But this is part of my application and I need to do this automatically. I

Complicated query problem

got to be a more efficient way of doing the same thing. I'm relatively new to MySQL so I took the brute force approach. My problem is that I want to produce totals of each of the columns and can't figure out how to do it. Any suggestions on how I can do this? Thanks, Jack Jack Coxen IP Network

RE: when 4.1.2 release

Is there a planned release date for the production version of 4.1 x? I'd love to be able to use sub-queries but I don't want to use a non-production version on a production database. Jack -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 6:30 PM

RE: export to csv or excel

is fairly easy and the documentation that comes with the module is clearly written with tons of examples. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705 -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April

Query in MySQL vs. PERL

running MySQL 4.0.16 standard on a Sun e250 running Solaris 8. The database consists of around 650 tables ranging in size from 20 KB to 3-4 GB (approx. 12 million records). Any help and advice would be greatly appreciated. If more info is needed, please let me know. Jack Jack Coxen IP Network

Re: MySQL 5.0 - What is really available?

I prefer SQLyog. www.webyog.com Ditto that. I used to use MySQL-Front, but switched when development stopped. I don't miss it really. The structure synchronization and db job agent features are maturing rapidly and work quite well. Saves a ton of time for me. Not sure about v5.0 support yet,

RE: Index not functioning - update

to but I'd prefer to fix the existing setup of a single index on dtime. Jack -Original Message- From: Jack Coxen [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 1:51 PM To: '[EMAIL PROTECTED]'; MySQL List (E-mail) Subject: RE: Index not functioning I tried using 'USE INDEX

RE: Index not functioning - update

No, this is a production system. I can't risk running non-production level software. I could try 4.1.1 on my development system but, even if it worked, I still couldn't put that solution into place on the production server. Jack -Original Message- From: dan [mailto:[EMAIL PROTECTED

Index not functioning

help would be greatly appreciated. Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

RE: Index not functioning

Is there a way of changing what it believes? The resultset size is only a few thousand lines. And, btw, why does it believe that a table scan is more efficient than using an index? Jack -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24

RE: Index not functioning

? The resultset size should be around 8640 rows - 5 minute interval data for 30 days - 12 X 24 X 30 = 8640 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 1:22 PM To: Jack Coxen; MySQL List (E-mail) Subject: RE: Index not functioning

RE: Re[2]: Index not functioning

hesitant to modify the index structure. I don't want to run into problems with future revisions. Right now, I just want my existing indexes to work. Jack -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 2:01 PM To: [EMAIL PROTECTED] Subject

Trusted Solaris

Has anyone had experience with running MySQL on Trusted Solaris? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Question

I have a table containing information about different businesses. I want to randomly select a single row from the table using a prepared statement in a java bean. What is the most eficient way to do this? TIA Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: LEFT JOIN to a table using 2 keys from different tables

the keys individually in two separate tables, [...] -- What we observe is not nature itself, but nature Jack McKinney exposed to our method of questioning. http://www.lorentz.com -Werner Karl Heisenberg [EMAIL PROTECTED

Mysql-standard-4.0.15 Library problem

of mysql when I've already insalled 4.0.15? Please advise. Thank you, -- Jack Gorski Parallel Software (630) 420-9929x12 mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

$sth-rows problem

method rows without a package or object reference at ./cleandb.pl line 34. Could someone please kindly point out the glaringly obvious thing that I'm missing? Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

RE: Delete questions and speed/safety issues

be to add another couple of drives to the server and then split the tables among them with links back to the original database directory - sort of 'poor man's RAID'. Drives I can get...it's the RAID controller and enclosure that is the sticking point. Jack -Original Message- From: Michael

Delete questions and speed/safety issues

be running at the same time then there's no problem. But if I have to shut down my application for any appreciable length I time, then I have to find another way of doing this. Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

Query question

= account.account_id) WHERE account.account_id = 13; One I get the query to work right I neet to write it to a file in CSV format. Any help would be appreciated. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join syntax diff 3.23 to 4.x?

Is there something about 3.23 that makes this illegal? It is fine on 4.012. SELECT [lots of columns] FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id JOIN list_states ls ON ad.state = ls.id WHERE p.company_id = 1 Will some minor rewording help it run on both versions OK? --

RE: Join syntax diff 3.23 to 4.x?

3.23 to 4.x? Try changing JOIN list_states to INNER JOIN list_states Looks like the earlier version didn't like your (synonymous) wording. -Original Message- From: Jack Dare [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 8:35 AM To: [EMAIL PROTECTED] Subject: Join syntax

Problem with date query

rows except those for the current date. How can I correct this? SELECT date, time, am_pm, tz, height, cond FROM cherry_point_tides WHERE TO_DAYS(date) - TO_DAYS(NOW()) = 6 and date NOW(); Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Really stupid Question...

to as shell prompts. Jack -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: Really stupid Question... I am a Windows User and very used to the Dos Prompt. Can someone please tell me what the Shell Prompt

Performance questions

table structure to use different indexes and modified the Perl/PHP scripts to suit those changes and gotten significant performance boosts from that. What I really need are system tweaks and configuration changes to improve performance. Jack Jack Coxen IP Network Engineer TelCove 712 North Main

Big Mistake Need Help, can I undo an action I did?

Hi guys, I had updated a field for all the entries in a table by mistake, I need to undo that step. I dont have the database back up to an stisfactory level. Is there a way in MySQL I can step one action back? or undo one command that I just did?? Thanks a lot guys!?

why it run so slowly

: WIN98 SE Jack __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php

Re: mysqld refuse to die

for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road

mysqld refuse to die

Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road

Re: mysqld refuse to die

I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED

Re: access denied for user: root@localhost

-w, --wait[=retries] Wait and retry if connection is down Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED

Re: access denied for user: root@localhost

Thanks, but I still got complains that can't access server: 'Access denied for user: 'root@localhost' (Using password: YES) Is it possible that for some reason the password is wrong? You input is greatly appreaciated, Puzzled newbie, Jack Jack

mysql: access denied for what?

Dear all, After I made mysqld running, I then tried: mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What does this mean? Thanks Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold

re: Can't run mysql after installation

Thanks Victoria, You are right. Thanks! But right now, I am stuck with the installation of Msql-Mysql-module. I know that I have to let the server run in order to do the make test part, but still 87% of the tests failed. Do you or anybody else have any suggestions? Jack

Can't run mysql after installation

Dear All, I met with this problem when I tried to run mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have already installed server, client, devel, and need to install bench. Thank you for suggestions! Jack

Problem: install Data-Dumper

: In function `XS_Data__Dumper_Dumpxs': Dumper.xs:643: `sv_undef' undeclared (first use in this function) make: *** [Dumper.o] Error 1 Could anybody advise me what's going on? Thanks, jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road

rpm -i MySQL: exist or not?

The strange thing I met with is that when I ran rpm -e XXX.rpm It said that the package in not installed. But when I ran rpm -i XXX.rpm It said that the package already exist. I am new to MySQL. Any idea is greatly appreciated. Jack Jack

how to make a MySQL server run and how to check

if the server is running? I tried to use: top | grep mysql - but not working. Any suggestions? Thanks! Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED

How to create a table from other tables

provide me a simple example! Thx 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

how to load data to a table's specific field

USD#rate When i import the csv file, it will only replace the field C without changing any values on field A B. Please help me with this, it is urgent!! Thx a lot Jack [EMAIL PROTECTED] - Before posting, please check

How to retrieve the lastest update or insert record?

Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] - Before posting, please check

Problem on Load Data!

i want to only insert this colume of data into hkd_deposit table's hkd_rate field! the other fields data of the table will remain the same! So how i can do it? Thx a lot! Jack [EMAIL PROTECTED] - Before posting, please check

How to Load a Database to other Server

! 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

problem on Load Data!

couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTECTED

Strange Command on Load Data!

Dear all I had use the Load Data Command to import my CSV file from my client side of pc to the Mysql database which located in Server side. The command i type is follow: Load Data local infile 'c:\\Doucments and Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_deposit1 fields

mysqldump does not seem to work as in documentation

Description: on red hat linux 7.2 on an intel box mysqldump --opt -u geo -pmy_pass --where=some condition AIRDB UniversalCdrEast | mysql --compress -h some_ip -u geo -pmy_pass AIRDB yielded an error 1035: empty query How-To-Repeat: Fix: had to spell

How to setup MySql on my Solaris 8?

entered /mysql/bin and tried running mysql, but get such an error message: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # I don't get it. Jack __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo

how to setup mysql with Solaris 8?

: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # And I get the error message shown above. What should I do to set it up? Thanks. Jack __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo

Re: printing camera-ready mysql report

Camera ready means the a commercial printer cn go direct from the provided document(s) to negatives/plates or direct to plate without having to modify the originals in any way. Save a lot of money in make up and AA charges. Jack Andrew Gould wrote: Please forgive my ignorance; but what

PCAnywhere like linux client - mysql data files administration

subject: PCAnywhere like linux client - mysql data files administration Hi, I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Thanks, Jack

Browser caching problem OR mysql/perl code?

I am using in perl. Any ideas how I can write my queries in a select so that it is sure to pick up any recently changed data from the database that might have just been written? Thanks, - Jack p.s. please cc: to [EMAIL PROTECTED

MyODBC Problem with SQL2000 - MySQL Data Transformation

failing with this error code. I'm beginning to think it is the MyODBC driver. I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL. Have any of you tried doing this yet? Just curious that maybe you have run into this before. Thanks, Jack [EMAIL PROTECTED

Security problem in Access database

Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

How to remove User in Mysql

Dear all As i had granted permission to user, now i want to remove particular permission off from the user, could you pls tell me how to do so??? And what should i do if i want to remove a user? is mysql got something like User Group Thx Jack

Question on auto_increment

the record in index 2 which is between 1 and 3, then will it leave a index gap between or it will move the record of index 3 up to index 2??? Thx Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual

samp_db?

The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore, please tell me where I can get samp_db, or another sample for me learn mySQL. -- Best regards Jack Su - Before posting, please check: http://www.mysql.com

salvaging database

don't know the size and type of all the fields. Thanks for your help, Jack Cushman (Please CC me; I'm not on the list) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Easiest way to create a duplicate of a db?

would most likely have to make the edits by hand to products.sql. or in keeping with my 'dangerous ideas' theme: mysqldump products | grep s/products/products1/ mysql (I am rusty on my regex so I'd check that s// expression before I used it) You'd want to use sed, not grep. -- Jack

Re: Diagrams and Flowcharts on mySQL tables

Try Dezign for Databases. Works pretty well and is much cheaper than the big ones (ER/Studio and ERWin) http://www.datanamic.com/dezign/ -- Original Message -- From: Robert Goeres [EMAIL PROTECTED] Date: Sat, 30 Jun 2001 16:37:28 +0200 I have a

Re: Hello please help me out

[EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen

  1   2   >