Re: MySql GUI

2006-05-30 Thread Anthony
Dan Trainor wrote: I highly suggest staying away from PHPMyAdmin. :-\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySql GUI

2006-05-31 Thread Anthony
Chris Sansom wrote: OK, so I suggested phpMyAdmin. Dan Trainor said: I highly suggest staying away from PHPMyAdmin. and, even more helpfully, 'Anthony' wrote: :-\ Fine - from this I gather php

Field name DESC

2006-07-13 Thread Anthony
Hello, i want to know how i can create a table with the feild name "desc" ? when i do: CREATE TABLE bank ( name varchar(50) NOT NULL default '', desc varchar(50) NOT NULL default '', ) the desc is badely interpreted... -- MySQL General Mailing List For list archives: http://lists.mysql.

Mysql Web interface for normal Users

2006-11-07 Thread Anthony
Hello, i am looking for a simple Web interface, for normal users (non admin), that will only have access to their Database, and have the possibility to manage their tables (create,delete,insert,...). for root access, i already have phpMyAdmin installed on the server. -- MySQL General Mailing

sorting using substring

2003-11-12 Thread Anthony
I am trying to write a query that will sort results using one or two substrings in item number. So for example I have item numbers that start with SE, TS, N0, W00, etc. So let say I want results sorted in the following order TS, SE, N0, W0 I have tried the followi

RE: How to 'customize' GROUP BY?

2003-11-21 Thread Anthony
you would need to create a temporary table. So lets say you want to check 'id' column for highest value, you would do the following: CREATE TABLE tmp SELECT MAX(id) AS max_id FROM tbl; SELECT * FROM tbl WHERE tmp.max_id = tbl.id; Another approach would be to use an SQL variable, again if you want

can't start daemon

2006-06-17 Thread Anthony Ettinger
1:57:43 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 060617 11:57:43 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. -- Anthony Ettinger Signature: http

Re: can't start daemon

2006-06-17 Thread Anthony Ettinger
i actually don't have anything valuable in my database, it's on my home pc. I upgraded with the standard procedure. On 6/17/06, Dan Trainor <[EMAIL PROTECTED]> wrote: Anthony Ettinger wrote: > I just upgraded to mysql 5, and can't restart the daemon. > > > 0606

Joining data from two databases

2005-09-27 Thread Anthony Brown
Hi, I have one database that I would like to split into two.. Well actually my client does.. I don't think we should. But, is there a way to join data from the seperated databases? One table authors will be connected to a table called contacts each residing in different databases on the same ser

optimizing mysqldump

2005-11-30 Thread Anthony Ettinger
ase backup tool, and I do not have direct access to the database server to run it locally. -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html

Re: optimizing mysqldump

2005-12-01 Thread Anthony Ettinger
Horpak.com/air - > > แหล่งรวมผู้ให้บริการติดตั้งเครื่องปรับอากาศ > > http://www.EasyHorpak.com/internet - > > แหล่งรวมผู้ให้บริการติดตั้งอินเตอร์เน็ตในอพาร์ทเมนท์ > > http://www.EasyHorpak.com/software - แหล่งรวมโปรแกรมสำหรับอพาร์ทเมนท์ > > http://www.EasyHorpak.com/mo

Re: Trojan Horse in MySQL

2005-12-01 Thread Anthony Ettinger
File is: C:\mysqldata\erqed.dll > > Anything known about this? > > please reply to [EMAIL PROTECTED] > > Gary > > -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html

Re: cannot connect to database

2005-12-31 Thread Anthony Ettinger
-- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html

mysqldump: Got errno 32 on write ?

2006-01-05 Thread Anthony Ettinger
"mysqldump: Got errno 32 on write" -- any ideas? I think it may be mysqldump is not run as user, because dump dir is 0700?? -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html

Re: mysqldump: Got errno 32 on write ?

2006-01-05 Thread Anthony Ettinger
Turns out I forgot the gzip > filename, only had | gzip filename. But the real problem here is I'm getting packet loss and loosing my connection, which is probably why I get that error 32. On 1/5/06, Anthony Ettinger <[EMAIL PROTECTED]> wrote: > > I am, I'm running a

Re: mysqldump: Got errno 32 on write ?

2006-01-05 Thread Anthony Ettinger
Frome Street, > _/ ** Adelaide SA 5001 > Australia > invent > --- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beh

remotely show databases

