James have you copied over the php and apache confs from the good server to the bad?
One of those might be the cause of the problem.
Is ensim involved here at all? I doubt it as it doesnt really rely on mysql except for
the creation of databases. This is a guess as I have zero ensim experence (but
Hi all,
I just wanted to know if you guys can help me out with this error. It's
actually an sql and jdbc error.
I have a class called employeeDBUtil. In this class, it has a method called
updateEmployee. I wanted to try if the code would work so I created a main
portion in my class.
java.sq
Start the server with --skip-grant-tables. Than anyone can connect and
do anything.
At 20:32 -0700 10/22/02, Jim Hogan wrote:
I have set up MySQl before and have done it "the right way" (I think!)
My situation today? I am setting up MySQL on a Linux machine with a 1394-
attached 80GB drive fo
ROGER!
Thanks a lot. After updating with that GRANT I am now looking at the main
DB in EpiInfo 2000 via ODBC (EpiInfostats and graphics on the cheap
courtesy of CDC if anybody cares)
Anyhow, it seems I was being too specific in my user name in the ODBC
config (jim@somehost instead of jim) g
Sounds like all is set up properly, but, have you give your mysql USERS
permissions to connect from from the 192.168.1 network?
The Really Insecure way of doing this is...
GRANT ALL PRIVILEGES ON *.* TO mysqlusernamehere@"%" IDENTIFIED BY
'mypasswordhere';
FLUSH PRIVILEGES;
Hope this helps
Rog
I have set up MySQl before and have done it "the right way" (I think!)
My situation today? I am setting up MySQL on a Linux machine with a 1394-
attached 80GB drive for a 3-week project after which my setup will be
thrown away. Due to some software dependencies, this DB will need to be
access
I had the same problem. It's in your connection, somehow ASP doesnt retrieve
the results when doing a select and count, so you need to use a connection
like this:
dim myConn
Set myConn= Server.CreateObject ("ADODB.Connection")
myConn.ConnectionString =
"Driver={MySQL};SERVER=xxx.xxx.xxx.xxx;DATAB
Have you tried using a GROUP BY statement - maybe something like:
SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata
GROUP BY ExpDepDate, ActArrDate, Ref
Good Luck!
Dennis
- Original Message -
From: "Morsky Juha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday
Greetings all,
I'm trying to host a discussion forum for my philosophy class...to make a long story
short:
I've now got phpBB2 and MySQL on my virtual domain.
My host doesn't offer any MySQL support. I'm installing phpBB and
I receive an error "critical error: cannot connect with database".
All
sql,query
At 18:45 -0500 10/22/02, [EMAIL PROTECTED] wrote:
Indeed, setting MAX_ROWS lets me create the index. Thanks for the tip.
How would I find out what the MAX_ROWS setting on a table is?
SHOW CREATE TABLE tbl_name;
or
SHOW TABLE STATUS LIKE 'tbl_name';
- Original Message ---
To recap I am trying to run 3.23.52 on FreeBSD 4.6.
I have /tmp symlinked to /var/tmp, and /var is a writable partition, while /
is readonly. When / is readonly mysqld is not able to run.
I've tracked down the problem to the safe_mysqld script. The problem is it
does:
USER_OPTION=""
if
Sorry,
yes I did run myisamchk *.MYI -r in all the Database folders and everything
repaired fine
After trying to restart the Mysql Server, there is a mysql.sock file in the
mysql folder (appears to be left over from the crash).
>From the /var/lib/mysql/mysql folder...
[root@SQLServer1 mysql]#
> does the mySQL always use the same port and which port
> would it be? Is it configured in a file?
Port 3306. I believe it can be changed via my.cnf and on the command line.
-
Before posting, please check:
http://www.mysql.c
Hi,
does the mySQL always use the same port and which port
would it be? Is it configured in a file?
Thanks
Andre
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
---
> At 18:26 -0500 10/22/02, Ed Carp wrote:
> > > 021022 17:54:13 mysqld started
> >> 021022 17:54:13 bdb: PANIC: No such file or directory
> >> 021022 17:54:13 Can't init databases
> >> 021022 17:54:13 mysqld ended
> >
> >Have you tried all the obvious things before you posted?
>
> All the
> I set up two-way replication with two servers, A and B.
> Since all queries go to only one server, it seems not to matter.
>
> Anyway.
>
> When A starts it registers itself to B, and vice versa.
> I thought query "SHOW SLAVE HOSTS" to A should shows only about
> B and B should do about A, but bot
Indeed, setting MAX_ROWS lets me create the index. Thanks for the tip.
How would I find out what the MAX_ROWS setting on a table is?
- Original Message -
From: Ken Menzel <[EMAIL PROTECTED]>
Date: Tuesday, October 22, 2002 4:05 pm
Subject: Re: How to index a large table?
> Just curiou
At 18:26 -0500 10/22/02, Ed Carp wrote:
> 021022 17:54:13 mysqld started
021022 17:54:13 bdb: PANIC: No such file or directory
021022 17:54:13 Can't init databases
021022 17:54:13 mysqld ended
Have you tried all the obvious things before you posted?
All the obvious things being what?
At 16:13 -0700 10/22/02, Andre Kirchner wrote:
Hi there,
I want to load a file where the values of the columns
are separated by one or more tab ( \t ) characters. Is
it possible to configure the "load data" to accept an
unkwnon number of tabs separating these values?
No.
And how can I coment
> 021022 17:54:13 mysqld started
> 021022 17:54:13 bdb: PANIC: No such file or directory
> 021022 17:54:13 Can't init databases
> 021022 17:54:13 mysqld ended
Have you tried all the obvious things before you posted?
> [mysqld]
> datadir=/var/lib/mysql
Is this directory exist - if so, what's
Quick Synopsis.
Server went down due to power failure. Upon reboot the mysql server was not
up and running. When trying to restart I get the following message in the
mysqld.log.
021022 17:54:13 mysqld started
021022 17:54:13 bdb: PANIC: No such file or directory
021022 17:54:13 Can't init d
Hi there,
I want to load a file where the values of the columns
are separated by one or more tab ( \t ) characters. Is
it possible to configure the "load data" to accept an
unkwnon number of tabs separating these values?
And how can I coment one of these lines? I know that
in Oracle I can use "--"
PS: mysqladmin does not output this option as one of the available options.
[root@terra]# mysqladmin -p variables | grep skip
Enter password:
| skip_locking|
ON
Got it. It is "--skip-name-resolve" and that worked around the problem.
What should I be on the lookout for to get a real fix? Will there be a
patch/update/etc for glibc from RH or is there something that the mysql
dev team is coming up with?
Thanks,
Tom
Egor Egorov wrote:
Terra,
Tuesday, Octo
Anybody know of a BOM processing system running on MySQL?
Hosted on Linux or Windows?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
frustrated trying to sort through the diff recommendations & in getting
new server install to work on redhat 7.2, w/ apache 1.3.26, php 4.2.2
source compiled. (ok so i'm new to the free world)
pls correct me if i'm wrong, but i understand don't use rpms (haven't
figured out why not tho), go for
I was wondering if someone could shed some light on setting parameters in
my.cnf. When I set params such as user and password in my my.cnf file I
dont need to then pass these parameters to commands such as mysqldump or
mysqladmin? Is this True? Can someone please send me an example of their
my.c
>From: "Richard Clarke" <[EMAIL PROTECTED]>
>
>What use are these other products to him if his calendar is part of a bigger
>application? What's he gonna do, plonk his webcalendar.sourceforge.net
>instance into the middle of his current application?
Sure! Why not? That's exactly what I did! By sep
Petre Agenbag wrote:
> That works fine, I can log in as my root user and the perms look fine, I
> also use phpmyadmin, and looks fine too, can access all my db's that
> way, just the odbc that seems to be bitchin.
> It's not a train smash, I exported it to my older rh7.0 server over the
> net, but
I didn't see anyone else reply, so I will give you my thoughts.
I thought one of the "list gurus" would give you a much better answer than I
could so I waited.
Assuming that with two decimal places, you are doing something monetary.
But this applies whenever you want fixed decimal places, too.
I
Just curious Chris, did you set MAX_ROWS option during table create
to a really large value? If not alter the the table with this and try
again, it affects the size of pointers used to create the index.
(See CREATE TABLE in the manual)
Hope it helps,
Ken
- Original Message -
From: "Chri
> > >If I type the following at the command prompt, in this
> example I'm using
> > >username for the user name, and 66.66.66.66 for the IP address
> > >(although I use real values)
> > >
> > >mysql -h 66.66.66.66 -u username -p
> > >
> > >it asks for my password then goes off and thinks for a whi
On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
> I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
> of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
> Linux box.
>
> I've tried various combos of installing the Deb packages, compiling from
> so
>Description:
This query produces 16 results:
SELECT * FROM table1
LEFT JOIN table2 ON (field1 = field2)
WHERE field2 = 'something'
ORDER BY field2,field3,field4
But this query produces 0 results:
SELECT * FROM table1
LEFT JOIN table2 ON (field1 = field2)
WHERE field2 = 'something'
ORDER
On Tue, 2002-10-22 at 16:24, Fernando Grijalba wrote:
> You can try this;
>
> mysql>source /path/source.sql
>
> or:
>
> $>mysql -uuser -ppassword DBname < filename.sql
>
> HTH
>
> JFernando
> ** sql ***
>
> -Original Message-
> From: Andre Kirchner [mailto:sieg1974@;yahoo.com]
> Sent:
Correct, that error means "no more room in index file".
So, how do I get more room in the index file?
Paul DuBois wrote:
At 15:11 -0500 10/22/02, Chris Stoughton wrote:
I have 760 GB free, not 375.
Perhaps, but error 136 still means "no more room in index file".
bash-2.04$ df -h .
You can try this;
mysql>source /path/source.sql
or:
$>mysql -uuser -ppassword DBname < filename.sql
HTH
JFernando
** sql ***
-Original Message-
From: Andre Kirchner [mailto:sieg1974@;yahoo.com]
Sent: October 22, 2002 15:58
To: [EMAIL PROTECTED]
Subject: How to execute sql commands fro
Thanks for this, I may well need additional privileges, but I can't see how I
can change these on the remote server without connecting first!
Julia
gerald_clark wrote:
> Check the section of the manual covering the privilege system,
> especially the "GRANT" command.
>
> Julia Maddocks wrote:
>
>
At 15:11 -0500 10/22/02, Chris Stoughton wrote:
I have 760 GB free, not 375.
Perhaps, but error 136 still means "no more room in index file".
bash-2.04$ df -h .
FilesystemSize Used Avail Use% Mounted on
/export/data/dp20.a 1.0T 302G 760G 29% /data/dp20.a
bash-2.04$
The .MYD
Hello mysql,
I setup server (my.ini/my.cnf) with
default-character-set = koi8_ru
Than do 'myisamchk -r -q'
It seems to use correct charset.
i do:
1.it's ok:
INSERT INTO allg
(znum_allg,name) VALUES (20,"À")
2.it's error with
INSERT INTO allg (znum_allg,name) VALUES (20,"Á")
error: Duplicate
That works fine, I can log in as my root user and the perms look fine, I
also use phpmyadmin, and looks fine too, can access all my db's that
way, just the odbc that seems to be bitchin.
It's not a train smash, I exported it to my older rh7.0 server over the
net, but I'd still like to know for futu
You can try this;
mysql>source /path/source.sql
or:
$>mysql -uuser -ppassword DBname < filename.sql
HTH
JFernando
** sql ***
-Original Message-
From: Andre Kirchner [mailto:sieg1974@;yahoo.com]
Sent: October 22, 2002 15:58
To: [EMAIL PROTECTED]
Subject: How to execute sql commands fro
Andre Kirchner wrote:
> Hi there,
>
> is there a way to execute sql commands from a file?
> What would be the syntax to do it?
> I was trying mysql> @theFile, but it doesn't work.
>
> Thanks,
>
> Andre
>
> __
> Do you Yahoo!?
> Y! Web Hosting - Let t
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > Also, I am intersted in a way to reset the entire replication th
I have 760 GB free, not 375.
bash-2.04$ df -h .
FilesystemSize Used Avail Use% Mounted on
/export/data/dp20.a 1.0T 302G 760G 29% /data/dp20.a
bash-2.04$
The .MYD file is 134 GBytes
bash-2.04$ ls -lh targetTsObj*
-rw-rw1 mysqlmysql134G Oct 20 05:37 targetTsObj
> is there a way to execute sql commands from a file?
> What would be the syntax to do it?
> I was trying mysql> @theFile, but it doesn't work.
mysql < thefile
-
Before posting, please check:
http://www.mysql.com/manual.php
On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote:
> Hi Walt
> Thanks for the quick reply.
>
> Answer to both questions is yes.
> As a matter of interest,
> What I usually do is to create a "myodbc" db with a "myodbc" user and
> password "myodbc"
> I create this db and user with the mysql_se
Uhm, huh?
What use are these other products to him if his calendar is part of a bigger
application? What's he gonna do, plonk his webcalendar.sourceforge.net
instance into the middle of his current application? How exactly is he
reinventing the wheel? You comments clearly indicates that these other
Hi,
In fact, I think you run out of disk space.
You MYD takes 135 GB.
You have 375 GB free
When MySQL try to add the index on your database, it copies the MYD and frm
under a #sql* name.
So again 135 GB are eaten again.
So it remains 240 GB to build the index file, so it's possible you run out
of
Hi there,
is there a way to execute sql commands from a file?
What would be the syntax to do it?
I was trying mysql> @theFile, but it doesn't work.
Thanks,
Andre
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhostin
Thats exactly what I did. Still the same error Show master status shows
it running with a positive number. Slave is running. Netstat -na shows them
connected. I read that one page for two hours last night... over and over
and over :)
Thanks.
Lewis
- Original Message -
From: "Jeff Kil
Hi Walt
Thanks for the quick reply.
Answer to both questions is yes.
As a matter of interest,
What I usually do is to create a "myodbc" db with a "myodbc" user and
password "myodbc"
I create this db and user with the mysql_setpermission util, and I use
"%" for the host name.
YET, when I try to co
I have tried a few different variables to allow a "create index" command
to finish successfully.
1. I set tmpdir to be a file system with ample space
2. I increased tmp_table_size
3. I increases myisam_sort_buffer_size to 100M
Here are the sizes of the database files:
bash-2.04$ ls -l target
RESET MASTER
RESET SLAVE
This is a handy page to bookmark, if you're doing replication:
http://www.mysql.com/doc/en/Replication_SQL.html
--jeff
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, Octo
Petre Agenbag wrote:
> query , sql
>
> Hi
> Any known issues with RH8.0 and ODBC?
> I keep getting lost connection messages when trying to connect from a
> windows box to mysql, it worked 100% on a 7.3RH box.
> There is no firewall.
> Any workarounds?
>
> --
Lewis Watson wrote:
> Also, I am intersted in a way to reset the entire replication thing. In
> other words, just remove all hints of replication and start over... Is there
> a way I can do this?
> Thanks.
> Lewis
>
> - Original Message -
> From: "Lewis Watson" <[EMAIL PROTECTED]>
> To: "m
I thought some of you might be interested in this. There's a movie
that's out called 'Revolution OS.' It's about the emergence of the
Linux and free software movement. It's running on the Sundance
channel this Thursday and Friday and next Wednesday.
Let's hope they mention MySQL in the movie!
Alex Jarvis wrote:
> I'm installing mysql on RedHat 7.1 linux. I downloaded the
> relevant rpms (version 3.23.36-1) and installed them. But I think there
> was already a source rpm installed (mysql was ready to be installed from a
> source distribution but hadn't been). When I try to ru
Also, I am intersted in a way to reset the entire replication thing. In
other words, just remove all hints of replication and start over... Is there
a way I can do this?
Thanks.
Lewis
- Original Message -
From: "Lewis Watson" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesd
query , sql
Hi
Any known issues with RH8.0 and ODBC?
I keep getting lost connection messages when trying to connect from a
windows box to mysql, it worked 100% on a 7.3RH box.
There is no firewall.
Any workarounds?
-
Before p
You have a bigger problem than that.
All your 409s changed to 509s.
Lonny Byrd wrote:
Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert i
Description:
Mysql arbitrarily rounds large floats
How-To-Repeat:
create table temp (
id int unsigned not null auto_increment primary key,
amount float(8,2)
);
insert into temp(amount) values(244409.29);
insert into temp(amount) values(09.
At 19:22 +0200 10/22/02, Ciprian I. Acatrinei wrote:
Hi,
mysql> INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1
FROM f_baldai_seq LIMIT 1;
ERROR 1066: Not unique table/alias: 'f_baldai_seq'
Please help.
It's like it says in the manual: you cannot insert into the same
table that y
Hi,
I think that when you use a table for one operation pe select or insert,
the table is locked and you cannot execute another operation.
In your statement if you use different tables for the two operations, I
don't think you'll have a problem...
Ciprian I. Acatrinei wrote:
Hi,
mysql> INSERT
Hi,
mysql> INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 FROM f_baldai_seq
LIMIT 1;
ERROR 1066: Not unique table/alias: 'f_baldai_seq'
Please help.
Thank's.
-
Before posting, please check:
http://www.mysql.
>From: Todd Cary <[EMAIL PROTECTED]>
>
>I would like to get some suggestions for the structure of a sql "Calendar" database.
>My task is to create a "Calendar" of events in the San Francisco Bay Area. For
>instance, an event may be M-F 11:00 am, 3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
Un
I had replication running fine between two mysql server machines on linux.
Then I added yet another slave but goofed and put in the same server-id. Now
I am getting errors on the master server and proccesses being killed and
restarted. It comes with this error.
./bin/safe_mysqld: line 273: 12250 S
hi,
i'm in process of migrating from a commercial dbms to mysql and
have legacy tables referenced everywhere with names like 'tbl1#c'
--> '#' is not accepted for table names and must be escaped to create
one (but dissapeared from the table name then)
is there a way to use such table names ?
thank
I'm installing mysql on RedHat 7.1 linux. I downloaded the
relevant rpms (version 3.23.36-1) and installed them. But I think there
was already a source rpm installed (mysql was ready to be installed from a
source distribution but hadn't been). When I try to run mysql_install_db
I get the
The command is th same on just about all systems:
mysql -u username -p
You would then be prompted for the password. These are mysql username
and passwords, not os level users. Typically the user would be root,
meaning the mysql root user, not OSX root user.
MySQL has to be running too.
safe_mys
- Original Message -
From: "Basil Hussain" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 6:32 PM
Subject: RE: Table gets wiped out!
> Hi,
>
> > $sth = $dbh -> prepare ("LOCK TABLES $table WRITE");
> > die $dbh->errstr if (n
Hi,
> $sth = $dbh -> prepare ("LOCK TABLES $table WRITE");
> die $dbh->errstr if (not defined ($sth -> execute));
>
> $sth = $dbh -> prepare ("DELETE FROM $table");
> die $dbh->errstr if (not defined ($sth -> execute));
>
> This truncated the table. Then I filled the table anew, an
Dear ALL
i did install mysql by rpms all 6 rpms
php-mysql
perl-DBD
mytsql server
mysql client
mysql devel
mysql
but after installing all these rpms when i want to set password for
root or any user then face folllowinmg problem
[root@lhr RPMS]# mysql_setpermission
Password for user to
Dear ALL
i did install mysql by rpms all 6 rpms
php-mysql
perl-DBD
mytsql server
mysql client
mysql devel
mysql
but after installing all these rpms when i want to set password for
root or any user then face folllowinmg problem
[root@lhr RPMS]# mysql_setpermission
Password for user to
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Greetings MySQL Colleagues:
Last week during Lasso Summit 2002, Blue World announced the
immediate availability of the MySQL list archives on ListSearch.com.
ListSearch.com provides a wealth of features--including automatic
message threading and statistical reporting based on number of posts
b
Before you do that. Try:
mysql -u root -p mysql
And put in your root password (when prompted) for the machine. The
Connectiva installation may have initialized the mysql database with the
machine's root password. If so follow the docs to change that, as it is
not a good security measure to ha
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 3:58 PM
Subject: Re: decode statement: Viruses on your site please
> NZEYIMANA Emery Fabrice w
At 10:25 -0400 10/22/02, Ciprian I. Acatrinei wrote:
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow multiple values in that
field. How do I take out the unique property of that field...
- Drop the unique index
- Add a non
Todd Cary wrote:
I would like to get some suggestions for the structure of a sql
"Calendar" database. My task is to create a "Calendar" of events in
the San Francisco Bay Area. For instance, an event may be M-F 11:00
am, 3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
If you're doing events,
Fields don't have a unique property.
You must have a unique index generated for that field.
Drop the index and create one that is not unique.
Ciprian I. Acatrinei wrote:
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow mult
Daya,
Tuesday, October 22, 2002, 3:26:42 PM, you wrote:
DKD> I want to update a field like this
DKD> 1) update table abc set col=col+'some const'
DKD> 2) update table abc set col=col+col2
DKD> Is is it possible in mysql if yes then how.
If col and col2 are string fields, use CONCAT() function:
Kolari,
Sunday, October 20, 2002, 9:26:45 PM, you wrote:
KSB> I am totally new to MySQL. I have read the documentation and an OReilly
KSB> book on MySQL; all discuss installation and configuration from source
KSB> and binary but not RPM. I have installed MySQL 4.0.4 RPM package in a
KSB> PC r
Christos,
Monday, October 21, 2002, 5:46:07 AM, you wrote:
CS> Hello I am a brand new user of MySql, and have some questions about
CS> using InnoDB tables.
CS> I noticed in the manual that you can only specify
CS> - ON DELETE SET NULL
CS> Or
CS> - ON DELETE CASCADE
CS> What is the default b
Ciprian,
Tuesday, October 22, 2002, 5:25:40 PM, you wrote:
CIA> I am having a hard time removing the unique property from a field...
CIA> I set up a field as unique now I need to allow multiple values in that
CIA> field. How do I take out the unique property of that field...
CIA> PS: I couldn't
Check the section of the manual covering the privilege system,
especially the "GRANT" command.
Julia Maddocks wrote:
I would like to connect to MySQL database on a remote server using
either the command prompt or MySQLFront.
I have the IP address, username, password but I can't connect.
MySQLf
Make sure it is not part of a primary key.
Use a front-end like
MyCC(http://www.mysql.com/downloads/gui-mycc.html)
or SQLyog(http://www.webyog.com/sqlyog/download.html)
(query, mysql)
Scott Pippin
>>> "Ciprian I. Acatrinei" <[EMAIL PROTECTED]> 10/22/02 08:25AM >>>
Hi,
I am having a hard time rem
Search the MySQL list, http://lists.mysql.com/php/search.php for "ram
needed", there are some pretty good references there as to what the
footprint of MySQL is.
>>> Simon Green <[EMAIL PROTECTED]> 10/22/02 02:59AM >>>
Hi
I am putting together a MySQL server for the ISP I work for. We are
going to
Linux Connectiva is one Brazilian version of Linux and when I installed
Connectiva in the full installation, the MySQL was installed too.
Maybe, I will need to install again.
Yesterday I tried, but I think I need to unistalling the MySQL. How I do it?
- Original Message -
From: gerald_cl
dear everybody,
I have set up three machines with mysql server version 3.23.49 and created
the same database on each of them. They only differ by the data they
contain. What can I do that these three machines log their data to one
central database? The database should have the same database cons
I would like to connect to MySQL database on a remote server using
either the command prompt or MySQLFront.
I have the IP address, username, password but I can't connect.
MySQLfront just hangs when I enter all the information
If I type the following at the command prompt, in this example I'm us
Hi,
I am having a hard time removing the unique property from a field...
I set up a field as unique now I need to allow multiple values in that
field. How do I take out the unique property of that field...
PS: I couldn't figure it out from
http://www.mysql.com/doc/en/ALTER_TABLE.html
Thank you,
I am totally new to MySQL. I have read the documentation and an OReilly
book on MySQL; all discuss installation and configuration from source
and binary but not RPM. I have installed MySQL 4.0.4 RPM package in a
PC running RedHat 7.3. I could start the MySQL server as root user. I
also co
Jocelyn asked whether the file system supports files over 2 GB, and
whether there was space left on disk.
The file system /export/data/dp20.a supports files larger than 2 GB.
For example, the targetTsObj files are larger:
bash-2.04$ ls -lh targetTsObj*
-rw-rw1 mysqlmysql134G
I would like to get some suggestions for the structure of a sql
"Calendar" database. My task is to create a "Calendar" of events in the
San Francisco Bay Area. For instance, an event may be M-F 11:00 am,
3:30 pm, 7:30 pm and Sat 4:30 pm and 6:30 pm.
Of course, there is a beginning date and en
What is Linux Connectiva 7.0,
what is the default installation of MySQL,
and where did you get it?
Silmara wrote:
I have an installation of Linux Connectiva 7.0 with the default installation
of MySQL. I stated MySQL but I can't connect to DataBase.
mysql -u root mysql
Access denied to 'root@loc
Hi,
No.On the server machine.The "hosts" is the way for resolving hostnames.In
other Unix system, like SCO, to put the IP address and the alias in hosts is
indispensable.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
NZEYIMANA Emery Fabrice wrote:
I was surprised to see that you put viruses on your website for people to
download telling them that they are games.
FWIW, Tetris.com came up clean on my machine using the latest McAfee
with 6 day old virus definitions.
SQL.
--
Michael T. Babcock
C.T.O., Fibre
Christian Reichenbach wrote:
You've a very radical position.
Not really; I don't find it at all radical to think in terms of
'reasonability'. The poster in question believes that adding a feature
to make square brackets work like quotation marks would make the code
base harder to maintain a
John Chang wrote:
In MYSQL I'm using MYISAM. Should the 2 fields in each of the Stars &
TitleGenres
table be Primary keys since they are 'tied' to other fields?
Yes, it works best if they are a primary key together (especially since
the pairs are in fact unique); make sure you put the one mos
1 - 100 of 124 matches
Mail list logo
