select * returns nothing

lso goes for the other tables in the database. Is there something else I can do to track down what may be going wrong? Thanks, John Hunter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

delete after undo

one can offer some quick help or tell me to go to a backup (too old :-( ) or go drown my sorrows in a beer. Thanks, John Hunter mysql version 3.23.37 sql,select (keywords to match spam filter) - Before posting, please check: h

Re: delete after undo

, really sure there is no way to get at this information with mysql? It has not been deleted from the filesystem yet... Thanks, John Hunter sql, select (spam filter evador) - Before posting, please check: http://www

Re: delete after undo

> "Joel" == Joel Rees <[EMAIL PROTECTED]> writes: Joel> This begins to sound like a job for Perl. Of course, it Joel> would be nice if you could get someone familiar with the Joel> internal formats mysql uses to give you some hints Yes, I am having trouble deciphering the primary

replication through port forwarded firewall

concern is about the machine names. The slave thinks the master server is named eg, master.name.com, but the master server thinks it is named master.internal.domainname. So I am wondering if this will muck things up. Has anyone done this before? Thanks, John Hunter Master: mysql Ver 11.13

Re: replication through port forwarded firewall

> "Van" == Van <[EMAIL PROTECTED]> writes: Van> No. Just have the slave connect to the master using the ip Van> address. I have set up the master and slave now and am getting a problem. When the slave tries to connect, it appears to be attempting to enter a value that is already i

Re: replication through port forwarded firewall

mother-bin.* files on it and it gets the mysql user dir from the master. Is this correct? Stumped. Thanks, John Hunter Master mysql version: 3.23.37 Slave mysql version: 3.23.36 Error message: 020315 9:30:52 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started

modifying table with sort/unique

modify the table in place to remove the duplicates? If not, how do I create a temporary table with duplicates suppressed, and then rename/copy this table to the original table name? Thanks, John Hunter - Before posting, please check

Re: modifying table with sort/unique

One further question. Will this automatically keep my rows ordered by the primary key with future inserts? Thanks for your help, John Hunter - Before posting, please check: http://www.mysql.com/manual.php (the

daemon doesn't start at boot; RHL 6.2

c.d/init.d/mysql.server* Is there some other incantation I need to make to get this to start properly at boot? I enter runlevel 5 by default at boot. Thanks, John Hunter Here is the exact sequence I did at install and configure: /usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql cd /usr

Re: daemon doesn't start at boot; RHL 6.2

> "Atle" == Atle Veka <[EMAIL PROTECTED]> writes: Atle> You say you go to runlevel 5 at boot? In that case, you need Atle> to put the S99mysql into the rc5.d/ directory.. Ok, thanks, I'll try that. But I thought the runlevel 5 stuff was only executed after the runlevel 3 stuff, so t

Re: daemon doesn't start at boot; RHL 6.2

>>>>> "Atle" == Atle Veka <[EMAIL PROTECTED]> writes: Atle> You say you go to runlevel 5 at boot? In that case, you need Atle> to put the S99mysql into the rc5.d/ directory.. That worked. Thanks, John Hunter ---

creating a new table from existing one

thin the given GROUP BY ticker/day. Thanks, John Hunter - 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

Re: creating a new table from existing one

get the closing quote. I have a fairly large data base (almost 400MB) and am wondering if there is a better way than reverse sorting the whole table into a temporary table. My approach is below. Comments are welcome since I am trying to learn/improve my SQL (pun intended). Thanks, John Hunter