2006-01-08 Thread Anthony Ettinger
run "SHOW DATABASES"; I tried $man mysqlshow, but didn't see any easy way of simply returning a \n seperated list of databases. Any suggestions? I also need to do this for postgresql if anyone else knows of a standalone app that dumps the databases for a specific user. -- Anthony

Re: remotely show databases

2006-01-09 Thread Anthony Ettinger
'SHOW DATABASES;' | mysql -u foo -h bar.com this works, I haven't tested it with other databases though. On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > I am not sure if you have an installation of MySQL on your local server. > If you

Re: remotely show databases

2006-01-09 Thread Anthony Ettinger
On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > If you are accessing the db from perl, just execute a show databases > from there using the DBI interface. There is quite an amount of doco > about this and other features at cpan.org

Re: remotely show databases

2006-01-09 Thread Anthony Ettinger
------- > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Tuesday, 10 January 2006 9:33 AM > To: Logan, David (SST - Adelaide) > Cc: Mikhail Berman; mysql@lists.my

Does the order of tuples in a bulk insert impact query performance?

2010-02-07 Thread Anthony Urso
Does the order of tuples in a bulk insert impact later query performance? E.g. will sorting the rows before a bulk insert cause queries to perform better for indexed or non-indexed fields? Thanks, Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

best way to have a unique key

2011-01-20 Thread Anthony Pace
Due to certain reasons, the company I am doing business with has decided that the primary key, for an orders table, be a unique key; however, I don't like the possibility of it conflicting if moved to another machine. What are some pitfalls of using a unique key, that is generated by a server

Re: best way to have a unique key

2011-01-20 Thread Anthony Pace
your current employer. Neither MySQL nor any other RDBMS will allow you to establish a primary key that is not unique. - michael dykman On Thu, Jan 20, 2011 at 1:32 PM, Anthony Pace wrote: Due to certain reasons, the company I am doing business with has decided that the primary key, for an

Re: best way to have a unique key

2011-01-20 Thread Anthony Pace
I know of uuid() my problem is that there can be conflicts when copying the DB to a different machine, or working with sections of the db on different machines for load balancing. On 1/20/2011 1:44 PM, Krishna Chandra Prajapati wrote: > Please keep in mind this variable will also be displayed

Re: best way to have a unique key

2011-01-20 Thread Anthony Pace
Although I did berate you for your obvious cheek, I will of course complement the acuteness of your response. On 1/20/2011 2:10 PM, Anthony Pace wrote: Dude, come on. I know that all primary keys have to be unique; however, I was obviously referring to the use of uuid over auto

MySQL dying?

2012-12-04 Thread Anthony Pace
I have heard that due to Oracle taking over, the OS community is shifting to other type of DB's . Any thoughts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

LOAD DATA INFILE with space after quote but before comma

2013-12-18 Thread Anthony Ball
I ran across a curious issue, I'd call it a bug but I'm sure others would call it a feature. I have a csv file with space between the " and , and it causes MySQL to eat that field and the field after it as a single field. Is there a setting I can use to remedy this or do I just have to make sure n

Re: Advice on improving our current method

2003-06-02 Thread Anthony Ward
Hi, I'm not to familiar with MySQL, but as far as I can seem, you might want to look at programming. I.e a program in C++ or Perl, or Visual Basic. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Row Number

2003-06-03 Thread Anthony Ward
o SELECT...LIMIT nex-ten-starting,10 Regards, Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

IN function

2003-06-03 Thread Anthony Ward
Hi, I have written a program that creates statments for me, and sometimes I end with SELECT..WHERE number IN(1) instead of SELECT... WHERE number IN(1,2,3,4) would number IN(1) works, for the moment i have no mean to test it, it is why i'm asking. Regards, Anthony -- MySQL Ge

efficient query or not?

2003-06-03 Thread Anthony Ward
) * sin($latitude) ) * 3963 <= 1000); Would you consider this HORRIBLY inefficient or GOOD. if it is horrible how can i make it efficient? Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: efficient query or not?

2003-06-04 Thread Anthony Ward
se I don't understand the use of loc1.id=1 and loc2.id=2 Thanx for the help. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: efficient query or not?

2003-06-05 Thread Anthony Ward
))) < 1000 Because the problem, is that I have to join this with 3 other tables. Thanx Agai. Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

good or bad?

2003-06-05 Thread Anthony Ward
zip range longlat longlat 8 NULL 4323 where used What do you think? I can't really read that eventough I tried to go Mysql.com . For my conclusion it is time to buy a book about MySQL!! any help is appreciated. Anthony

