comparing two databases

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]

Re: comparing two databases

/database_compare.png Best Regards, COS - Original Message - From: "Steve Buehler" <[EMAIL PROTECTED]> To: "mysql" 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 > dat

quote for job

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

Re: Use MySQL with Microsoft Office

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" >

Re: where to get a mysql licence

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. Stev

Re: Replication only DB

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 did

Re: Problem: Too many connections

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 se

Re: phpmyadmin can't connect via browser

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

Re: phpmyadmin can't connect via browser

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

learning to understand compress function

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

Re: learning to understand compress function

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

Re: Question

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 d

firewall ports to open

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 330

check for duplicate databases

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,

finding backslash

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

Re: MySQL and PHP

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

Re: traverse the recordset more than once

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 = $sth->fetchrow_arr

Re: traverse the recordset more than once

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 = $sth->fetchrow_arr

Re: persistent temporary tables

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 inser

COUNT(*) faster?

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 colum

duplicating databases

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

Re: DROP TEMORARY TABLE

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 thin

Re: php temp table question

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 looses

RE: DROP TEMORARY TABLE

drop the temporary tables, 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 Mess

GRANT CREATE TEMPORARY TABLES

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 tables

RE: GRANT CREATE TEMPORARY TABLES

a INSERT INTO ... SELECT 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 TA

Error 1148 and 1045

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

single quotes in database

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.

mysqladmin shutdown

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

mysql backup script

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

Re: mysql backup script

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 >

Re: copying tables

2002, 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(

copying tables

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 rea

Dropping Tables

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 mea

RE: [PHP] Dropping Tables

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

tinyint and NULL

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) int

Checking if table empty

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 wou

Re: Checking if table empty

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: <[

Dropping tables

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

Re: Dropping tables

why 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

addition problem

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 anybo

Re: addition problem

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 >tak

CREATE TEMPORARY TABLE

ve a temporary table 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

RE: CREATE TEMPORARY TABLE

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 speci

mysqldump

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 vi

Re: mysqldump

the results instead. Thank You Steve At 09:10 AM 4/12/2002, Jason Yates wrote: >On Fri, 2002-04-12 at 10:56, Steve Buehler wrote: > > I am using PHP to run the following command: > > passthru("mysqldump -q -u$userName -p$password -h$hostName $databaseName"); > > >

mysqldump

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 -p$

Re: Max 127 records

the problem before too. So if you want 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. :) St

Order by

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 100U

Re: [PHP] Ordering output

Thanks Steve At 04:51 PM 4/25/2002, you 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

Re: Query to insert not in

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

Re: confirm unsubscribe from mysql@lists.mysql.com

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 >[EMAI

RE: confirm unsubscribe from mysql@lists.mysql.com

>-Original Message- >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

dupe records

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 in the SELECT statement. AnywayWhat I want to do is to select records from a table but if there i

RE: dupe records

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 w

mod_auth_mysql

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 -I/

RE: newbie help

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 [mailto

Re: trouble with field NULL

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.

Re: trouble with field NULL

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'; >>

RE: Project Time

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

RE: Project Time

Thanks. That is what we all wanted. Steve At 04:02 PM 5/13/2002, Robert L. Yelvington wrote: >http://freshmeat.net > >Methinks this is what Jay meant! > >;) > >~Rob > >%-Original Message- >%From: Steve Buehler [mailto:[EMAIL PROTECTED]] >%Sent: Monda

Deleting from multiple tables

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'"); $result=mysql_query

Deleting from multiple tables

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'"); $result=mysql_query

Re: Deleting from multiple tables

At 03:34 PM 5/23/2002 -0400, Keith C. Ivey wrote: >On 23 May 2002, at 12:48, Steve Buehler wrote: > > > 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 t

SELECT and WHERE clause

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 team

Re: SELECT and WHERE clause

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 > l

Cyber Cafe software

Linux, 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 &l

Re: Cyber Cafe software

can ever figure 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

time stamp

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 -

RE: time stamp

m";} if($hour > 12){$hour = $hour-12;} if(!$month){ return "nothing"; }else{ return "$month-$day-$year $hour:$min $ap"; } */ } Thank Again Steve At 08:28 AM 8/28/2002 -0700, you wrote: >Steve >

Removing duplicate entries

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 this

Re: Removing duplicate entries

Thank You so very much. Your way was great, fast and efficient. Here is my line of code: insert into sub2 (email,list_id) select email, list_id from subscribers; Thanks Again Steve Buehler At 03:31 AM 8/14/2001, you wrote: >I'd do it this way: > >insert into table table_new &