Hi there!
Does anybody know whether it is possible for MySQL to handle round about 500-600
tables in one database or not (Win2k)? Where is the maximum?
I want to work with dynamically created tables.
Thanks,
Peter
Keine verlorene
Hi All,
Does anyone have the syntax for multi-table updates?
The Online Mysql manual (for version 4.0.5) only has:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]
Where as the other multi-tabl
Is someone succeed in compiling mySQL 3.23.x and 4.0.x on Solaris 8 (and how
to do it - especialy with SunOne C compiler - ak Forte C v7).
Sinceraly.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
On Mon, 2002-10-14 at 03:55, Chip Rose wrote:
> Are there ANY MySQL terminal-based frontends (for Linux) that will allow
> inputting data via forms, queries,reports? There are a lot of
> administration tools - that's not what I want. How do I set something
> up for inputting and simple queries t
Shilline,
- Original Message -
From: "Shilline Lee" <[EMAIL PROTECTED]>
To: ""Heikki Tuuri"" <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 4:08 AM
Subject: Re: ROW LEVEL Locking not affected
>
>
>And then ? please tell me the detail :)
> if I "SET AUTOCOMMIT = 0" in the session
Hi,
I'm running Debian GNU/Linux and have MySQL 3.23.52 installed.
How do I "copy" and existing database from my development server
to my production server so that all works when I restart the MySQL start
scripts?
I want to achive some kind of controlled release routines.
Please reply to:
[EM
Hi,
see the "2.5.4 Upgrading to another architecture" part of the mysql
reference manual or "4.8.5 mysqldump, Dumping Table Structure and Data".
Regards,
HB
-
Before posting, please check:
http://www.mysql.com/manual.php
Thank you very much Heikki.
Your suggestions are useful. I also noticed
that the use on symlinks are somehow deprecated
with the last releases of Mysql.
Concerning the problem :
I lately discovered that the Air Conditioning of
the servers room was OFF, thus there where some
40° (we could have gr
On Fri, 2002-10-11 at 16:08, Chris Stoughton wrote:
> I sent a similar question a few days ago. I don't think there was a
> response. If there was, sorry that I missed it. I have worked around
> the issue, but would like to know whether there is something I can do to
> improve the orignal qu
Hi all,
I have just added a field (order) to a table with
about 12,000 records.
Now I cannot select or insert unless I quote the field
names in the query
i.e. This returns - you have an error near 'order ...'
SELECT
id,pub_date,last_update,type,region,author,title,summary,content,keywords,fil
hi!
I'm managing a mysql database and I'm having some problems with a fields
containing japanese characters.
Preamble:
The original database was made under M$Access, so I used the export2sql
module for Access to get some mysql scripts and, by these, create my MySQL
DB. Client and server are b
Hello list,
I am using mysql 3.23.52. I have to query one of my tables which has two
columns with the type of "date" and "time". For example i have to get
the records whose date are 2002-10-12 and time is bigger than 11:30:00
and also the records whose date are 2002-10-13 and time is smaller
>Description:
The documentation for NULLIF states that expr1 is evaluated twice if the
expressions are equal.
Actually, it is the opposite. Expr1 is evaluated twice when the two exporessions
are NOT equal.
>How-To-Repeat:
mysql> set @myval:=0;
Query OK, 0 rows affected (0.00 sec)
mysq
Sorry for the below questions: perhaps are obviously !
1) Which is the correct tool to administrate a remote mysql db in my
network ?
2) In my network I have:
server A = MASTER
server B,C as slaves running always
server D running sometimes used to develop.
Every night server A stop se
HELLO,
we 're using mysql 3.23.49 on a dedicated server (dual processor 933Mhz)
with 1,5Gb of RAM and another web server access to the database for dynamic
web pages.
Our problem is "too many connections" message, i thing that the mysql daemon
is overload because we have up to 4 pages visited
I can do a bit.
set-variable= max_user_connections = 100
set-variable= max_connections = 500
So if you change max_connections to = 1000.
Then set max_user_ connections to the max you what any one IP/host/user to
have this will help.
The number of simultaneous connections will also
Huan,
Monday, October 14, 2002, 8:03:36 AM, you wrote:
HH> What is the sql command which is the same as command
HH> "show tables" ?
There is no command to see all tables in all databases. You can see
list of tables only for a single database at time.
HH> Other database stores all tables in a sy
Matt,
Monday, October 14, 2002, 7:14:24 AM, you wrote:
MH> I believe you'll be waiting until version 4.1.0 for full Stored procedures
MH> support.
Stored procedures will not come in 4.1, they are scheduled around
version 5.0
MH> At that point I'm not sure what we'll be waiting for. There are a
manuvi,
Monday, October 14, 2002, 8:04:28 AM, you wrote:
maedn> I am not able to connect to my database using the IP no of my machine using
maedn> the following PHP script. I have recived the error exlained below when I tried
maedn> to connect the database. But When I changed the host name as "
Fraser,
Monday, October 14, 2002, 10:50:35 AM, you wrote:
FS> Does anyone have the syntax for multi-table updates?
FS> The Online Mysql manual (for version 4.0.5) only has:
FS> UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
FS> SET col_name1=expr1 [, col_name2=expr2, ...]
FS> [WHERE where_defin
emil,
Monday, October 14, 2002, 12:00:39 PM, you wrote:
edhasdadc> I'm running Debian GNU/Linux and have MySQL 3.23.52 installed.
edhasdadc> How do I "copy" and existing database from my development server
edhasdadc> to my production server so that all works when I restart the MySQL start
edhasd
Tonino,
Monday, October 14, 2002, 9:17:43 AM, you wrote:
T> I have an interesting question : I have a program that does dumps
T> information to a flat file ( a lot of information) and a another that
T> runs as as daemon and inserts the data from the flat file into a mysql
T> server. a line from
olinux,
Monday, October 14, 2002, 12:42:21 PM, you wrote:
o> I have just added a field (order) to a table with
o> about 12,000 records.
o> Now I cannot select or insert unless I quote the field
o> names in the query
o> i.e. This returns - you have an error near 'order ...'
o> SELECT
o>
id,pu
Peter,
Monday, October 14, 2002, 10:38:06 AM, you wrote:
PS> Does anybody know whether it is possible for MySQL to handle round about 500-600
tables in one database or not (Win2k)? Where is the maximum?
PS> I want to work with dynamically created tables.
Number of tables in the database is lim
Hello Me-Selfe,
Saturday, October 12, 2002, 2:25:23 AM, you wrote:
MS> After a reboot, the database server running Redhat 7.2 and mySQL
MS> 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the
MS> server, nothing happens and when i check in the log file for mysql, i
MS> get s
Hello John,
Monday, October 14, 2002, 3:36:20 AM, you wrote:
JH> I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
JH> Number of processes running now: 1
JH> mysqld process hanging, pid 8617 - killed
JH> 021013 20:08:43 mysqld restarted
JH> /usr/libexec/mysqld: ready for connections
[]
Download t
Russ,
Sunday, October 13, 2002, 8:33:55 PM, you wrote:
RCS> When I try to add a string to the end of an enum list I get the following
RCS> error message:
RCS> You have an error in your SQL syntax near '\','Historical
RCS> Knowledge','Chronological Thinking, Comprehension, Analysis and I' at line
Hi All !
Recently we have begun developing a web-based configuration sheet generator. The basis
for these configuration sheets is data stored
on several Sun servers. The Sun servers are responsible for collecting
all config data from all equipment connected to the network.
We have developed scr
Veysel,
Monday, October 14, 2002, 12:48:58 PM, you wrote:
VHS> I am using mysql 3.23.52. I have to query one of my tables which has two
VHS> columns with the type of "date" and "time". For example i have to get
VHS> the records whose date are 2002-10-12 and time is bigger than 11:30:00
VHS> a
1) Is there a de facto type that is used? All I will be doing is creating
a database for use on the web for dynamic webpages. Basically doing
searches to the back-end MySQL database. I figure I don't need to use
transactional type since I will not be adding any information via a
front-end.
Hello Mike,
Saturday, October 12, 2002, 5:41:11 AM, you wrote:
MZ> Recently our DB, which is running MySQL 3.23.52, started experiencing
MZ> intermittant load spikes, of the magnitude of 200+ load averages. Normally,
MZ> our high spike is about 0.90 load. When this starts happening, we notice a
Thank you Egor. These queries meet my needs.
Egor Egorov wrote:
>Veysel,
>Monday, October 14, 2002, 12:48:58 PM, you wrote:
>
>VHS> I am using mysql 3.23.52. I have to query one of my tables which has two
>VHS> columns with the type of "date" and "time". For example i have to get
>VHS> the re
And I hope triggers as a collegue and I have to submit a evaluation
report on why our department should consider Mysql to be used in
conjuction with Postgrsql
which is our default RDBMS in our organisation.
So I have a few link's regarding performaces etc as well as the Mysql V
PostGresql
Any
Hi, I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace the
privileges?
There are two tables ('db' and 'tables_priv') in mysql database.
I gave privileges, for example, to the table 'tables_priv', I give o
Greetings...
I belive MySQL is powerful enuf for the mentioned type of data. I have a
database in win2k with 100 tables and the size of the database is 8 GB. It
performs fantastic, faster the MS SQL Server which I had before.
I have MyISAM tables.
Rgds
Insane
SQLyog - The Definative Win32 GUI F
Hello.
WARNING!!!
Somebody is sending viruses to subscribers of this mailing list using
my name.
So, please remind: not me, nor Vita - we are not going to send any
code examples, any archives, any executables or even ANY attaches.
Also we do not send private mails to list subscribers.
So plea
I've read a bunch about normalization in MySQL and still can't do it very
well. What I want to normalize is videos (Title, Studios, Actors, Genre,
&bitrate).
These are the tables and fields I think it needs. Is this
normalized? Thank you.
Table (Fields)
Title (VideoTitle, details, id)
Studio
>Description:
Upgrade from MySQL-3.23.52 to MySQL-3.23.53
021014 15:49:54 mysqld started
Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
021014 15:49:54 Aborting
021014 15:49:54 /usr/sbin/mysqld: Lõpp
021014 15:49:54 mysqld ended
>How-To-Repeat:
Hi all
I am new to MySql and I am thinking about using it for managing a
database, which would have a approximated length of 500 Mb. It is formed
of vectors.
Trouble is that I am worried about the ability of MySql to handle that
amount of data.
Do you know about any article or study about MySql
Hey,
On the same computer than before?
Fred
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Peter Stöcker" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 2:08 AM
Subject: Re: Number of tables
> Greetings...
>
> I belive MySQL
On Mon, 14 Oct 2002, Alberto Ruiz Cristina wrote:
> Hi all
>
> I am new to MySql and I am thinking about using it for managing a
> database, which would have a approximated length of 500 Mb. It is formed
> of vectors.
>
> Trouble is that I am worried about the ability of MySql to handle that
> am
It's always a bad idea to name your columns using keywords.
- Original Message -
From: "olinux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 5:42 AM
Subject: Why must I quote fields now?
> Hi all,
>
> I have just added a field (order) to a table with
> abou
Do you have a user defined as?
Login Name: mysql
Full Name: MySQL Server
group: mysql
Home directory: /var/lib/mysql
Your 'Fatal Error' line indicates that user mysql does not exist?
[EMAIL PROTECTED] wrote:
>
> >Description:
>
> Upgrade from MySQL-3.23.52 to MySQL-3.23.53
>
> 021014 15:49:5
Hi there !
A sample create table SQL query is as follows :
"create table eml.adjacency select * from emlbase.adjacency where
eml.adjacency.importdate = '2002-10-10';"
The database names (e.g. "eml") ,tablenames (e.g. "adjacency") and date are changed by
a perl script for the different tables
Hi!
I want to run 2 versions of MySQL on the same Linux machine. I already
have 3.23.41 installed and I want to install 4.0.3 to test it. I tried to
install MySQL 4.0.4 but cannot install because of failed dependencies.
Thanks for any help,
Macarie Neculai.
It sounds like a mis-configured Apache is never closing connections.
Troy Hakala wrote:
> Ok, I've been having this problem every so often and it's happening
> more and more these days and I still can't figure out a solution. I
> know this sounds vague, but maybe you can help me make it less
The MyISAM table type should be fine for what you are doing, and is faster
than the InnoDB type. Basically, you only need transactions in situations
where a) money is involved or b) you will be updating multiple tables and
all updates must be guaranteed successful, or none.
hth,
Arthur
- Ori
Since it can't use an index, and has to sort the output, what
exactly is unexpected?
Norris, Joseph wrote:
>Group,
>
>I have the following query:
>
>select phones.*, ops.plid, ops.box, ops.mac
>from phones, ops where
>(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
>(phones.suffix1 = ops.phone
At Montag, 14. Oktober 2002 14:57 Alberto Ruiz Cristina wrote:
> Hi all
>
> I am new to MySql and I am thinking about using it for managing a
> database, which would have a approximated length of 500 Mb. It is formed
> of vectors.
Greetingz,
from my experiences with several Databases since the 1
You're starting off ok, just missing the links between the tables. I would
suggest for simplicity though that you change the names of your PKs to
reflect their table, i.e. Title (VideoTitle, Details, TitleID). Otherwise
once you do multi-table queries joins you will have to specify the table
names
Reformat your import file.
or
Add two columns , import, and drop the two columns.
or
Import to a six column temporary file and do an
insert into select from.
tl wrote:
>Hello,
>
>#If I have a file "t.txt"
>
>
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
><<
>
Hi there,
Does any of you know of a utility to pretty print mysql table
structures? I have a pretty big and messy DB I need to work on, and I
would like to be able to print the table structures with nice tables.
Any pointers?
--
What is in the error logs?
Vernon Webb wrote:
>I have been using MySQL for nearly a year now with no problems, until now. I
>rebooted my box this morning and since rebooting I have had nothing but
>trouble.
>
>First off I have noticed (I never looked before because I had no need to,
>but the
Hi John,
your design is normalized, but incomplete
and unconnected.
Where do you put the information which actor
was playing in what title, which title was
done in what studio etc. ?
Normalization is a representation technique to
avoid storing *redundant* information. But first
this informati
Agreed. My first "project" to learn PHP and MySQL was to create a
message board. That wheel has been invented who knows how many times.
But after I finished it, I looked at other solutions to see what
directions they took and how I could improve my solution. And especially
where I went wrong.
I'm having the same problems. I'm on a RedHat machine... 7.2 running
MySQL ver. 3.23.41. I've been told to upgrade my package.
I think RedHat has put out an update to some other library, module or
such, that is in conflict with remote/client management applications???
Everything is working fine
I forgot to add
Video (This has all the Primary key id from the tables below) Now does it
work?
My question is how do I get the Primary keys into the video table? Do I
just put them in and the database will know it should look in the other
tables? How do I connect it? I read some books bu
On Mon, 2002-10-14 at 16:51, John Hinton wrote:
> I'm having the same problems. I'm on a RedHat machine... 7.2 running
> MySQL ver. 3.23.41. I've been told to upgrade my package.
>
Me too. After reading your posting I realized that glibc probably was
the root of the problems (my problems starte
If you create the tables beforehand in MySQL and then export the data into the already
created table, that should allow you finer control of your data types. To save time
you could export the table from Access, then truncate it to clear out the data, and
then change the data types as necessary
On Mon, 2002-10-14 at 17:29, Anders Nielsen wrote:
> On Mon, 2002-10-14 at 16:51, John Hinton wrote:
> > I'm having the same problems. I'm on a RedHat machine... 7.2 running
> > MySQL ver. 3.23.41. I've been told to upgrade my package.
> >
>
> Me too. After reading your posting I realized that
At 02:56 PM 10/14/2002 +0300, you wrote:
>Hello Mike,
>
>Saturday, October 12, 2002, 5:41:11 AM, you wrote:
>
>MZ> Recently our DB, which is running MySQL 3.23.52, started experiencing
>MZ> intermittant load spikes, of the magnitude of 200+ load averages.
>Normally,
>MZ> our high spike is about 0
hi
i use windows2000/xp and Dev-cpp(a C++ compiler) , and want to connect with
mysql, but now , i not know STL much.
how can i do , who can show me a source code? thanks.
i already download STLport ,but i not know how to use it ! :(
-
Hi everybody,
I'm trying to use the Full Text index functionality with MySQL 3.23
and I have a problem I can't understand.
I have a table built this way :
CREATE TABLE MyTable (
Id bigint unsigned NOT NULL,
Num varchar(20) NOT NULL,
Title varchar(150) default NULL,
Aut1 varchar(100) d
It sounds like the glibc auto-rpm that Redhat produced (to plug a
security hole, I believe) is the root cause. Getting mysql 3.23.52 from
mysql will be the solution.
I don't know who could get Redhat to coordinate their updates.
John Hinton wrote:
>I'm having the same problems. I'm on a Red
Hi,
I would like to know when I use the table "Host".
Why does she exists?
query, sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I make always confuse, what is the diference between the command CHECK and
ANALYZE.
Regards
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
I recently upgraded from MySQL 3.23.51 to 3.23.52 on RedHat Linux 7.1
(kernel 2.4.18-ac3). With the same traffic that produced about a 1.0 load
on my servers consistantly, the load jumped into the hundreds with the new
version of MySQL. After downgrading, the load returned to normal. I am
doing
Intelligent Converters has a product that's pretty inexpensive, about $35 I
believe. It pretty much works as advertised, it was much cheaper than
spending any time trying to roll my own script.
We recently got an Excel spreadsheet that we needed to import, and after a
few minutes of playing arou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 3.23.53, the world's most popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
This is a bugfi
On Mon, 14 Oct 2002, Alexander Burbello wrote:
> I make always confuse, what is the diference between the command CHECK and
> ANALYZE.
Hi,
ANALYZE TABLE checks through and updates the key distribution information of
a table (affects join order).
CHECK TABLE check the table for errors. It also
Hello all...
I´m compiling the mysql 3.23.53 in DUAL PROCESSOR MACHINE...
in mysql exists an option to "optimize" on DUAL PROCESSOR MACHINE ?
my system is mysql 3.23.53 in linux 2.4.18 ( with 1G RAM )
sql,query
-
++
Hi friends,
has anybody had similiar experiences?
Environment:
Systems are x86 SuSE 8.0/7.3 Linux, MySQL-max
version 4.0.4 is used on all machines
(installed from the mysql.org-RPMs).
The setup is a circular replication
with 3 machines. Linux distro- or kernel-
version don't seem to play a
Hi!
InnoDB is a table type which adds transactions, row level locking, a
non-free hot backup tool, and foreign key constraints to MySQL.
InnoDB is included in -Max downloads of the stable MySQL-3.23 branch and in
all downloads of the beta MySQL-4.0.
3.23.53 is a bugfix release. Windows 95/98/ME
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128
is a link to this bug. In fact the glibc update is conflicting with
client connections to mysql. The bug was first reported around 10-4-02
and has been given a priority code of 'High'.
Redhat Response.
The problem is actually that M
Lenz Grimmer wrote:
> - We've hopefully fixed the problem with spurious load spikes on Linux
>systems when accessing the Database via TCP/IP. This was caused by the
>static glibc files we used to link against and should now be resolved.
Apparently this glibc/mysql situation is being w
MySQL is multithreaded, so your OS will send separate threads to different
processors. So, yes, MySQL will automatically take advantage of multiple
processors, no need to tell it explicitly.
j- k-
On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote:
> Hello all...
>
> I´m comp
Hello
In my case Default data files directory is
/var/lib/mysql. I want to store all files of one
database in another directory.
Is there a way we can specify data directory per
database. Or else can we change the entire data
directoy of mysql.
I tried to change it using my.cnf but I guess i mis
>Description:
A user who would not otherwise have permission to create a database can
create a database which contains a "?" character, when the wildcard matches
an existing database that the user has permission to access.
Example: if test_db exists, any user with permission to access test_db
You can relocate an entire database with a symbolic link:
ln -s /path/to/database/files /var/lib/mysql/database_name
--jeff
- Original Message -
From: "Niranjan Patel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 10:50 AM
Subject: Default data dir
> Hello
On 14 Oct 2002, at 11:00, Brian Scott wrote:
> Example: if test_db exists, any user with permission to access test_db
> seems to be permitted to create "test?db" regardless of permissions.
It's not the question mark that's causing the problem -- it's the
underscore. And it's not a bug:
# P
Greetings...
MySQL can handle datas hundreds times greater then that very efficiently so
dont you worry about handling 500 MB.
My database has 8GB of data and it performs best.
So dont worry.
Rgds
Insane
- Original Message -
From: "Alberto Ruiz Cristina" <[EMAIL PROTECTED]>
To: "mysql
Greetings...
Host tables are used to give privileges of a very esoteric type to user who
are connecting from differnt host with differnt permissions.
I think the MySQL documents, privilege section has a detailed working of
host table. It is the best I have seen till now.
Rgds
Insane
- Orig
Greetings..
Is iut necessary that you usee STL. Other wise MySQL C API are much more
easy to maintain and program. Even SQLyog which I am a beta tester is
written using MySQL C API and its very fast.
Rgds
Insane
- Original Message -
From: "wang tianyi" <[EMAIL PROTECTED]>
To: <[EMAIL PR
I get that point but is there any other way we can
change the path .
Thanks
Niranjan
--- Jeff Kilbride <[EMAIL PROTECTED]> wrote:
> You can relocate an entire database with a symbolic
> link:
>
> ln -s /path/to/database/files
> /var/lib/mysql/database_name
>
> --jeff
>
> - Original Message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
(I've just noticed, that I've used my private email-address for this
announcement - sorry about that!)
On Monday 14 October 2002 19:09, John Hinton wrote:
> > - We've hopefully fixed the problem with spurious load spikes on Linux
> >system
Not on a per database basis, that I know of.
Anybody else?
--jeff
- Original Message -
From: "Niranjan Patel" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 11:19 AM
Subject: Re: Default data dir
> I get that point but
Please Help
Can't compile on Sparc Solaris 9
Following the manual suggestions I build
gcc-3.2 on the same box as well as gnu-binutils-2.13, but I'm not
being successful on mysql-3.23.52.
Could be the gcc? it was configure --with-as=/usr/ccs/bin/as --with-
ld=/usr/ccs/bin/ld and not using gnu-b
I would like to know what the exactly diference the ACID nomenclature.
I read the mysql documentation, but it´s a little difficult to understand
between C and D.
Does anybody can explain. Tks.
Greetings
Alexander
sql, query
__
On Mon, 14 Oct 2002, Niranjan Patel wrote:
> I get that point but is there any other way we can
> change the path .
Hi,
You can reposition your entire data directory by using the
--datadir=/path/to/new/data/dir command line parameter to mysqld. This
repositions all databases, and you have to co
Is there a way to copy a table from one mySQL machine to another without
implementing replication? The goal is be able to grab a copy of a table
from some other machine (without regard to master/slave relationships) in
some programmatic way without having to do a dump, copy file and rebuild.
S
Anyone know of/have recommendations on a perl script to do
replication (binary) log rotation? I have a master with
multiple slaves. I need to be able to rotate the binary log
of the master and get rid of any old files that the slaves
aren't reading.
I'm looking for a script that will talk to
the
On Mon, 14 Oct 2002, Dennis wrote:
> Is there a way to copy a table from one mySQL machine to another without
> implementing replication? The goal is be able to grab a copy of a table
> from some other machine (without regard to master/slave relationships) in
> some programmatic way without havin
Ed thanks for your replay
But the libraries are there on the path
PATH="/usr/local/lib:/usr/lib:/usr/local/:/usr/local/bin:/usr/bin:/u
sr/ccs/bin/:/usr/ucb:/etc:."
bash-2.05$ ls /usr/local/lib/libstdc++.so.5
/usr/local/lib/libstdc++.so.5
- Jose
>> g++ -O3 -DDBUG_OFF -fno-implicit-templates -
Exists plans to release 4.0x series a "stable" ?
When ?
And 4.1 series... exists plans to release a "alpha" ?
when ?
tnsk ;)
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
--
At 02:51 PM 10/14/2002, you wrote:
> > Is there a way to copy a table from one mySQL machine to another without
> > implementing replication? The goal is be able to grab a copy of a table
> > from some other machine (without regard to master/slave relationships) in
> > some programmatic way withou
Hello,
I'm a psuedo-newbie with mysql. I've had so much administrative success
with it in the past, I haven't had to seek counsel elsewhere.
I didn't see a list tailored to MySQL admins, so I suppose this place is
the best to post this question.
I have been running MySQL in 32-bit mode on Sola
For example, I have a string
"Administration,Advertising,Direction,Media,Research" and I want to see
whether a SECTOR field in a row is contained in the above string.
so that I can select rows which contain only "Advertising" in their SECTOR
field.. sort of like a reverse LIKE, whether a field i
>If you are looking for 'Advertising' in the column,
>why not just put this in your query
>
>where SECTOR = 'Advertising'
Yes, but instead of 'Advertising' I could have 'Advertising,Media,Whatever'
So I need to have a way of finding out whether SECTOR is contained in
'Advertising,Media,Whatever
i have this as part of /etc/my.cnf, all data file are in the directory
/my. be sure to set your permissions on /my to the mysql user
[mysqld]
datadir=/my
- hcir
On Monday, Oct 14, 2002, at 10:19 America/Anchorage, Niranjan Patel
wrote:
> I get that point but is there any other way we can
> c
On Monday, Oct 14, 2002, at 13:29 America/Phoenix, Tim Kerch wrote:
> For example, I have a string
> "Administration,Advertising,Direction,Media,Research" and I want to see
> whether a SECTOR field in a row is contained in the above string.
>
> so that I can select rows which contain only "Adver
1 - 100 of 123 matches
Mail list logo