join error

2003-06-18 Thread Anthony W.
n( radians( 33.00 ) ) + cos( radians( place.latitude ) ) * cos( 33.00 ) * cos( radians( - 96.00 - place.longitude ) ) ) ) <= 250 AND table1.id = table2.id AND table2.id = table3.id AND table3.id = table4.id AND table4.id = table5.id AND table5.id = place.id Any

Re: join error

2003-06-18 Thread Anthony W.
Hi, I saw the error. For interested it is in the place.latitude BETWEEN section Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

function question

2003-06-22 Thread Anthony W.
Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Thanx for the info Anthony -- MySQL General Mailing List For

need help with select statement

2003-07-07 Thread Anthony Scism
I am relatively new at this, but is there any way to perform the following: | obs_date | date | YES | | NULL | | | obs_time | time | YES | | NULL | | | object | varchar(40) | YES | | NULL | | | observing_site | varchar(40)

what is causing these XX.1.1.1.1 logs?

2004-08-09 Thread Ciarochi, Anthony
For some reason, I am getting hundreds of zero-length binary log remnants in my log area. Any idea what could be causing this? Is there any danger in deleting the logs that don't show up in 'show master logs'? show master logs output: mysqld_bin.058 mysqld_bin.059 bash-2.05b# ls -altr |

RE: what is causing these XX.1.1.1.1 logs?

2004-08-09 Thread Ciarochi, Anthony
om: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 12:17 PM To: Ciarochi, Anthony; '[EMAIL PROTECTED] ' Subject: RE: what is causing these XX.1.1.1.1 logs? Are you in the process of stopping and restarting the MySQL Database server? -Original Message----- From:

ADODB.Connection - How do I open a DB, create if not there, open table, create if not there and add a single record?

