I have a client that is looking for a setup and was hoping that
somebody here could give me a quote for the job. I can't give ALL of
the details, but I am hoping that this will be enough to get a
quote. I am not looking for a hardware quote. Just one for setting
this up software wise.
20
/database_compare.png
Best Regards,
COS
- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Thursday, September 28, 2006 5:06 PM
Subject: comparing two databases
Is there a program out there that I can use to compare two
databases? Just
Is there a program out there that I can use to compare two
databases? Just the structure, not the content.
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to figure something out about the compress function. If I
wanted to compress a field in a column/row and write it back to the table,
how can I do this? Is it possible to do it in one command? I tried:
update `conflicts` set `fname`=(SELECT compress(`fname`) FROM `conflicts`
WHERE
At 08:50 AM 5/11/2005, you wrote:
Steve Buehler [EMAIL PROTECTED] wrote on 05/11/2005 09:36:44 AM:
I am trying to figure something out about the compress function. If I
wanted to compress a field in a column/row and write it back to the table,
how can I do this? Is it possible to do
At 08:15 AM 3/13/2005, you wrote:
Hi All,
have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed
the url path like below, but, when typing
localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following,
cannot load mysql extension,
please check PHP Configuration
Documentation
At 08:59 AM 3/13/2005, you wrote:
Steve Buehler wrote:
At 08:15 AM 3/13/2005, you wrote:
Hi All,
have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and
changed the url path like below, but, when typing
localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following,
cannot load mysql
At 01:25 AM 3/12/2005, sapna murari todwal wrote:
Hi,
I have a live site using mysql. It is heavily used with over thousand
users per minute, with 3 select / update queries per user per minute
accounting to over 3000 queries per minute.
The problem is that many times connection to this mysql
At 02:35 AM 3/11/2005, you wrote:
You can simply specify the database:
--replicate-do-db=db_name
Stupid/Not so Stupid question here. What mysql program has that option? I
searched mysql.com and couldn't find it. I have looked at the man pages
for mysql, mysqld, mysqladmin and mysqldump and
At 08:48 AM 3/10/2005, Bungarz, Kai wrote:
Hi!
I wonder, where i can get answers about mysql licences.
Does anybody know an adress to contact to?
Best regards,
Kai
http://www.wido.de
I might be wrong, but shouldn't the first place you look be the mysql.com
site? Sounds logical to me anyway.
For the answer to that question, you might just want to go see for
yourself. http://www.openoffice.org/
Steve
At 08:16 AM 3/8/2005, you wrote:
Does Open Office have a MSPublisher like program?
On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED]
wrote:
From: Tom Crimmins
On
At 08:30 AM 1/27/2005, electroteque wrote:
i have come to realise that temporary tables are only persistent for 30
secs, is there a way to extend that ? My applications is attempting to
store data before and entry is made and then insert the data from the
temporary table after the entry is
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the for loop for retrieving each
record from the recordset.
$aref =
At 08:11 PM 1/5/2005, you wrote:
Hi list,
How can I traverse the recordset moret than once?
For example, the recordset $sth is returned from executing the sql statement.
The following statement is writen with the for loop for retrieving each
record from the recordset.
$aref =
You didn't say which Linux you were using and I am not sure about the rest,
but if you are using RedHat, you probably need to install php-mysql which
is A module for PHP applications that use MySQL databases. If you can
use up2date, you can type in up2date php-mysql and that will let you run
I am trying to find everything in a column that has a backslash in it and
the select statement that I am trying to use doesn't find any of them. My
statement is:
SELECT * FROM `team` WHERE `name` LIKE '%\%'
I have also tried:
SELECT * FROM `team` WHERE `name` LIKE '%\\%'
Any idea how to search
of the type of backups that I needed and how they were to be done,
webmin was not an option. Thanks though.
Steve
At 11:29 AM 6/15/2004, Brian Reichert wrote:
On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote:
I am having a problem with a backup script that is written in a shell
(/bin/sh
I am having a problem with a backup script that is written in a shell
(/bin/sh) script to backup my mysql databases. For some reason on any day
with an even number I get the following error:
MySQL could not be stopped, exiting...
It is really weird because it will run on odd number days without
Was wondering if anybody knows if there are advantages to using
mysqladmin -pPassword shutdown compared to /etc/rc.d/init.d/mysqld
stop? I have a script that was using mysqladmin to shutdown the daemon
and then /etc/rc.d/init.d/mysqld start to restart it. Problem was, and I
am not sure if
I am trying to allow someone to access our mysql server that is behind our
firewall. If I open the firewall ports 3306-65000/tcp the person can get
through. If I just try to open up the port 3306/tcp, they can not get
through. Is there another port that I need to open also? I have tried
At 09:34 PM 12/18/2003, [EMAIL PROTECTED] wrote:
Dear friends,
I downloaded mysql on windows 98.
I entered
cd c;\mysql_install_db
It is responding as too many parameters
Can anyone advice how to fix it, please.
Delmar
Take out the semi colon and put in a colon if you are trying to change to a
I am using PHP/MySQL and am having a problem. We have some names and
addresses in the database that have single quotes in them. For
instance. There is a town around here called Lee's Summit. Also names
like O'connel. When I pull from the database it skips these because of
the quotes. I
TEMPORARY TABLES are suppose to work this way. They are only there during
a connection and then dropped when the connection to the database is
closed. One thing they are great for is when you have temporary information
that needs to be kept and worked with. One of my programs has to pull
At 03:04 PM 10/27/2003, you wrote:
Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a problem
with the next execution of the script when it tries to create the temp table
again?
It won't. If the client
, but without having to give it DROP TABLE priveledge which is a lot
more worrying.
Note I'm cross posting this into the Java list too, incase I'm wrong about
my understanding of pooling and someone there can correct me :)
Many Thanks,
Mike
-Original Message-
From: Steve Buehler [mailto
Ok. Someone else was talking about this earlier in the list, but I didn't
see the answer that I am looking for. I have just setup a new RedHat 9.0
server with MySQL 3.23.58. My program that worked on an older version of
MySQL doesn't work on this one. The problem is that the temporary
statement to manipulate
the mysql tables directly and then do a flush priveledges.
Hope that helps,
Mike
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]
Sent: 28 October 2003 13:51
To: mysql
Subject: GRANT CREATE TEMPORARY TABLES
Ok. Someone else was talking about
I have upgraded my mysql version to 3.23.58 and am coming up with a couple
of errors using phpmyadmin to Insert data from a textfile into table I
didn't get this on the previous versions of mysql. Here are the errors:
SQL-query :
LOAD DATA INFILE '/tmp/phpKFlQ2b' INTO TABLE `annsubscribers`
I am running PHP/MySQL for a program that I am writing. We will have
100's or 1000's of databases that will be duplicates in structure. The
problem is when I make a change to the database, I have to go to every
database manually and make the change. All of the databases start with
a_ and
I am using PHP MySQL for a program that I am writing. I have a table in
my database that has a column with dates in it in the form
-mm-dd. Sometimes there is nothing in the table with the search date
that I am using. Other times there might be 1000's of rows with that in
the date
I have a program that I am writing in PHP/MySQL. I have made some upgrades
to the database and like an idiot, forgot to write down the changes or to
make the changes in several other databases for the other clients that are
using the program also. What I am trying to do is to have a program,
I have researched this and can't find an answer. Maybe I am just looking
in the wrong places or not putting the correct keywords into the search
engines. So any help would be greatly appreciated. I am using MySQL with PHP.
I have some PHP scripts that create tables in a database that are
Thank You so much John and Michael. SHOW TABLES LIKE 'a%' worked like a
charm and was exactly what I was looking for. I guess my searches were
using the wrong keywords. Kind of figures. Some of my searches were
turning up 1000's of results.
How do you know whether it's an active a* table
, at 12:54, Steve Buehler wrote:
What I am trying to do is to copy a mysql table to a new
table name in a PHP script.
Use the query SHOW CREATE TABLE $from_table to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
'/^CREATE TABLE
Using PHP and MySQL.
I have looked and can't find the answer to this problem. What I am trying
to do is to copy a mysql table to a new table name in a PHP script. The
reason for this is to keep the original table the way it is and editing the
copy. Now, I know that I can go through a loop
MAX(field_timestamp) from table1;
David
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:21 PM
To: mysql; PHP
Subject: time stamp
I am using PHP with MySQL and have a timestamp field in my db
table. What
would
I am using PHP with MySQL and have a timestamp field in my db table. What
would be the easiest way to get the newest timestamp out of the db?
Thanks in Advance
Steve
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
ow3
out how to do this, I will try to post the
results to the lists so other people can use it and improve it as they see fit.
Thanks
Steve
At 09:08 PM 6/3/2002 -0500, Bret Hughes wrote:
On Mon, 3 Jun 2002, Steve Buehler wrote:
Does anybody know of any software all ready written or what would
, PHP and MySQL.
Thanks In Advance
Steve Buehler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
I am using MySQL with a PHP front end. Is there a better way to delete
from multiple tables than the following?
$result=mysql_query(DELETE FROM team WHERE team_id = '$team_id');
$result=mysql_query(DELETE FROM conflicts WHERE team_id = '$team_id');
Ok. I can NOT find out what I am doing wrong. The book makes it look like
any of these would work (deleted is a column name):
SELECT team_id,name FROM team WHERE deleted NOT LIKE '1' ORDER BY 'name'
SELECT team_id,name FROM team WHERE deleted != '1' ORDER BY 'name'
SELECT team_id,name FROM
That did the trick. That just seems like it shouldn't have to be that way.
Thanks a LOT
Steve
At 05:50 PM 5/23/2002 -0400, Keith C. Ivey wrote:
On 23 May 2002, at 15:20, Steve Buehler wrote:
Ok. I can NOT find out what I am doing wrong. The book makes it look
like
any of these would
Do you know if freshmeat is only online certain times of the day/week? I
have tried from several different servers of ours to get to it, but it
always gives me the Cannot find server message.
Thanks
Steve
At 11:38 AM 5/13/2002, Jay Blanchard wrote:
[snip]
Does anyone know where I can get
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null;
I have to do it like this:
UPDATE games SET game_id = NULL;
NO QUOTES of any kind.
At 01:22 PM 5/10/2002, Paul DuBois wrote:
At 13:11 -0500 5/10/02, Steve Buehler wrote:
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null
I hope that someone can help with this. I am trying to install
mod_auth_mysql as a DSO, but I get errors.
Here are the errors when compiling mod_auth_mysql:
/usr/local/src/mod_auth_mysql-2.20# cp config.h auth_mysql_config.h
/usr/local/src/mod_auth_mysql-2.20# /usr/sbin/apxs -i -a
What makes you think that it is an imposter site? They both have the same
IP address, they are both the same site.
# nslookup mysql.org
Name:mysql.org
Address: 64.28.67.70
# nslookup mysql.com
Name:mysql.com
Address: 64.28.67.70
-Original Message-
From: Ryan Hatch
Thank you. This is exactly what I needed.
Steve
At 07:56 AM 5/3/2002, Jay Blanchard wrote:
[snip]
Here is probably an easy question to answer, but I can't figure
an EASY
way to do it. Right now, I use a temp table with a unique column to solve
it. I am hoping that there is a way
If you have an indexed column in Table-A, than you can use the
REPLACE command. If the item is already in Table-A, it will overwrite
it. If not, it will work like the INSERT command.
Steve
At 03:36 PM 4/29/2002, Oswaldo Castro wrote:
Hi List
I have two tables inside a MySQL DB.
Anybody know who this Brandy person is and why she is trying to unsubscribe
me? Has anybody else had this child trying to unsubscribe them?
Brandy Trudeau [EMAIL PROTECTED]
Thanks
Steve
At 07:49 AM 4/30/2002, [EMAIL PROTECTED] wrote:
Hi! This is the ezmlm program. I'm managing the
[EMAIL
-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 1:00 PM
To: mysql
Cc: Brandy Trudeau
Subject: Re: confirm unsubscribe from [EMAIL PROTECTED]
Anybody know who this Brandy person is and why she is trying to unsubscribe
me? Has anybody else had this child trying
Is there a way to use ORDER BY, or something else, that will order the
following in numerical order instead of alphabetical order? The column
that the data is in is:
short_description varchar(20) default NULL.
21UG3
10UB5
100UB6
1UG1
The way it comes out with ORDER BY is:
1UG1
10UB5
100UB6
wrote:
On Thursday, April 25, 2002, at 05:38 PM, Steve Buehler wrote:
Thank you for wanting to try and tackle this in PHP/MySQL. I will
include the code that I have and also the sql for the tables.
...
Here is my Select statment
Select * from $temp2 where sea_id = '$sea_id' order by pts DESC
to go past 127, you
either need to set it as an Unsigned value, but that will only let you go
to 255, or set it to another int. smallint will go to 65535 (Unsigned),
mediumint will go to 16777215 (Unsigned), etc.
Happy to finally be able to help. :)
Steve Buehler
At 07:38 AM 4/19/2002
I am using PHP to run the following command:
passthru(mysqldump -q -u$userName -p$password -h$hostName $databaseName);
The problem is that it puts EVERYTHING on one line and, of course, and
wraps it. I want to be able to dump the dump(schema) of a database onto a
web page so that they can
I know this is more of an php question, but I think that some of the mysql
people that use PHP might want to know about this in case they need it
since it is for accessing a dump of a mysql database.
I found two ways of doing this:
1. (using the exec() method)
exec(mysqldump -q -u$userName
called table_name that only their connection can see, meaning that there
would actually be 100 tables with the same name?
I sure hope that makes since.
Thanks
Steve Buehler
-
Before posting, please check:
http://www.mysql.com
Thank You. That is what I was hoping for. I would assume that this would
be faster than actually coming up with a random name, using srand and rand,
for a table, creating it and deleting it when done.
Thanks
Steve Buehler
At 02:19 PM 4/8/2002, you wrote:
Yes a TEMPORARY TABLE is specific
I hope that someone can help me with this. I understood that if I do an
update on a row in a table, I could use the SET row=row+1 and that would
take what was in that row/column and add a 1 to it. For some reason, it is
doubling it. My end result is always twice what it should be. Can
Just to let everybody know. I found my stupid problem. I was executing
the statement twice.
Thanks
Steve
At 03:58 PM 3/27/2002, you wrote:
I hope that someone can help me with this. I understood that if I do an
update on a row in a table, I could use the SET row=row+1 and that would
take
Is there anyway to drop a group of tables with a wildcard in MySql? I have
tried:
DROP TABLE IF EXISTS division1s*
and
DROP TABLE IF EXISTS division1s(*)
but neither one works. I am hoping that there is a good useable answer to
this.
Thanks in advance
Steve Buehler
your suggestion would not work. So I will thank you before I even try
it. :)
Thanks
Steve
At 09:58 PM 3/25/2002, you wrote:
At 16:40 -0600 3/25/02, Steve Buehler wrote:
Is there anyway to drop a group of tables with a wildcard in MySql? I
have tried:
DROP TABLE IF EXISTS division1s*
and
DROP
I have a strange, but probably easy to fix problem. I need to check to see
if something is in a table...that part is easy, but if the table is empty,
it doesn't go through my while statement so that I can create something
in it. I am sure that if there was something in the table, that I
Thank You. This did the trick. I knew that it had to be something
simple. I wasn't even thinking of a if(!$row) statement.
Steve
At 10:05 AM 3/14/2002, you wrote:
- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 14 March, 2002 17:46
I have some fields set up in my MySQL database table as
tinyint(5)
The problem is that it will not except a NULL unless I specifically tell it
NULL. I have a form that allows for input. When submitted, it updates the
database. If the field on the form is empty, it still puts a 0 (zero)
into
not receiving email from the list for some reason.
Thank You
Steve Buehler
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
66 matches
Mail list logo
