> >Delete anonymous user('') from table user. Don't forget about FLUSH
PRIVILEGES.
> >
> Thanks, that worked. Why?
I suggested this yesterday, at the very beginning of Mark's
question, and I also suggested it again today in a private message, but both
of my suggestions got ignored, I guess. Keep
I JUST had a problem very similar to this. However, it could be a number of
different reasons, but here's what my problem was. I had two users in my
users table that could connect via any name, any host, with any password but
had no priveleges. You can probably test this by connecting to mysql with
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of upgrading to
Does it restart or just shut down? Do you have to start it up in the
morning? And is there a specific time at which this happens? If you don't
have logging on, you should consider turning it on for debugging purposes.
After it happens again, check your error log (should be in your data
directory -
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of upgrading to
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server. Does anyone have a good idea of th
Actually, no. The addiction to MySQL has caused many relationship break-ups.
There's probably even a database with that information out there somewhere.
Probably a MySQL database, too. Meanwhile Access supports relationships
because it blows so hard that people can't wait to get away from it and h
While this should be on the PHP list, here's the problem. You're not doing a
printf or whatever function that is that replaces %s with values - you're
just assigning the string to $retval. It should look something like:
$retval .= printf(" ...yadayada");
look up the syntax - I never use printf,
-f $TEMPDIR/$FILEPREFIX.sql
# E-mail the tarfile - Use whatever e-mail method you
# want. I use perl, but another good one is biabam.
BackupMailer.pl $RECIPIENT "$SUBJECT" $FILEPREFIX.tar.gz
- Jonathan
-Original Message-
From: David McInnis [mailto:[EMAIL PROTECTED]]
Sent: Tuesd
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql && rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also have the script
Geez, get a grip. You should've counted on the predictable, endless sarcasm
that came as a reply to something that would've been pretty big news, NOT on
only 1 or 2 people pointing out that you're wrong. Most critics here think
that they will be the first or only person to reply, or believe their
I'm currently working as a e-commerce web programmer specializing in PHP,
MySQL, and Apache systems. I've had experience on FreeBSD and Linux systems,
and now the company I work for seems to be being "bought out" at which
point, several of us may lose our jobs. Now, I've been searching all over
Mo
> The lesson here is don't preach to those who might not want to be
converted.
W.W.J.D. - after Jesus cast the demon Legion out of that one guy, the people
in that area asked him to leave and he left without any arguments. Take a
hint from the Savior, Blue World.
- Pastor Jonathan "Reverend of
> All we're doing here is providing information on a report that was just
released and answering questions and clarifying mis-perceptions.
Don't you mean "All we're doing here is marketing our product to an e-mail
list" ... ?
> Sharing information for the betterment of the community is good for
Ah, the keywords "with commercial add-ons." Notice the plurality, as well. I
wonder which add-ons and how many total add-ons were considered in making
this cost estimate. I also wonder if most of us would even need more than
one commercial add-on at most.
- Jonathan
-Original Message-
Fr
PHP is looking for the client library that gets installed with MySQL
3.23.4+. Now, you can try a QUICK fix that might not work, but it's worth a
shot. Go to the directory that has the libmysqlclient.so.11 file and type
the following:
ln -s libmysqlclient.so.11 libmysqlclient.so.10
That should cr
riginal Message-
From: Brad Phinney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 8:39 AM
To: Jonathan Hilgeman
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: BSD and MySQL : Major Problems
The problem with this error is
(1). It seems OS dependent (cannot
I would first check your /var/log/messages file, or whatever file is
receiving your system warnings/errors. This could be a filesystem problem.
If you're not logged in as root, just keep trying your program until you get
that error, and quickly go to the shell and type:
ls -lt /var/log
That shou
I'm getting this, too. I first noticed it when Monty appeared to start
spamming us with release announcements. :)
- Jonathan
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 5:15 PM
To: [EMAIL PROTECTED]
Subject: Is The MySQL Mailing Lis
Well, first of all, if you're just starting out with all this and don't have
any critical data, I recommend you dump your PHP and MySQL installations and
install the latest, stable releases of everything: PHP 4.1.1 and MySQL
3.23.48 - there are a lot of bugs fixed and functionality added in these
Hi Makis,
There are separate PHP mailing lists - you can find them at www.php.net
- Jonathan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:29 AM
To: MySQL list (E-mail)
Subject: PHP with TTF fonts
Hello again!
I see many people works
Call me Ishmael. My whale and I would like to tour Mongolia, but alas, my
whale swallowed a group of Enron executives, including the entire Bush
administration, and now he is too full of money to walk. Please help me by
sending your bank account information so I can safely deposit the money in a
s
Not sure if this is a tough one or an easy one. Take a shot at it - maybe
you can solve it.
I have a production server running 3.23.36-log, and I just set up a
development box about a week ago. The development box was intended for
testing out new versions of things, so we had MySQL 3.23.42 on the
While I don't like the idea of limiting messages to subscribers (I hate
signing up for things, especially when I'm only going to post a few
messages), I think it's still very important. Like any other problem,
ignoring it will only send a message of passive acceptance and the amount of
spam WILL i
A good spam-blocking keyword is the word "guarantee." Just block out
messages with that keyword and most of your spam issues will go away. I've
used that technique for a couple years now, and it's worked great. I've had
to add a couple other words to my filter to pick up on adult material as
well,
You can also try replacing quote marks with their HTML-equivalent entities.
Put this function in your code somewhere:
function PrepareQuotes($Var)
{
$Var = str_replace("'","'",$Var);
$Var = str_replace('"',""",$Var);
return $Var;
}
And on variables that might have apost
This sounds like it could be a caching issue. Are you running a Windows or
UNIX-based machine? Each should have methods to track what processes are
using memory and how much memory they are using.
- Jonathan
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Ja
It's mysql_query($sql3) not mysql_result($sql3)
- Jonathan
-Original Message-
From: Matt Rudderham [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 11:31 AM
To: [EMAIL PROTECTED]
Subject: Could you look at this PHP/MySQL Code?
Hi,
This is generating an error:
Warning: Wro
This might help:
http://php.sitecreative.com/faq.php#3
- Jonathan
-Original Message-
From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 8:59 AM
To: [EMAIL PROTECTED]
Subject: Implement a menu structure using an relative database
Hi!
I'm currentl
use a REGEXP:
http://www.mysql.com/doc/R/e/Regexp.html
- Jonathan
-Original Message-
From: julian haffegee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 01, 2002 2:11 PM
To: [EMAIL PROTECTED]
Subject: where
Hi,
I have recently gained access to mysql (new isp), and am converting my
SELECT * FROM table WHERE (Status != "closed") OR ((Status = "closed") AND
(Date > Now - # of seconds in 2 weeks))
That should work if your Date field is just a regular timestamp. It all
depends on how you're storing the date...
- Jonathan
-Original Message-
From: Chris Boget [mailto:[E
If you use a premade one - maybe... but if you create one from scratch with
only the datadir variable, then it shouldn't. But if you create one from
scratch, at least print out a premade one and make sure you create it
correctly.
You may also want to examine the command you use to start MySQL. It
If you're using PHP, there should be a function for it.
You can also use IF NOT EXISTS in your table commands like:
CREATE TABLE IF NOT EXISTS, so that you don't overwrite anything.
What also might come in handy here is either SHOW TABLES (provided you're in
the right database), or DESCRIBE tabl
You should be able to change the data-dir variable in your /etc/my.cnf file.
If the file isn't there, you can either create it or use a premade one and
fine-tune it. If the datadir variable isn't in the my.cnf, you can add it.
Read the first two parts of this chapter (they're short) for a few mor
My first guess is that you have a problem with MySQL restarting frequently.
If you have a bunch of problems, it might restart in the middle of a
script... Try turning on logging on the MySQL server and see if it's
restarting frequently.
Second guess would be that there was a problem with either t
It must be a joke. I program in PHP day in and day out - PHP and MySQL
literally make up about 80% of my day, and I KNOW that PHP does NOT drop the
MySQL connection at the end of every PHP block, unless you specifically tell
it to close the connection each time. Instead, it normally will shut down
I suggest installing FoxServ, which installs a combination of Apache, PHP,
and MySQL. Does it without a hitch. Great for development systems.
- Jonathan
-Original Message-
From: Dan Wolfe [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 6:24 PM
To: [EMAIL PROTECTED]
Subject: MY
If you use PHP, you can use my utility dbUtils at
http://php.sitecreative.com - it has functions for synchronizing databases.
- Jonathan
-Original Message-
From: Ananth Rajaraman [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 2:17 AM
To: [EMAIL PROTECTED]
Subject: Database Sy
No - instead, update the password with a new, random one, and e-mail the
random one to the user.
- Jonathan
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:37 PM
To: MySQL List
Subject: PASSWORD() question
Hello,
I have some userna
Just wondering if there's a built-in or distribution utility that comes with
MySQL (like mysqlhotcopy) that will output a file with SQL commands to
recreate a database. phpMyAdmin has a tool for doing this but I don't know
if there's something else built-in already that has that functionality.
-
#x27;t work. But you can find those records that have more than
one space in them by running THIS query:
SELECT * FROM table WHERE name REGEXP ".* .* .*"
- Jonathan
-Original Message-
From: Gill, Vern [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 10:45 AM
To: '
$sort = urlencode($sort);
if ($page_num != $total_num_page){print " Next
Page
The %20 will only appear in the link, not in the query.
- Jonathan
-Original Message-
From: Paul Markov [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 8:56 AM
To: Jonathan Hilgeman; 'Don R
Try this query:
UPDATE table SET phone = concat("(",left(phone,3),")
",mid(phone,3,3),"-",mid(phone,6,4));
It should convert 00 to (000) 000-.
Take a look at this page if you want details on how it works:
http://www.mysql.com/doc/S/t/String_functions.html
- Jonathan
-Original Me
Try adding a line right below $sort:
$sort = urlencode($sort);
It should add the %20s for you.
- Jonathan
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 02, 2001 8:35 PM
To: Paul Markov
Cc: [EMAIL PROTECTED]
Subject: RE: Netscape ignores %20 with $so
> Please please please take the time to look at this problem.
>
> I'm running MySQL 3.23.36 on FreeBSD 4.2. The only application that
> connects and manipulates MySQL is a single PHP application running on PHP
> 4.0.3.
>
> I've eliminated all the errors I can think of and tried to optimize all
>
I know this is a really simple thing that I'm just missing. Basically I want
to store Apache logs in a mySQL database, in a table with 9 fields. I want
each entry to be completely unique via all 9 fields. So, if fields 1-8 in a
new record are all identical to fields 1-8 in an existing record, but
I'm basically looking for two things:
1) An article/tutorial/document discussing operating system threads. I keep
hearing about LinuxThreads on FreeBSD, and how MySQL won't run correctly
with pthreads or something like that. I need to learn about threads and when
and where they're used or not use
Not sure if you're using PHP to manipulate MySQL or not, but if so, I had
the same problem and found the answer from someone on PHPBuilder, and then I
mirrored the answer on my site here:
http://php.sitecreative.com/faq.php#3
Hope it helps.
- Jonathan
-Original Message-
From: Benjamin
Hello All,
I believe I've found a reason for and a fix to a problem I've been
experiencing for some time now. My MySQL server has been restarting
frequently - once, twice, even three times a day for the past few months. If
I shutdown MySQL and run myisamchk on the tables, I'd get:
myisamchk: MyIS
I keep getting this error randomly when trying to connect to the MySQL
server:
Can't create UNIX socket (55)
It happens when trying to connect either through PHP or via the shell (mysql
command). I haven't had this problem before - any thoughts? It only happens
temporarily, and then resumes workin
low a certain CPU utilization?
- Jonathan
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 11:39 AM
To: Jonathan Hilgeman; [EMAIL PROTECTED]
Subject: Re: MySQL - Got Signal 11 - URGENT
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman
I have an app that uses about 6-7 databases. But the MySQL server is now
restarting a lot. I was having a problem with this before - I had about 267
restarts in a matter of a month or two. I shut down the server, ran
myisamchk on the databases and it found a lot of open connections, and I
guess cl
If I use a FLUSH TABLES command, what will happen to others that might be in
the middle of using a table?
I have a PHP application running on PHP 4.0.3 that doesn't seem to close
tables properly, and I am constantly having trouble with the mySQL server
crashing on me.
I shut down the server, ra
What a shameless plug.
> Given other questions, I'll provide a quick update on NuSphere.
> Our product line has been expanding recently and we are pleased to
- Jonathan
> Speaking of green eggs and ham, that is the breakfast of choice
> for our developers - the ones who made our new product: "N
The best way I've found to convert MS Access to mySQL is via ODBC.
1. Just set up ODBC on Windows (an easy install process - just run the
install program that you can download from MS)
2. Install MyODBC (you can download this from MySQL's site - somewhere in
their downloads section)
3. Go into
I have not tested this with the primary key - my previous suggestion went
off the logic in my head at the time (most likely not a good thing, since
I'm tired right now), but I have a feeling Bill here is probably correct if
he says it's possible with the primary key as well. I stand corrected.
-
You can't use a primary key for that, but you CAN make a unique two-column
key:
ALTER TABLE MyTable ADD UNIQUE MyNewIndex (Column1,Column2)
- Jonathan
-Original Message-
From: Brendin [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:37 AM
To: [EMAIL PROTECTED]
Subject: prim
> I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host
> about 1000 very small sites on a fairly fast server with plenty of RAM and
> space. However, it keeps shutting down frequently and every time it shuts
> down, the binary log files rotate, and someone will probably try t
I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host
about 1000 very small sites on a fairly fast server with plenty of RAM and
space. However, it keeps shutting down frequently and every time it shuts
down, the binary log files rotate, and someone will probably try to access
The Jonathan Tutorial
Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com
2. Download and install MyODBC
3. Set up a new ODBC connection for the new mySQL server
4. Open up the database in access
5. Go to the File menu and choose to Export (Tables?)
6. At the bottom of
Pretty much.
- Jonathan
-Original Message-
From: Yiu Wing [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 7:44 PM
To: Mysql List; Jonathan Hilgeman
Subject: Re: Server + database on a CD??
> Jeremy is correct. I've done it before - but if possible, it is better to
Jeremy is correct. I've done it before - but if possible, it is better to
have a program that copies the databases to a writable storage disk like the
hard drive or a network drive, in case you want to update it later (you
don't have to burn a new CD every time)
- Jonathan
-Original Message-
Not that I don't understand your viewpoint, but you have to realize that
almost any and every mailing list is published in more than one place. Any
person who posts to this list is knowingly publishing to an unknown
audience. I find it odd that you are comfortable with publishing to one
unknown a
to will refer others word-of-mouth if it
helped them.
- Jonathan
-Original Message-
From: Eric Frazier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 10:41 AM
To: Jonathan Hilgeman
Cc: 'Cathy Cunningham (Blue World Lasso Evangelist)';
[EMAIL PROTECTED]
Subject: RE: A CO
The harm doesn't come from you offering something beneficial to the MySQL
community. It comes when you abuse the privileges of being on this list and
send spam. While there may not be anything in stone that says not to send
commercial software advertisements, you should know better. The only thing
I always use
INSERT INTO table SET field1='value', field2='value', etc...
If I don't specify fields like an auto-incrementing number, it is filled in
automatically.
- Jonathan
-Original Message-
From: sjs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 5:51 PM
To: [EMAIL
I want to start logging all queries on a mySQL server, but it is already
running. I would prefer not to shut it down, but if I have to, then I am not
sure how to start it up again without binding it to my logged-in self, so
that when I log out of the system, the program doesn't stop. Is there anyw
Hi People,
I'm new to this list, so forgive me if I sound like a newbie. Anyhow, here's
my issue...
I have a script that notifies me when there are mySQL errors in one of my
PHP scripts. Today I just got an error saying that "MySQL server was gone."
I checked it out and noticed that it was still
68 matches
Mail list logo