2004-04-09 Thread Don Anthony
This should be simple, no? I can't make it work Objective: - bring up a panel to ask for MySQL User/Host/Password and save settings if we get logged in. - when we start (likely on a new machine) create a new Weather DB if it doesn't exist - when we start ("" """) create a new TimeTable tabl

RE: oracle.

2003-03-17 Thread Anthony Robins
'select table_name from user_tables' to see your own tables. To see all tables you have to select from dba_tables. -- anthony -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:35 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a fre

load file

2003-06-05 Thread Anthony Ward
Hi, I have a a text file delimited with | and I don't how to load the data into a table and say delimited by '|' I think it is this: LOAD DATA INFILE 'C:\data.txt' INTO TABLE table2 FIELDS TERMINATED BY '|'l Any clarification would help. Anthony --

Join question

2003-06-06 Thread Anthony Ward
here table1.cl1 = 1 and table1.cle2=5 and table1.cl3 IN(1,2,5,8) Join Select id from table2 where table2.cl1 = 4 and table2.cle2IN(10,12,81) and table2.cl3 IN(3,7) Join Select id from table3 where table3.distance BETWEEN 1 and 99 where table1.id = table2.id=table3.id Any help is appreciated Antho

Re: Join question

2003-06-06 Thread Anthony Ward
Hi, what is the difference between your way and Mike Hillyer way?? (I can see the INNER join). But thanx to both of you. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql language

2003-06-06 Thread Anthony Ward
Hi, I was looking in what language what myslq written in? Just curious Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Statment Question

2003-05-31 Thread Anthony Ward
Hi, I have to search a big database. Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual Basic, C, Javascript. In my table C++ =1 Perl = 2 PhP = 3 VB = 4 C = 5 Java = 6 and i have a select statment like this SELECT * FROM lang WHERE language = 1 OR language = 2 OR language

Changed localhost?

2002-02-27 Thread Anthony Rodriguez
All of a sudden Apache and MySQL are not running correctly under Windows 98. It appears that somehow localhost was changed from 127.0.0.1 to something else. Could the fact that I NOW have a 24/7cable connection to the Net cause the problem? Thanks! Anthony Rodriguez ([EMAIL PROTECTED

Help w/ "join" syntax

2002-03-11 Thread Anthony Rodriguez
When I call the following PHP script, $qry_1 doesn't work (No query # 1!). DONE"; flush(); exit; ?> Thank you! Anthony F. Rodriguez ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.c

Changing field size

2002-04-28 Thread Anthony Rodriguez
I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field. What would happen to the existing data in MySQL db? Thanks! Tony ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (t

Application for Employment / Contract Work

2002-09-01 Thread Anthony Heller
*** Please Note: Do Not Use your Reply button if you wish to respond to this email *** *** Please reply to [EMAIL PROTECTED] *** Hello, I came across your website, and thought I would send you a copy of my CV / Resume (please scroll down the page) to see if you are in need of any help in pr

problem with suse linux and mysql version 3.23.39

2001-07-12 Thread Anthony Appleby
Has anyone found a problem (and solution) on LEFT JOIN when using MySQL version 3.23.39 under SuSE Linux? We have two tables of 5000 and 1000 records respectively but LEFT JOIN takes over 10 minutes. Can anyone give any guidance on this? Thanks Anthony Appleby

Problem with SuSE Linux and Mysql version 3.23.38 (correction sorry)

2001-07-12 Thread Anthony Appleby
Has anyone found a problem (and solution) on LEFT JOIN when using MySQL version 3.23.38 under SuSE Linux? We have two tables of 5000 and 1000 records respectively but LEFT JOIN takes over 10 minutes. Can anyone give any guidance on this? Thanks Anthony Appleby

A Plroblem Connecting

2001-07-20 Thread Anthony Lezama
Hello I have mysqlgui-1.7.5-1-linux-static and semi-static, mysql-3.23.39, linux slackware 7.2. When I run the mysqlgui executable(in static & semi-static), I enter password and the gui loads but says "Can't connect to local MySQL server through socket" (111). The password is correct and I can

Re: Reply-to and this list

2001-08-30 Thread Anthony Hardy
mmediately and can peruse at my leisure. Anthony - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Carl Troein" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 6:58 PM Subject: Re: Reply-to and this list >

drop index causing error 1062?

2001-04-10 Thread Anthony DiPierro
ERROR 1062: Duplicate entry '1' for key 1 mysql> drop index username on user; ERROR 1062: Duplicate entry '1' for key 1 --- Am I missing something? Any ideas? I've run isamchk, no problems found. Version is 3.22.32. I'm in th

server rejecting 15MB insert statement

2001-08-31 Thread Anthony Lau
there a client side variable that also needs to be defined? Thanks, Anthony -- Anthony Lau - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

fields query

2001-09-05 Thread Anthony E.
I need to read the fields of a table dynamically using DBI.pm The resulting cgi script should be a form that has a checkbox for each field...the user will then create a temporary table based on which fields are checked in the form. = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http

errors starting mysqld from 3.23.41 source (linux)

2001-09-05 Thread Anthony E.
install_db /usr/local/mysql/bin/mysqladmin -u root -p password 'newpassword' /usr/local/mysql/bin/safe_mysql & starts, but still doesn't let root connect via localhost = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc

LOAD DATA INFILE - "split" one field into two??

2001-09-06 Thread Anthony E.
e" into two different fields in the database, "firstName" and "lastName"? I would assume the last word in "Name" is the last name for "lastName" in mysql table. Thanks, = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __

Skip columns from tab-del.txt on LOAD DATA INFILE?

2001-09-06 Thread Anthony E.
- tab.txt has the following cols: col1 col2 col3 I only want to import as: col1 = firstName col2 IGNORED (not imported) col3 = zipCode = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ Do You Yahoo!? Get email

intersection: join query...

2001-09-07 Thread Anthony E.
m USER_TMP where USER_TMP.email = USER.email; (i want to delete entries from USER_TMP, where the email is the same as an entrie in USER tablem, before eventually insert data from USER_TMP into USER table). Mysql v 3.22.32 = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/

NOT IN query problems.

2001-09-07 Thread Anthony E.
r words, i want only the records where the email address from USER_TMP is not already in USER). Please help, i've been strugglying on this all day. = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ Do You Ya

Re: intersection: join query...

2001-09-07 Thread Anthony E.
Unknow column 'USER' in 'where clause'. --- Rodney Broom <[EMAIL PROTECTED]> wrote: > From: Anthony E. <[EMAIL PROTECTED]> > > > > This comes up with more records than are in > USER_TMP. > > Is the 'email' column unique i

Going blind? Plz hlp w/ parse error

2001-09-19 Thread Anthony Rodriguez
Please help! There is a parse error in line10: etc. Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thr

Beginner - PHP Triad, PHP Amin and MySQL

2001-11-27 Thread Anthony Evans
yadmin\lib.inc.php on line 255 Error' Thankyou so much in advance if anyone can help. Regards, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

PHP / MySQL username and password creation

2001-11-29 Thread Anthony Evans
Hi everyone, Is there an online tutorial out there that can help me to create a PHP page that will accept a users new username and password which is then dumped with MySQL ? Your help would be most appreciated. Anthony

Re: PHP / MySQL username and password creation

2001-11-29 Thread Anthony Evans
sorry Todd, i meant into my own users table that i have created. - Original Message - From: "Todd Williamsen" <[EMAIL PROTECTED]> To: "'Anthony Evans'" <[EMAIL PROTECTED]>; "'MYSQL help'" <[EMAIL PROTECTED]> Sent: Thurs

Plz help w/ php/MySQL

2002-01-05 Thread Anthony Rodriguez
h_array($result_3, MYSQL_ASSOC)) { $username=$row_2["username"]; $e_mail=$row_2["e_mail"]; mail("$e_mail", "News from SBW Research", "$message_2", "From:SBW Research <[EMAIL PROTECTED]>\n"); $result_4=mysql_query($

Plz help w/ query

2002-01-31 Thread Anthony Rodriguez
The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. Thanks! Anthony F. Rodriguez ([EMAIL PROTECTED

SELECT TOP?

2001-05-11 Thread Anthony Colli
limits rows returned? I know it sounds like an easy question but I am curious. Thanks -Anthony

3.23.29a - Can't create HEAP table in .INI file

2001-01-15 Thread Anthony Cooke
in memory. Found it odd because the same query works fine in 3.23.23. As such I went back to .23. The .INI file is straightforward: use motor; drop table f_datos; create table f_datos type=heap select * from datos; Any insights appreciated. Regards, Ant

FW: mySQL performance

2001-01-15 Thread Anthony Cooke
s these servers pre-configured or on a lease to own plan. They are also behind Red Hat being major investors and all. Sounds like I sold my soul to Dell but I'm very happy with our setup. I can sleep better now. And if I can save anyone by having them choose DellHost, then my work here

FW: 2 questions!

2001-01-15 Thread Anthony Cooke
From: Anthony Cooke <[EMAIL PROTECTED]> Date: Mon, 15 Jan 2001 10:33:05 -0400 To: Arthur Radulescu <[EMAIL PROTECTED]> Subject: Re: 2 questions! Two answers! 1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let the file system cache image files, st

Char vs. Integer indexes for memory based databases

2001-01-16 Thread Anthony Cooke
> From: "Yury V. Bukhman" <[EMAIL PROTECTED]> > Organization: Danforth Plant Science Center > Date: Tue, 16 Jan 2001 16:49:09 -0800 > To: Anthony Cooke <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Char comparisons vs. Integer. > > &g

simple problem with mysql install

2001-01-27 Thread anthony ortega
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and start the mysql server it starts up then stops. when I try the mysql -user command it gives me a cant connect to mysql.sock error. any idea what is going wrong? Anthony Ortega (512)444-6238 6700 B. Deatonhill

simple problem with mysql install

2001-01-27 Thread anthony ortega
I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and start the mysql server it starts up then stops. when I try the mysql -user command it gives me a cant connect to mysql.sock error. any idea what is going wrong? Anthony Ortega (512)444-6238 6700 B. Deatonhill

how to install mysql on Linux(debian)

2001-02-02 Thread DESERT Anthony
HI! I'm new on the mailing list and I would to know how install mysql on Linux. Moreover, if someone could explain me how to recognize this package by php4, I would be the most happy boy in the world. Excuse my english but I'm french and I'm 19 years old.

Re: [CGI] Gas Prices

2001-02-04 Thread DESERT Anthony
> 1 $ le litre de Gaz en FRANCE >

Re: Could not start the service MySQL:Error 0

2009-07-17 Thread Thomas . William . Anthony
I suffered the same problem, and the following worked for me: http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/

Re: Re: Could not start the service MySQL:Error 0

2009-07-17 Thread Thomas . William . Anthony
Try looking in Control Panel->Administrative Tools-> Services and deleting all the MySQL services.

CRN Has A MySQL Poll...

2004-01-08 Thread Anthony L. Awtrey
...on the front page: http://www.crn.com/ Not that I am recommending we stack the poll or anything... :) -- Anthony L. Awtrey Vice President __ I.D.E.A.L. Technology Corporation - Orlando Office http://www.idealcorp.com - 407.999.9870 x13

Two problems

2003-07-22 Thread Anthony Hart-Jones
1) Windows ME seems incapable of applying passwords to usernames. On my webspace, I can only log into the SQL database if I include the password. On my WinME PC, only if I do NOT give a password. 2) Using the Opera browser, I open my pages and it sends variables through "?var1=value1&var2=val

non-root users cannot run mysqlimport

2003-09-12 Thread Carl Anthony-uzoeto
Hi, I need to periodically load a dumpfile from another DB into mysql. Now, since this is a cronjob, and for which I would need to avoid interactivity, I DO NEED to run this as a non-root user. I have setup such a user, and have granted the user all on the destination database. The user also has

Re: Loading a flat file

2003-09-12 Thread Carl Anthony-uzoeto
MyWeeklyLeads.com wrote: I have a flat file that I am trying to load to a MySQL database (fixed-length fields). When I try: LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable It is generating a ton of errors, but the end result is that it's populating only the first field for all records and al

Re: Populating a Table with Data by Inserting a Textfile

2003-09-14 Thread Carl Anthony-uzoeto
Stephen Tiano wrote: What I'd like to do is create a textfile and then import the whole thing into a table. So, naturally, I've a few questions. Do I need to include the column heads as a line in my textfile, or can I simply go straight to the data? No ... you can simply go straight to the data

Spanish Accents

2004-03-09 Thread Brand, Troy Anthony
Hello, I am building a web page using Windows 2000 Server, IIS 5.0, ASP (with vbscript) and MySQL database with MySQL Connector/ODBC. The content of this web page is in Spanish thus the database will contain letters with Spanish accents. My problem is that the Spanish characters are not displ

4.1 Download

2002-12-20 Thread Anthony W. Marino
Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

MySQL 4.x Timeline

2002-02-21 Thread Anthony W. Marino
fall into place. This will help me plan my development effort as well since I don't need everything at once. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Re: MySQL 4.x Timeline

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: > On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: > > Is there a timeline/status for 4.x functionality available? > > No. It'll be ready when it's ready. :-) > > There are folks using 4.0

Re: Paul DuBois Book

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 05:48 am, Simon Green wrote: > It would be nice to see some thing for V4. > > PS Paul...its only because we liked the first one so much. > > -Original Message- > From: D Bamud [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2002 10:47 > To: [EMAIL PROTECTED] > Sub

Re: MySQL 4.x Timeline

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: > Hi Alec, > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: > > > Is there a timeline/status for 4.x functionality available? > > > I would like to use MySQL 4.x, however, I'm looking for some of the > > > highly requested functional

Transaction Enhanced Formats

2002-02-22 Thread Anthony W. Marino
Can anyone point me to a comparison of +'s and -'s with each Transaction enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.

Re: MySQL 4.x Timeline

2002-02-25 Thread Anthony W. Marino
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: > Hi Anthony, > > On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: > > > On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: > > > > > Is there a timeline/status for 4.x functionality available? > &

MySQL 4/XFS Journalling FS

2002-02-26 Thread Anthony W. Marino
Would anyone like to share their experiences with MySQL 4 on XFS and kernel 2.4.16? I'm getting prepared to create a system with the above and would appreciate any thoughts. Thank You In Advance! Anthony - Before po

Re: I heard that MySQL 4.01 supports Views?

2002-02-27 Thread Anthony W. Marino
On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > At 16:31 -0500 2/27/02, Stephen Cox wrote: > >Does MySQL 4.01 support Views? And if so, how? > > Ask the person who told you that it does to substantiate the assertion. > > >Stephen Cox > >Web Development, Webmaster > >[EMAIL PROTECTED]

Re: I heard that MySQL 4.01 supports Views?

2002-02-27 Thread Anthony W. Marino
On Wednesday 27 February 2002 05:16 pm, you wrote: > At 17:09 -0500 2/27/02, Anthony W. Marino wrote: > >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > > > >Does MySQL 4.01 support Views? And if so, how? > > > > > > Ask the person who to

Re: Can't restart MySQL after innodb table filled up

2002-03-04 Thread Anthony W. Marino
ater, plans for an automatic procedure for deleting an InnoDB Db and ALL associated files (ie; "Delete DB and all") ? Thanks, Anthony > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at https://order.mysql.com/ > Speed up adding

System Suggestions

2002-03-06 Thread Anthony W. Marino
have to further test the various scenarios. SuSE 7.3-2.4.18 512MB RAM 4x40GB Maxtor IDE (7200RPM) drives 3Ware 7800 RAID Controller LVM XFS Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.php

MySQL Availability

2002-03-06 Thread Anthony W. Marino
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

  1   2   >