Luis,
How large is your database? Have you checked for an increase in write
activity on the master leading up to this? Are you running a backup against
the replica?
Thank you,
Tyler
Sent from my Droid Bionic
On Oct 23, 2011 5:40 AM, Luis Motta Campos luismottacam...@yahoo.co.uk
wrote:
Fellow
/\\t/\t/g' ' output.txt
Tyler
*
*On 9/2/11 3:40 PM, Dennis wrote:
hi, there,
the following is my sql statement:
SELECT HIGH_PRIORITY SQL_BIG_RESULT SQL_NO_CACHE
tb.url_sign, m_url,m_title, m_weightINTO OUTFILE '/tmp/a.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '\' LINES
Additionally, if a user has the SUPER privilege (eg. all privileges on
*.*) they can write to a database running in read-only mode. Yet
another reason to never allow this privilege for general purpose users.
Tyler
On 11/22/10 8:08 AM, John Daisley wrote:
The replicated database should
location and run through the conversion while monitoring
performance numbers.
Tyler
On 11/22/10 5:55 AM, Machiel Richards wrote:
Thank you John
I have in the meantime fond this to be the case (** someone
changed config files without my knowledge it seems as this was setup
properly
Tammie,
You might just try resetting the root password
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-windows.
Hope this helps,
Tyler
On 10/19/10 12:38 PM, Montgomery, Tammie wrote:
I had an old version of mySQL on my computer but never used it. I
Charlene,
You should check the mysql error log and if there isn't a message about
the cause there you may want to check /var/log/syslog for mysql being
killed by oomkiller.
Tyler
On 6/21/10 11:11 AM, Charlene wrote:
Anybody have any idea why MySQL would start to have this error message
will help to determine whats wrong?
Thanks in advance for the help,
Tyler McMullen
table. So shouldn't this SQL just return the
fname,lname,workerid from the workers table? Could someone just
explain to me why this doesn't work the way I expected it to?
Maybe I'm doing something wrong.
THANKS!
Best Regards,
--
Tyler Longren
J.D. Web Services, L.C.
--
MySQL General Mailing
,worker.workerid FROM worker LEFT JOIN
webprojectassign ON worker.workerid = webprojectassign.workerid WHERE
webprojectassign.workerid IS NULL ORDER BY worker.lname ASC
Tyler
On Tue, 2004-01-06 at 02:22, Rory McKinley wrote:
On 6 Jan 2004 at 9:31, Noamn wrote:
Rory wrote:
The query is behaving
Hi,
I am just learning to use Linux and I am having some problems with
getting MySQL to load.
I have successfully installed tested both Apache PHP, so I am pretty
comfortable with the whole configure and make processes.
I followed the MySQL installation docs to the letter, however
I am using mysql_connect. But I just changed it to mysql_pconnect and it did
exactly the same thing.
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 10:48 AM
To: Donald Tyler
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Lost Connection
I have a script that is processing data from a single table and splitting it
into smaller normalized tables.
The script takes anywhere between 5-10 minutes to complete, and as it runs
it constantly outputs a report on its progress.
The script seems to run fine the first time I run it, but
Yes it can. But you should understand the three distinct levels of that
situation.
You need the following:
Database
Web Server
Server-Side Scripting Language
I would suggest using AMP (Apache, MySQL PHP). If you want to know more
about how these work in conjunction I would suggest the
.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE
, 2003 3:24 PM
To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.
I also have no choice but to do it through the browser - I don't have
command line access on the server
PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come across this
Oh and just a note. This solution won't work if you are uploading the file
to the server through the browser. You will need to put the file on the
server and adjust the commands PATH accordingly.
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory system. The
system contains:
Items
Kits(Made from a collection of Items and/or other Kits)
Now my question is:
Is there any way to structure this in a
Greetings,
I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on my own, all
successfully (although some
- Original Message -
From: J.A. Jones Tyler III [EMAIL PROTECTED]
I have gone into the user table in mysql db and placed
both 'localhost' and '%' into the host entry. It was
my understanding that '%' would allow access from any
host for that particular username.
Well, I finally
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
Where are these instructions found?
Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation
snip
Yes, unless some other user table matches first, which may be
what is happening in your case.
Cool.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
I have gone into the user table in mysql db and placed
both 'localhost' and '%' into the host entry. It was
my understanding that '%' would allow access from any
host for that particular username.
Yes, unless some other user
MySQL CC from www.mysql.com is pretty good.
Tyler
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI
I have recently purchased the lease of a dedicated mySQL server running on
linux.
I normally
I've been trying to install MySQL (3.23.55) as a named NT service and using a
specified defaults file and I can't get it to work.
The source code has the example:
mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini
in it. The results in a service ImagePath of
Tyler [EMAIL PROTECTED] at 12-Mar-2003 12:58:35 --
Hi,
I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld
service as a user account rather than the local system account. This worked fine in
3.23.43 but has stopped working since the upgrade.
The error I get is 2186
Hi,
I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service
as a user account rather than the local system account. This worked fine in 3.23.43
but has stopped working since the upgrade.
The error I get is 2186, which seems to be service failing to respond to
Just saw the following code in the MySQL 2.23.55 source code.
The semi-colon after the if renders the if statement useless. Could someone explain if
it is intentional. The comment indicates that it is.
Simon
/*
the following 'if', thought conceptually wrong,
is a useful
Hi,
I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product
(GMS Mail) and I'm running into install\service related issues. I've read through the
various threads on this list and nothing seems to solve my problem.
The situation is that we include MySQL with our
. I
dont knwo whats wrong.. but the only way I can edit my DB is to do it via
mysqladmin ON the linux box
-Thanks oin advance
Tyler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Oh.. I see. I dont know about Linux, all I knew was that I wanted it so I
burned the necissary CD's and installed linux on my other machine. So,
you're saying I should use a mandrake-linux forum, instead of mysql?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Tyler
Can someone please guide me in uninstalling all the failed installs of MySQL
I've got? I've installed like 2 binaries, and 1 source.. none work :(
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
what appropriate forums?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 7:21 PM
Subject: Re: Compiling error 3.23.54a (src)
On Tue, Jan 14, 2003 at 05:56:07PM -0700, [EMAIL PROTECTED] wrote:
Does
-3.23.54a'
make: *** [all] Error 2
Then the script closes and i get my command prompt.
Thanks in advance,
Tyler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi. How do I unstall a source tarball (tar.gz) of mySQL? (or any prog for
that, I need to uninstall Emacs too) I installed Mysql-3.23.51, but the
install docs dont seem to work for that, and I finally found a working src
for .54, so I wanna take out the old one.
Thanks in advance
Tyler
It seems NOTHING has
worked for the last 2 days. I've tried the binaries, and then I dont have
the top-level installation directory that all the docs refer to, and mysql
isn't in /usr/local/.
I really just want to be able to use MySQL..
-Tyler
Hey.. I've got a wierd problem. I'm following the guide as per WebMonkey
which has worked for me before, when I ran my servers on a Win32 box, but
now I've got this problem (running linux)...
I cant seem to do any editing to my DB from the webpage. I've used a couple
different scripts,
Can anyone help me?
I get this whenever I run ./configure --prefix=/usr/local/mysql
checking for termcap functions library... configure: error: No
curses/termcap library found
then configure quits. I'm really new to linux, so please give me the
lamans version of it ;)
hi:
I will use Mysql 4.0 to store RTP data stream.
How I can get a handle for controlling longblob field? I will put the
received real-time data into the longblob field by the handle
continually.Would you like to write a demo for me?
Thanks for you help.
of a table, which is not my goal...yet=)
--- Oscar Rylin [EMAIL PROTECTED] wrote:
From: Oscar Rylin [EMAIL PROTECTED]
To: 'Jones Tyler' [EMAIL PROTECTED]
Subject: RE: Newbie With a Question
Date: Wed, 14 Aug 2002 22:36:05 +0200
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
-Original Message
UmI don't think anyone (or hope noone) on this list is stupid
enough to get sucked in by a piece of spam.
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Thu, 11 Jul 2002 15:39:33 +0100
Kevin Passey [EMAIL PROTECTED] wrote:
Do not give your
ok - this might seem unbelieveable but:
why are the benchmarks:
shell cd sql-benchmarks #or whatever it is
shel perl run-all-tests --user=root --password=password
and then on another screen i have mysql up -
and a \s say queries per sond 1.792 or something around there. what is up?
Hi Amaury,
R.B. Roa would be correct in saying that subqueries are in the 4.x branch of
MySQL. I'm not sure when 4.xx will be the stable branch though. Instead of
using subqueries, you could try using some JOIN statments.
Tyler Longren
Captain Jack Communications
www.captainjack.com
[EMAIL
did you FLUSH (reload) your mysql server?
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Dan Egli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 6:21 PM
Subject: Authentication messed up?
I tried
It can't, try using JOIN.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Leo Przybylski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries
Hello all,
Does anyone know
MySQL will be good for this type of stuff.
Tyler
- Original Message -
From: Zhao, Charles [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 3:53 PM
Subject: Beginners Question
Hello there,
I am trying to find which database to use. I will have text and image
You have to have the LIMIT clause after the ORDER clause.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: destr0 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 30, 2002 1:32 PM
Subject: LIMIT, ORDER Dilema
Can
Visual Basic and Visual C++ are 2 completely different things, so no, visual
basic will not work.
There might be some free C++ compilers for you to use for windows. You
could always buy a copy of an older version of Visual C++. Older versions
probably won't be too horribly expensive.
Tyler
This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;
There's probably a better way to do that though.
tyler
- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items in sql
might want to open port 3306 on the firewall.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Paul Rose [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 11:07 PM
Subject: Host permissions
I have read the mail
I suggest you use MySQL from MySQL AB. Progress Software (parent of
NuSphere), is having some legal troubles.
http://www.newsforge.com/article.pl?sid=02/02/26/1825200
Tyler
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 1:01 PM
Nope, privs are the same.
Tyler
- Original Message -
From: Daniel Rosher [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:19 PM
Subject: RE: SET field=field+1 no longer works?
Have
!
tyler
- Original Message -
From: Stewart Gateley [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:56 PM
Subject: Re: SET field=field+1 no longer works?
Try:
UPDATE users SET board_posts
in board_posts by 1, this no longer
happens. Is there a different way I should do this now?
Thanks,
Tyler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
It's at the bottom of every message sent to this list.
Tyler
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
is mysqld running on your box?
Tyler
- Original Message -
From: Rich [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Monday, February 11, 2002 6:49 AM
Subject: Where Did Mysql Go?
I was working on updating some databases yesterday and when I booted up
my computer this morning I
couldn't hardly believe it.
That was a couple of years ago, and CF has went from 4 -- 4.5
-- 5. Under a windows environment, it's probably pretty good.
Under *nix (Solaris in my experience) it really left much to
be desired. I'd avoid it and stick with php on Solaris any day.
Tyler Nally
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Subject: Re: Disable case sensitivity
If is possible, in everything from a Database, but if
is not, in columns
is more important.
Column names are case insensitive.
Correct... Database names and Table
Yeah, any lookups based on char based columns are slower
than integer queries any day. I'm assuming it's a char
column because you're searching with apostrophe's '0'.
Would a between statement in the where clause help?
select * from experian.experian
where latitude between '038631928'
webserver on a test machine/database and Apache on production
machine/database.
Any help. Thanks in advance.
--
__ _Tyler Nally
/ /__ _(_)___ _ _ [EMAIL PROTECTED]
/ / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860
I think it's like this...
alter table hrcontract drop index login
... assuming the name of the key is login. You can
have key names (which is what a unique constraint
is) and column names of the same name.
If you do a ...
show index from hrcontract
... it'll show you all of the key_name
Rember that the sum function sums the total of all
of the colum specified. Is there multiple rows where
the same c.cid_no occurs many times? If so, then you
need a group by and having clauses. If not,
then you don't need the sum function.
With a group by, it'd look like this... I think ...
Basically, the mysql_query submits the sql statement
to the database engine, and the mysql_fetch_array
allows retrieval of selected information returned from
the query into an associative array with each columnname
of the query an associative key in the array
Example...
Not knowing the exact internals of how it works...
Assuming that it works much the same way other RDB's
work in their native GL's (generation languages), the
common practice with a relational database is to define/declare
a cursor with the SQL statement executed against the database.
After the
continue to grow in it's usage as the desktop
gets more friendly and the applications are developed
to make people want to use linux instead of windoze.
Tyler
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 5:18 PM
To: [EMAIL PROTECTED
Might wanna try MySQL Front at http://www.mysqlfront.de.
It's pretty good.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: John Mayson [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, December 24, 2001 6:41 PM
' because that will
give me a bunch of gibberish. Is there anyway to get the password back into
plaintext to be emailed to the user?
Thanks,
Tyler Longren
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
. There's also
another entry for the mysql user and the host on that is set to
localhost. Could having 2 of the same usernames have an effect on this?
I really don't see any reason that I can't connect to this MySQL server from
a remote site.
Thanks all,
Tyler
Hello,
I created the entries by adding them manually to the table (not using
GRANT). And yes, I did run FLUSH PRIVILEGES. Anything else I should try
doing? The MySQL manual didn't really provide much help.
Thanks!
Tyler
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED
mysqldump -uusername -ppassword -hhostname dbname dbname.sql
That will dump the database 'dbname' into the file 'dbname.sql'
Tyler Longren
- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 9:40 AM
I think that's the error code that's spit out when permissions are wrong on
the DB file. You might want to check permissions.
Good luck,
Tyler Longren
- Original Message -
From: Venu Allavatam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2001 4:10 PM
Subject
Hello everyone,
Is there any way to make selections in groups of 5. I want to get 5 record
sets at a time until we get to a point that there's 4 or less records.
Thank you everyone,
Tyler
database,sql,query,table
-
Before
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Thanks,
Tyler Longren
-
Before posting, please check
Does /var/lib/mysql/mysql.sock exist???
--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 21 Aug 2001 10:06:43 -0700 (PDT)
my sql [EMAIL PROTECTED] wrote:
On a new install of Suse 7.2 I get this message when
attempting to acces MySQL through a php
post some code. Make sure you're using quotes in the right places.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 14 Aug 2001 13:39:48 -0700
Nate Sanden [EMAIL PROTECTED] wrote:
Hey im pretty new to mysql, but I made a basic html form and used php
Which Linux 7.0 are you using?
I'll assume you're talking about Redhat. So why don't you just download
the mysql rpm and install it instead of doing it from source?
Good luck,
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
I don't think MySQL supports sub selects.
Tyler
On Tue, 07 Aug 2001 14:57:33 +0200
Anders Alstrin [EMAIL PROTECTED] wrote:
Does anyone know how to do this sub select in MySQL.
I know how to do it in Oracle!
table media
+--+---+--+
| media_id | price |filename
No need to install locally. You could write everything locally, upload it
to the server, and see if what you wrote works.
Tyler
On Tue, 7 Aug 2001 13:51:01 +0100
Matt Gaskin [EMAIL PROTECTED] wrote:
Hi All
Currently I have rented space on a Web Server that has MySql installed
and
PHP
Get the mysql client from www.mysql.com.
Tyler
On Sun, 5 Aug 2001 13:38:09 -0400
Chris [EMAIL PROTECTED] wrote:
Is there a method I can use to log into a remote mysql server through
something such as telnet to pass queries on my database
You could just filter for [EMAIL PROTECTED]. That's what I do.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote:
I am not sure if this has been addressed before, I think it would be
neat if
the list admin
$ ps -ax | grep mysqld
get the pid of mysql
$ kill -9 pid_of_mysql
that'll do it.
:)
Tyler
On Thu, 26 Jul 2001 13:24:41 -0500
cjackson [EMAIL PROTECTED] wrote:
Hello all,
I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server
running apache and php. I could start msqld
Try doing it as root if you're not already.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Michael Nezi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 11:08 AM
Subject: Problems running
Hi everyone,
Is there a way to NOT select the last row that was inserted into a table? I
want everything before it.
I know how I could do this using 2+ queries, but can it be done by issuing
just 1 query?
Thanks everyone,
Tyler
That should work just fine. :)
Thanks!
- Original Message -
From: John Meyer [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row
At 12:25 PM 7/20/01 -0500, Tyler Longren wrote
copy a table:
mysqldump database table_name table.sql
or to copy the whole db:
mysqldump database db.sql
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate of a db?
do this:
mysql -uusrename -ppassword dbname brand.txt
mysql -uusrename -ppassword dbname brand.sql
Tyler
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 1:59 PM
Subject: How do I restore a database backed up using
could not be start
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
---End Error
Has this happened to anyone else? Or am I just the unlucky one?
Tyler
-
Before
just do:
mysqldump options db_name db_name.sql
Your database tables and contents will be dumped into db_name.sql
Tylre
- Original Message -
From: ah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:19 PM
Subject: constraint question
hi
I am using mysql
You'd probably be interested in PHP:
www.php.net
Tyler
- Original Message -
From: Laura Lía Marcello [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:03 PM
Subject: Connect mySQL with HTML or something
I need to know if there is a way to create a searchable
you should probably just store the images on your server, and provide the
location to the image in the table...much quicker.
Tyler
- Original Message -
From: Felicia [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 11:03 AM
Subject: inserting images
http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html
Tyler
- Original Message -
From: John Kennedy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 10:31 AM
Subject: mysql GUI for windows NT/98 is it available?
I am just curious to know whether you have
Default mysql port is 3306.
Tyler
-Original Message-
From: sanborn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 9:36 PM
To: MySQL Mailing List
Subject: MySQL Port number
How is MySQL used over a network? I assume there is a port involved, and
some kind
ideas why this happened? BTW, I'm running mysql-3.23.38 on NT4.
Thanks everyone,
--
Tyler Longren
[EMAIL PROTECTED]
Currently Unemployed
www.noworkfortyler.com
-
Before posting, please check:
http://www.mysql.com/manual.php
This post can be ignored now. Turned out the datatype for the id field was set to
tinyint, changed it to int and everything worked great.
Tyler
On Thu, 31 May 2001 00:26:12 -0500
Tyler Longren [EMAIL PROTECTED] wrote:
Hello everyone,
I have a database of alumni at school. Each alumnus
is select a
maximum of 2 entries for each artist. I've tried a few different things, but nothing
has given me what I need. Is there any way to do this?
Thanks everyone,
Tyler Longren
-
Before posting, please check:
http
-
test/var/run/mysqld-slave.pid' after 10 seconds
Slave shutdown finished
that's what makes it seem like the signals are not working. Either that
or the file locking done on the pid file (what is that done for and who
does it? I don't know).
Let me know if you make any progress.
Tyler
for permissions being
appropriate?).
luck,
Tyler
On Wednesday, May 2, 2001, at 07:22 PM, Paul DuBois wrote:
At 11:52 PM -0600 5/1/01, Colin Faber wrote:
why not just use the LOAD DATA INFILE option?
That probably won't help much. All the mysqlimport does is issue
a LOAD DATA statement for you
here to help get the issues
resolved,
I'd like to do so. Please feel free to email me directly with
suggestions, staring points etc., if that helps.
Thanks,
Tyler
[EMAIL PROTECTED]
P.S. The problems I have seen posted and experienced myself are:
1) the small edit to get
Description:
There are several problems running the mysql-test-run script from
the installed directory if you are installing from a source
distribution.
e.g., if you do as the manual suggests (4.7.1 Quick Installation
Overview)
shell groupadd mysql
shell useradd
FWIW:
It also appears to me that negative one (-1) plus one (1) is ZERO (0)
which may be why you are having trouble...?
in ignorance,
haiku
On Wednesday, April 18, 2001, at 01:09 AM, Milo Stefani wrote:
As Far as I can remember it is explicitly said in the Manual that
inserting
a
On Wednesday, April 18, 2001, at 07:29 AM, B. van Ouwerkerk wrote:
I'm trying to install mysql onto a uniz environment.
I've already unzipped and untarred, and I've created
the mysql - version directory, but when I type
configure, I get a grant table failed error. I cant
find anything on
1 - 100 of 110 matches
Mail list logo