I'm trying to write a cron job to back up my databases. The manual says:
Do a full backup of your databases:
shell mysqldump --tab=/path/to/some/dir --opt --full
You can also simply copy all table files (`*.frm', `*.MYD' and`*.MYI'
files), as long as the server isn't updating anything.The
Dear all,
can anybody tell me how to install mysql replication
step by step :-).
thanks in advance.
Best regards,
Madrus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
once again *g*
$sql = insert into sitesats set areview='$areview', apositive='$apositive',
anegative='$anegative', arate='$arate' where id='$id';
Does it make sense to INSERT INTO . WHERE ... ? *GG*
Thomas
-
On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote:
Dear all,
can anybody tell me how to install mysql replication
step by step :-).
thanks in advance.
Best regards,
It is described step-by-step in the manual already. If you find it to
be lacking, please let us know and someone
? I see several issues in the change logs regarding left joins
but I do believe they were available for 3.22.32.
I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has
10 left joins).
Yes, it does work!
Actually it was the INNER JOIN that got me on the wrong track:
Hi,
I installed MySql on Linux slackware by downloading the file
mysql-3.23.38-pc-linux-gnu-i686.tar.gz in the directory /usr/local. I
followed the steps given in the Installing a MySQL Binary Distribution
chapter of the MySql manual. The propblem is if I issue the command mysqld
at the
Hi,
I installed MySql on Linux slackware pc by downloading the file
mysql-3.23.38-pc-linux-gnu-i686.tar.gz. I followed the instructions given in
the Installing a MySQL Binary Distribution chapter of MySql manual. I
added the following line to my rc.local file uner /etc/rc.d directory to
The default is that you are logged as your unix uid. If you want to log
into mysql, you need to specify that on the command line.
-Original Message-
From: M Srinivas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 1:54 AM
To: [EMAIL PROTECTED]
Subject: MySql User ID
Hi,
First... I want to start mysqld server... but the error was showen..
---Try starting the
mysqld -
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or
directory
Starting mysqld daemon with
Hello SixK,
Are you sure, that you are running in a join limitiation?
I think that just your max-open-tables is per default = 32.
Look at
/etc/my.cnf
set-variable= table_cache=64
Just change this variable to do what you want.
As every open table uses resources, an 'infinite' value
[EMAIL PROTECTED] writes:
Could anybody e-mail me a copy of libmysqlclient.so for Solaris 7 -or- let me
know where I can get one?
Many Thanks,
=Adrian=
Information in this message is confidential and may also be legally privileged.
It is intended solely for the person to whom
Weining Zhao writes:
Hello,
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000
workstation. When I started mysql server with safe_mysqld, I got following error
message:
Start MySQL server deamon
exec(): 0509-036 Cannot load program
Brett G. Lemoine writes:
Is mysqlgui capable of connecting to the mysqld daemon via a unix
socket, or must it use the network. Mysqlgui appears to ignore
the 'socket' option in the my.cnf file. Am I out of luck, or did
I possibly make a mistake in the compile?
thanks,
bl
--
//==
Hi! I'm runing win98 se and my mysql server have become gone nuts.. When I create a
computerbase it can dissapear a day later or something like that,,,sometimes I cant
eaven create a table..
I have tryed to reinstall it.. but it wount work! what do you suddgest
Hi
I and my friends we are going to write new JDBC driver for MySQL. =
Where can we get description of communication protocol between client =
and MySQL server?
Tomek=20
Hi!
Get hooked to our BK mysql-4.0 repository and you will find all docs
you need in Docs subdir.
If you have any
To solve SMP problems with Linux, you should use latest kernel 2.4.*
and our binary.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/
Olá
Tenho uma tabela que contem o nome do produto e a origem dele, sendo
IMP - importado
RJ \
SP |
AM | nacional
RS |
MG/
SP-CL \
RJ-CL | Empresas coligadas a nossa empresa
AM-CL /
O problema aqui é filtrar os nacionais junto com importado ou
nacionais com
coligadas
Tipo, como faço p/
On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote:
To solve SMP problems with Linux, you should use latest kernel 2.4.*
and our binary.
We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary
should run better ? Cause I tried it, and it dind't
Mark Vann writes:
I am currently trying to compile mysql on solaris 2.7
, running on an ultra1 with 512 megs of memory. I have
uninstalled the bin package off sunfreeware.com for
gcc and replaced it with 2.95.3 compiled on my box. I
also have the libstdc++ library with G++ installed as
Michael Kunze writes:
Hi all,
a bugfixed MySQL version 3.23.39 was announced on Freshmeat on June,
7th, but there is no announcement on the list and nothing on the site.
Was it a premature announcement?
Michael
Yes, it was. It is in building process right now.
--
Regards,
__ ___
[EMAIL PROTECTED] writes:
Hi,
Can anyone help me out! Does MySQL run efficently in a multi
CPU environment. I am using FreeBSD 4.1 at the moment but I am
looking to upgrade to 4.3 because as most ppl know 4.1 had that
bug that meant Mysqld would use 100% of the CPU. So my
Wouter de Jong writes:
On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote:
We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary
should run better ? Cause I tried it, and it dind't make a lot of difference.
--
Met vriendelijke groet/With kind
This morning after a restart of the computer, mysqld starts. For future
reference, where are the mysql logs?
Thanks.
Gerry
Rolf Hopkins wrote:
What do the mysql error logs say?
- Original Message -
From: Gerry Tool [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc:
What is RTFM?
A.
Scrive Rolf Hopkins [EMAIL PROTECTED]:
There are settings that could probably fix the problem then but I would
need
to RTFM.
- Original Message -
From: Aldo Spano [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June
Read The Manual = RTFM
-Original Message-
From: Aldo Spano [mailto:[EMAIL PROTECTED]]
Sent: 12 June 2001 14:30
To: Rolf Hopkins
Cc: [EMAIL PROTECTED]
Subject: Re: MYSQL error
What is RTFM?
A.
Scrive Rolf Hopkins [EMAIL PROTECTED]:
There are settings that could probably fix the
Hello.
On Mon, Jun 11, 2001 at 10:18:17PM -0230, [EMAIL PROTECTED] wrote:
Can someone please help with this database problem.
There are too few information to give a satisfying answer. Especially
the context (i.e. the query in question) is missing.
The error message states, that you somehow
---Reply to mail from Sinisa Milivojevic about Multiple CPU's
[EMAIL PROTECTED] writes:
Hi,
Can anyone help me out! Does MySQL run efficently in a multi
CPU environment.
[..]
MySQL supports as many CPU as you might have, but FreeBSD threads do
not support SMP, so MySQL can not
Well, i just did a pkginfo | grep zlib and this is
what I got,
application JGzlib zlib
So it appears to be installed.
Any ideas?
--- Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Mark Vann writes:
I am currently trying to compile mysql on solaris
2.7
, running on an ultra1
I also, just installed the zlibc lib from source and
it is still having this issue
WOW, solaris is so much harder to work with than linux
( for my ignorant self anyway )
--- Mark Vann [EMAIL PROTECTED] wrote:
Well, i just did a pkginfo | grep zlib and this is
what I got,
Seung-woo,
I understand the point you are making, a stored procedures is a group of queries that
can be executed together like a function. As you have said if you can [write] SQL
and Perl programs, you could write a
function that works like stored procedures in MS SQL server or Oracle.
My
On Tue, 12 Jun 2001, Gerry Tool wrote:
This morning after a restart of the computer, mysqld starts. For future
reference, where are the mysql logs?
In manual :)
This question cannot be answered with single sentence. Check the manual as
there are few differet logs in different OS-s in
The shell is tcsh.
I can do an nslookup and find organa.
My /usr/local directory points to a space on another server. I wanted to
keep it on my server(organa), which is why I used a subdirectory of
/export. Besides, I don't have permission to write to /usr/local.
My OS is Solaris2.7 /i386.
Using the source command on the command line, I am getting access
denied (to
the file, I am guessing).
I have tried these statements:
(1) source filename
(2) mysql -h hostname -u user database source_file
and I received the same access denied message.
What am I doing wrong?
Edward (newbie)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 June 2001 16:03
To: Craig Gilbert
Subject: Re: query
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the
i,
I have to write simple mysql script. I need folowing things:
Number of people logged in previous 0 to 24 hours
Number of people logged in previous 24.5 to 48 hours
Number of people logged in previous 48.5 to 72 hours
Number of people logged in previous 72.5 hours to 7 days
Number of people
Helo,
I'm intersted to know about MySQL replication, I could make it
work, I will send some problems I found later.
I have a question about the replication in MySQL:
Does it implement transaction? Imagin if the
connection break exactly in a sync of a row. What
Hi.
May sound like a stupid question, but do you have read access to
source_file?
Please quote the complete line with error message.
Are you able to execute another statement on the server?
What does source_file contain? When it tries to create a database, a
table, whatever - do the user you
The access denied message is most likely occurring because you are not
supplying the password option (-p) to the mysql command.
- TIM
Using the source command on the command line, I am getting access
denied (to
the file, I am guessing).
I have tried these statements:
(1) source filename
On 6/11/01 11:11 PM, Jari Mäkelä [EMAIL PROTECTED] wrote:
Hi,
how a field ( names of products ) of database should be defined so that you
could not enter identical entries at the field?
Or does one need to do the validation before inserting info?
Jari Mäkelä
How about creating a
Hello.
On Tue, Jun 12, 2001 at 04:07:11PM +0100, [EMAIL PROTECTED] wrote:
[...]
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query
Sasha,
Another shot in the dark. The user table in db mysql should also have a
host entry for the user specified - verify that you do not just have an
entry for localhost. (Use % wildcard to indicate all hosts instead, or
duplicate the row with localhost on it and use the windows host name.)
Hello.
Sorry, but I fear, I am not sure what you mean by sync of a row. In
MySQL, replication sends complete commands to the slave and if the
command is received completely, it will be executed.
The server holds a log about all commands and when the connections
breaks, the slave remembers the
Though I wouldn't be 'happy' using the environment setup you have, the real
issue that's causing your problem(s) is the fact that you downloaded and
installed the package (note the word sparc which means that this package
is for Sun SPARC based computers):
On Tuesday 12 June 2001 09:39, Benjamin Pflugmann wrote:
Hello.
On Tue, Jun 12, 2001 at 04:07:11PM +0100, [EMAIL PROTECTED] wrote:
[...]
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of
I just attempted to compile mysql 3.23.38
on a Solaris 8/sparc systems with gcc 2.95.3
(installed from binary from sunfreeware.com),
. When I run ./configure --prefix=/usr/local/mysql
the configure dies with:
checking return type of sprintf...configure error, cannot
run test program while
I have been given the source to a large perl-based cgi application. It uses a
Template Manager packaged as EXARO. I have never heard of this package, nor can I
find any information about it online. I was hoping that someone on this list has
heard of this package and can send me some
I think i recompiled my compiler, i was using the one
from sunfreeware.com, then i got the source, compiled
it, and that error no longer comes up,
But now i have a different error completly, so there
you go :-)
( i had this same problem on the gd1.8.4 and it fixed
it )
--- Rutherford, John
You should be able to export data directly from Access to a delimited text
file.
Curtis
On Thu, 7 Jun 2001, Ute Hoffmann wrote:
Hi,
I have a database table, which was made with Microsoft Access and am to move
the data into a mysql database table. As there are some long entries, which
Of the many mysql resources I have (including a book and searching the
website), there doesnt seem to be a definitive outline of what variables
can be controlled by my.cnf.
Is there a list somewhere outlining the possibilities?
Dennis
On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote:
Dear all,
can anybody tell me how to install mysql replication
step by step :-).
thanks in advance.
Best regards,
It is described step-by-step in the manual
On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote:
On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote:
Dear all,
can anybody tell me how to install mysql replication
step by step :-).
thanks in
Description:
Unable to compile a binary for mysql-3.23.38.
How-To-Repeat:
Downloaded mysql-3.23.38.tar.gz. Used gunzip, then gtar to
uncompress. No errors indicated.
Used the command from the mysql instruction manual:
CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions
At 3:36 PM -0400 6/12/01, Dennis wrote:
Of the many mysql resources I have (including a book and searching
the website), there doesnt seem to be a definitive outline of what
variables can be controlled by my.cnf.
set-variable = var_name=var_value
should work for pretty much any variable that
On Tue, Jun 12, 2001 at 12:45:15PM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote:
On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote:
Dear all,
can anybody tell me how
Okay, I will get in on this, too. I found the replication procedure in the
documentation to be very complete (we are all talking about
http://www.mysql/com/doc/, right? Read all parts of Chapter 11, right?).
I had no problem following the procedure.
However, I will admit that the replication
Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
release:
-- mysql-3.23.38.tar.gz
via
./configure --prefix=/dir --with-low-memory
Is that really what you type: --prefix=/dir ?
strange name for a DIRectory? Can be a reserved word.
make
make install
I get to:
yacc -d
I don't think that's what Dennis person wants to know, I think he wants to
know every single variable that he can control in my.cnf.
--On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois [EMAIL PROTECTED]
wrote:
At 3:36 PM -0400 6/12/01, Dennis wrote:
Of the many mysql resources I have
I think we would need much more information than what you have given to
verify what is going wrong, but I am not the expert on replication yet,
since I haven't got it working yet.
Although I am confused, for you requested that somebody tell you how to
install it, and last I heard you
As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6?
I want to accept a table name at runtime, and then export both the data
and data structure to a file which is compatible with MS Access; which
the table will eventually be imported into.
Are their any API's to do this?
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
'user' WITH GRANT OPTION' at line 1
What
This really might be a DBI problem, but I find it's pretty weird.
I am attempting to perform atomic updates by using UPDATE statements
like:
UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx';
where counter has the schema: create table counter (k varchar(16) primary key, v
At 5:25 PM -0500 6/12/01, David Simcik wrote:
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED
At 4:34 PM -0500 6/12/01, Erik Rantapaa wrote:
This really might be a DBI problem, but I find it's pretty weird.
I am attempting to perform atomic updates by using UPDATE statements
like:
UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx';
where counter has the schema: create
Hello
I've established that the MySQL server is running, but I cannot create or do anything
with it. Here is some examples.
[root@www bin]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
[root@www bin]# mysqladmin -u root -p create
Is there a way/tool to migrate the Application from MySql to Oracle 8i?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
David Ayliffe [EMAIL PROTECTED] wrote:
As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6?
I want to accept a table name at runtime, and then export both the data
and data structure to a file which is compatible with MS Access; which
the table will eventually be
Can someone tell me why:
SELECT Items.*, IF(Items.status IN ('Event', 'Not Purchasable',
Special') OR ('-6-12' = Items.start AND '-6-12'
Items.end),1,0) as inseason FROM Items, Categories WHERE
Items.category=Categories.id AND Items.showitem0 AND
Categories.id 5
On Wed, 13 Jun 2001, Brian Walker wrote:
I've established that the MySQL server is running, but I cannot create
or do anything with it. Here is some examples.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
It probably created mysql.sock
On Wed, 13 Jun 2001, Brian Walker wrote:
mysqladmin: connect to server at 'localhost' failed error: 'Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(111)' Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
When this
I would like to know if there is a way to use
a compressed MYSQL bank for read and write (dynamic
compression/decompression).
Using myisampack utility I can only create a
read-only bank.
Is there any internal compression scheme
in MySQL ?
Disk space is an important factor in my
work. Every day
On Tue, 12 Jun 2001, Emiliano F Castejon (Castle John) wrote:
I would like to know if there is a way to use a compressed MYSQL bank
for read and write (dynamic compression/decompression).
I'm not sure if it is possible to do this natively in MySQL; I'll let
someone else answer that.
You
i,
I have to write simple mysql script. I need folowing things:
Number of people logged in previous 0 to 24 hours
Number of people logged in previous 24.5 to 48 hours
Number of people logged in previous 48.5 to 72 hours
Number of people logged in previous 72.5 hours to 7 days
Number of people
On Tue, 12 Jun 2001, David Simcik wrote:
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '%
Which program?
--On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois [EMAIL PROTECTED] wrote:
At 4:34 PM -0400 6/12/01, William M. Quarles wrote:
I don't think that's what Dennis person wants to know, I think he
wants to know every single variable that he can control in my.cnf.
Running a
On Tue, 12 Jun 2001, William M. Quarles wrote:
Which program?
Here's what the /etc/my.cnf file on my system looks like:
[client]
port=3306
socket=/home/mysql/mysql.sock
[mysqld]
port=3306
socket=/home/mysql/mysql.sock
The first section affects the mysql client. The second section affects
At 8:15 PM -0400 6/12/01, William M. Quarles wrote:
Which program?
Uh ... what?
mysqld, mysql, mysqladmin, mysqldump, mysqlshow, ... For example,
if you run mysql --help, the output includes:
Possible variables for
The command lines are divided up by topics in the manual, I think. I know
that there is a specific section on replication. A table of all of them in
one place would be a helpful appendix in a future edition of the
documentation.
[hint, hint, MySQL AB developers...]
--On Tuesday, June 12,
On Tue, Jun 12, 2001 at 04:47:47PM -0500, Paul DuBois wrote:
Try using:
$dbh-do (UPDATE ... WHERE k = ?, undef, xxx)
and then access $dbh-{mysql_insertid} to see if you get a different
result. I suspect perhaps not, but it's something to try.
Unfortunately I get the same result.
Hello,
My problem is about users variables. I want to do
a script to create a database so:
SET @dbname:=mydbname;
CREATE DATABASE @dbname;# -- Don´t
work
CREATE DATABASE (SELECT @dbname);# -- Don´t
Work
I have tried to define @dbname=mydbname directly
but it blocks.
On Wed, Jun 13, 2001 at 12:42:00AM -, [EMAIL PROTECTED] wrote:
database,sql,query,table
Anyone have an interpretation of this:
010612 20:37:32 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 4
010612 20:37:32 Slave: reconnected to master
On Wed, Jun 13, 2001 at 12:49:22AM -, [EMAIL PROTECTED] wrote:
database,sql,query,table
- which is really too constricted!
On Tue, Jun 12, 2001 at 04:10:44PM -0400, Jim Ziegler wrote:
010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST'
position 4
I purchased the mysql msql book from O'Reilly as well as another
mysql book with a CD. I loaded the 3.22 versions to a windows and
also to a Linux machine. It took me quite a while to determine
where the files were located on the Linux machine as the installation
process was done by CD. I
On Tue, 12 Jun 2001, Martin Scherer wrote:
I am told that mysqladmin is not an understood command.
Looks like you need to update your PATH variable.
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
I'm having a slight problem trying to figure out some logic. I have a
mySQL table that contains 3 columns (child, category, parent).
What I like to do is retrieve all the childrens of the parent and store
them in an php array.
Any advies on this issue will be very helpful.
Thanks in
It is Read The Fine Manual.
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Aldo Spano' [EMAIL PROTECTED]; Rolf Hopkins
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 6:58 PM
Subject: RE: MYSQL error
Read The Manual = RTFM
You don't have to join
I am trying to use MySQL GUI client on W2K to connect to MySQL server running on
RedRat Linux 7.1 and I am getting the following error
Host '192.168.0.152' is not allowed to connect to this MySQL server.
Do I need to change something on my Linux?
No, you need to add a user to MySQL that is allowed access from that host.
See the GRANT statement in the manual. I'm also betting that that is a
dynamic IP address in which case you'll probably have to setup a user with
access from 192.168.0.%
- Original Message -
From: Anthony
Hi,
I'm having a slight problem trying to figure out some logic. I have a
mySQL table that contains 3 columns (child, category, parent).
What I like to do is retrieve all the childrens of the parent and store
them in an php array.
I assume you want to get all children for all parents
Thanks for the reply
Conducting a 'find' does not turn up the mysql.sock file anywhere on my
server. Is there any reason why the installation would not create this
file?
MySQL did create a directory under /var/lib called mysql, but mysql.sock is
not in there.
As stated, I'm running a Cobalt
At 3:16 AM +0200 6/13/01, Luis A. Fdez. de Retana Aguirre wrote:
Hello,
My problem is about users variables. I want to do
a script to create a database so:
SET @dbname:=mydbname;
CREATE DATABASE @dbname;# -- Don´t
work
CREATE DATABASE (SELECT @dbname);# -- Don´t
Work
At 7:00 PM -0700 6/12/01, Martin Scherer wrote:
I purchased the mysql msql book from O'Reilly as well as another
mysql book with a CD. I loaded the 3.22 versions to a windows and
also to a Linux machine. It took me quite a while to determine
where the files were located on the Linux machine
Thank you, but what does exactly does that mean. An example would help.
m.
On Tue, 12 Jun 2001, Martin Scherer wrote:
I am told that mysqladmin is not an understood command.
Looks like you need to update your PATH variable.
Neil
I'm only a digest subscriber, so I apologise in advance for any
mis-quotes:
Ok here is my experience with MySQL replication:
1) it's been very stable, and haven't noticed any drift in the
replicating servers
2) we have ~7 replicating servers-- 3 in circular replication which
recieve all of the
Hi all,
I need to convert the records from mysql database into MS.Access.
I don't have ODBC.The mysql is in different machine(stand alone).So i need
to convert that into a flat file then put into MS-Access.
Can u pl.help me in this regard.
It's very urgent.It'll b very much useful if i get a
94 matches
Mail list logo