All,
I have a table which was accessible for the last couple years but is now
inaccessible after performing a simple alter table command.
There are approx. 10 tables in this database on which the same alter table
command was given ("alter table table_name add glperiod varchar (3) null
first;"
I'm having the same problem.
At 12:27 PM 11/12/2001 -0500, [EMAIL PROTECTED] wrote:
>Howdy,
>I'm running version 3.23.41 on RH7.2. For the life of me I can't figure
>out why
>I can't stop mysqld. Linuxconf was where I first noticed this where mysqld
>would
>not respond to the stop request. I
Thanks Gerald!!
That did the trick and everything seems to be running perfectly!
At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote:
>Unfortunately, when you moved the directories, you forgot to make mysql
>the owner
>of the new directory.
>
>chown -R mysql /data/mysql
>
>
Hello everyone!!
I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and
want the "datadir" to be "/data/mysql/data". In my "/etc/my.cnf" file I
have the directive:
[mysqld]
datadir=/data/mysql/data
The installation completes but the daemon won't start. I do the
mysql_instal
Is anybody else not able to get onto mysql.com???
-
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
Anyone,
I've noticed that when I do a mysqldump, all of the backup information is
also written into the binary log. Am I doing something wrong or is there a
way to not log the mysqldump??
Thanks,
Phil
-
Before posting, plea
When restoring a backup, the binlog will record all of the backup's
commands (create tables and insert into's). Would it therefore be a good
idea to flush the logs before a restore and then flush the logs immediately
after so that the "restoration log" can be deleted (or ignored)?
---
Anybody:
I've installed (and got working!) MySQL on my Windows 2000 pc and am trying
to use the "my.cnf" file.
1) The manual says that my.cnf is included in the installation and that I
should copy it to c:\my.cnf. ("Copy the file `\mysql\my-x.cnf' to
`C:\my.cnf' and edit it to suit your s
Jeremy,
I did test it and couldn't get it to work one way or the otherHowever,
as it turns out, the '--binlog-ignore-db' option will work for me.
Thanks for all your help!!
Phil
At 11:03 AM 7/10/2001 -0700, you wrote:
>On Tue, Jul 10, 2001 at 09:20:35AM -0700, Ph
At 03:01 PM 7/9/2001 -0700, you wrote:
>On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > We do a few large daily and monthly downloads from an Oracle database
> > > server. Is there a way to exclude these specific queries from the
> > > update/binary log??
> >
> > If the queries o
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
-
Before posting, please check:
http://www.mysql.com/manual.php (
I tried this query:
Update phone inner join tmpphone on phone.empno = tmpphone.empno
set
phone.lname = tmpphone.lname,
phone.fname = tmpphone.fname
and it didn't work.
This works in MSAccess.
Is this syntax (or something like it) supported by MySQL??
-
I tried this query:
Update phone inner join tmpphone on phone.empno = tmpphone.empno
set
phone.lname = tmpphone.lname,
phone.fname = tmpphone.fname
and it didn't work.
This does work in MSSqlServer 7.
Is this syntax (or something like it) supported by MySQL??
13 matches
Mail list logo