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
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
Delete anonymous user('') from table user. Don't forget about FLUSH
PRIVILEGES.
Thanks, that worked. Why?
shaking head 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
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
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
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
. 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: Tuesday, April 02, 2002 10:53 AM
To: 'Jonathan Hilgeman'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE
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(nbsp;nbsp;...yadayada);
look up the syntax - I never use
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
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-
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 us
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.
grin
- Pastor Jonathan Reverend
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
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
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
: 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 recreate it on Linux, Solaris).
(2
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
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
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
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(',#039;,$Var);
$Var = str_replace('',#034;,$Var);
return $Var;
}
And on variables that might have
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:[EMAIL
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
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
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:
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,
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
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
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
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 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
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
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:
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
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
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
){print a
ref=\./propview.php?$guidestringcur_page=$nextpagesort=$sort\Next
Page/a
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 Read
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.
-
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'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
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
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:
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
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
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,
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:
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 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
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:
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.
-
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
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
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
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
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
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 COMPANY RELEASES A NON-FINAL VERSION OF SOME PRODUCT
NON
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
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
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
64 matches
Mail list logo