Massimo Bandinelli wrote:
>
> I've problems sincronizing a Slave DB with a Master.
>
> I've a db created with name "foo-db" from phpmyadmin but the mysql shell doesn't
>accept
>
> > create database foo-db;
>
> Do you know something about this??
Check your privileges.
Use mysql_fix_privilege_t
There seems to be nothing in the Manual about a lot of things. For
example, the utilities mysqldumpslow, and mysqlcheck, etc.
Sincerely,
Steven Roussey
http://Network54.com/
-
Before posting, please check:
http://www.mysql
Hi all,
I would like to know when MySQL version 4.1 will be available for windows
as compiled install kit?
Thanks,
Daniel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hi,
I would like to know how to store an image as a BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
---
Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus.
Xnet automatically scans all messages
On Wed, 2002-11-20 at 18:19, Stick Dragon wrote:
> I had a free mysql database and admined with phpmyadmin. well i got a back
> up from called backup.sql
>
> in side the file it looks like this
>
> # Table structure for table `phpbb_auth_access`
> #
>
> CREATE TABLE phpbb_auth_access (
> grou
Greets:
I just have a quick question. I've been setting up a
website using a MySQL database loaded with a large
number of articles but I'm having a problem.
Some of the articles did not load correctly into the
database. Is there a method of loading a text (well,
in this case a *.html file) fil
In the last episode (Nov 21), ck nuke said:
> I have a problem about : mysql query
> I need help for this.
> Sever: mysql Version: 4.0.4-bata
> SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
> 0,1
Hi
I have a problem about : mysql query
I need help for this.
Sever: mysql Version: 4.0.4-bata
SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
0,1
When use this command, no result
---
At 21:38 -0500 11/20/02, Daniel Chicayban wrote:
Query:
SELECT Count(id) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value 0
Query:
SELECT Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value '' (nothing)
And
Query:
SELECT Count(id)+Sum(nGuests) AS Taken FROM Clas
I've been running MySQL on Windows 2000 and Windows XP as local services
on my DESKTOP, (I know, I know) without any problems. In fact, I hardly
even know that the services are running except when I process a large
chunk of data...
Dan Cumpian
-Original Message-
From: John Ragan [mailto:
Query:
SELECT Count(id) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value 0
Query:
SELECT Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value '' (nothing)
And
Query:
SELECT Count(id)+Sum(nGuests) AS Taken FROM ClassGuests WHERE id=5
Returns 1 record, value '' (not
I have recently installed msql v 3.21 on my UNIX server (SCO Openserver
Enterprise). Can someone steer me to where I might find a UNIX character
based front end (NOT GUI) so that I might be able to interactively add,
edit, delete, and browse the records of my database.
Thanks,
--Ray <[EMAIL PR
my experience is rather limited since i use linux
only as a file server. after installations of
mysql on win2k and nt4.0 sp6, i can say that it
came up without incident, and has been running
for months in the corereader test environment.
it was far far easier to install than oracle, and
ea
thanks for the chuckle. we've all been beginners
and i still do dumb things with sql.
download corereader from http://corereader.com
it will let you click on the database objects to
build your queries. when you click on your table
name and your field name, it will return the data
to you an
since you're comfortable with rolling your own
tools, here are some observations about the ado
approach, and which could be applied to odbc as
well.
i'm running an oracle enterprise server in a test
environment for corereader, and i've noticed
that, although oracle sometimes takes a while to
Hi, this is my first dabble of using MySQL and am having trouble setting a
password.
I have installed MySQL on Windows XP. I've gone through the manual, but I
can't really find how to do it. If you could post me the coomand line I need
to enter, it would be great. Thanks.
Trystan Hughes
--
On Thursday 21 November 2002 00:31, JohnMeyer wrote:
> When you specify a limit clause, do you start at 0 or at 1?
> The reason why I ask is that, on one query, it seems to be picking up the
> second record first when I use 1 e.g LIMIT 1, 10.
>
>
>
>
Use the mysqlc.exe client instead of mysql.exe
-- Geoff Morris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 7:28 AM
To: [EMAIL PROTECTED]
Subject: Error 1148 The error used Command is not allowed with this
MySQL -Version
Hello
In my situation I used Delphi 6 and MySQL as a client/server application. I
tried DBX before but it gives me more headache, more on connection
issue...so I decided to switch to WinZeos project as a component in
Delphi...for now I use the component as my basic connector to my server. I
also heard th
Stick Dragon wrote:
I had a free mysql database and admined with phpmyadmin. well i got a
back up from called backup.sql
in side the file it looks like this
# Table structure for table `phpbb_auth_access`
#
CREATE TABLE phpbb_auth_access (
group_id mediumint(8) NOT NULL default '0',
forum_i
When you specify a limit clause, do you start at 0 or at 1?
The reason why I ask is that, on one query, it seems to be picking up the
second record first when I use 1 e.g LIMIT 1, 10.
-
Before posting, please check:
http://ww
Hi,
I don't have the answer, but when that happens, the first thing I do is dig
around in phpMyAdmin(.org)... it's a web based GUI for MySQL, and most of
the time, when you do something (like copy a table), it shows you the query
used to do it... then you just need to copy it, and integrate it int
On 20 Nov 2002, at 16:01, Steve Buehler wrote:
> Thank You. I am not sure which one is faster because I don't have any HUGE
> tables to test it on, but someone from the PHP mailing list gave me the
> following that works like a charm.
> create table table2 select * from table1
The problem with
I had a free mysql database and admined with phpmyadmin. well i got a back
up from called backup.sql
in side the file it looks like this
# Table structure for table `phpbb_auth_access`
#
CREATE TABLE phpbb_auth_access (
group_id mediumint(8) NOT NULL default '0',
forum_id smallint(5) unsigned
Hi all,
I have the following query i'm running through a PHP script:
SELECT DISTINCT board_threads.*
FROM board_threads
LEFT JOIN board_replies
ON board_threads.id = board_replies.threadid
WHERE (board_threads.stamp > '{$startDate}' OR board_replies.stamp >
'{$startDate}')
ORDER BY board_threads
Wesley,
Forgive me because I'm not overly familiar with Oracle, and this is an
unproven idea
If you can run the oracle export function from unix shell, you could do
something like the following
-- Install the mysql client on the oracle db server (will be quick and won't
need any downtime
> When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of
> data and some of my data is not shown.
the garbled display is probably due to the results being wider then the
screen/terminal, and since the mysql client doesn't implement a horizontal
scrollbar like a gui/web mysql
TERRIBLE!
at least with ver mysql-3.23.53 on Win98. It crashes my machine
after a while and when I close it, it sends the hadr drive into an
infinite loop doing who knows what.
On 20 Nov 2002, at 11:02, Simon Windsor wrote:
> Hi
>
> I have been asked to support/bug-fix a Windows based web s
Thank You. I am not sure which one is faster because I don't have any HUGE
tables to test it on, but someone from the PHP mailing list gave me the
following that works like a charm.
create table table2 select * from table1
Thanks
Steve
At 02:09 PM 11/20/2002 -0500, you wrote:
On 20 Nov 2002, a
You should write:
SELECT postcode FROM TABLE_NAME;
This will display the postcode from your table?
Jfernand
** sql **
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: November 20, 2002 16:12
To: [EMAIL PROTECTED]
Subject: SELECT Statement Question
Hi
I am a
Hi
I am a beginner in using mysql on Windows platform, and I have a question regarding
the use of "SELECT * from TABLE_NAME" statement within the mysql prompt.
I have a table of consisting of three columns POSTCODE, SUBURB, STATE where
the primary key is a composite of all three fields.
When I r
> Can you explain this procedure to me a little better or point me to
> something I can read? I still have to convince the person who manages the
> Oracle box to open up an NFS share.
The point of using NFS to transfer the files from the oracle box to the
mysql box is to avoid copying the data twi
Well, it looks like Simon has the best possible answer so far. I did a test
dump into a delimited file from Oracle and imported that using the LOAD
command in mysql and sustaned about 11,000 inserts a second. This is with no
indexes on the mysql tables at all. I have also tried using the dbtools
im
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 20 November 2002 20:32, [EMAIL PROTECTED] wrote:
> I have done quite a bit of searching but have not been able to find any
> MySQL 3.23.x Binary packages for AIX 4.2.1 (RS6000) any help in locating
> one would be very much appreciated.
S
Dear Egor,
thanks for your great advice, finally pointing out the reason for the
problem.
> SH> mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL
> SH> PRIMARY KEY;
> SH> ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to
> SH> '.\trainee\#sql2-648-2.MYI' (Errcode: 13)
>
Hello All,
I have done quite a bit of searching but have not been able to find any
MySQL 3.23.x Binary packages for AIX 4.2.1 (RS6000) any help in locating one
would be very much appreciated.
Thank you,
Christophe Banal
-
Be
On 20 Nov 2002, at 12:54, Steve Buehler wrote:
> What I am trying to do is to copy a mysql table to a new
> table name in a PHP script.
Use the query "SHOW CREATE TABLE $from_table" to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
Hi
I have moved huge amounts of data around in the past, from Oracle to Oracle,
and Oracle to MySQL.
The problems to consider are
- export speed
- load speed
It can take hours to download a large database, nevermind re-loading it into
another database. It is usually best to export the data in
--- Steve Buehler <[EMAIL PROTECTED]> wrote:
> What I am trying to do is to copy a mysql table to a new table
name
> in a PHP script.
An SQL statement similar to this might be what you are looking for:
create table tmp_foo as select * from foo
I believe this will fail to create any keys, indece
Using PHP and MySQL.
I have looked and can't find the answer to this problem. What I am trying
to do is to copy a mysql table to a new table name in a PHP script. The
reason for this is to keep the original table the way it is and editing the
copy. Now, I know that I can go through a loop rea
Scott Pippin
[EMAIL PROTECTED]
>>> "Wesley Brown" <[EMAIL PROTECTED]> 11/20/02 11:24AM >>>
>Well, This is my first attempt at moving from Oracle to MySQL on such
a
>large scale and so far it isn't going well at all. We are running
oracle
>7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 t
Sorry, but I've omitted part of the where clause to make the message shorter
and now I see that it was important. Here goes the select again:
SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurence, INTERVAL B.dthr_occurrence HOUR_MIN
On Wed, 20 Nov 2002, Joseph Bueno wrote:
> Fabrizio Nesti wrote:
> >
> > Why this simple query does not use the PRIMARY key (which is oai_ui)?
> >
> > mysql> explain select * from idb_metadata where oai_ui like 'doi:10.1088/0%';
>
> > While this is correctly using it
> > mysql> explain sel
Well, This is my first attempt at moving from Oracle to MySQL on such a
large scale and so far it isn't going well at all. We are running oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total
of 45 millon records over. I have tried several diffrent methods including
usi
Hi,
>From the manual (http://www.mysql.com/doc/en/MySQL_indexes.html):
Fabrizio Nesti wrote:
> Hello, it may be a simple question, but I can't get to it:
>
> Why this simple query does not use the PRIMARY key (which is oai_ui)?
>
> mysql> explain select * from idb_metadata where oai_ui like '
Hello, it may be a simple question, but I can't get to it:
Why this simple query does not use the PRIMARY key (which is oai_ui)?
mysql> explain select * from idb_metadata where oai_ui like 'doi:10.1088/0%';
+--+--+---+--+-+--+++
|
On 20 Nov 2002, at 15:30, Felipe D. Ramalho wrote:
> Sorry, but I've omitted part of the where clause to make the message shorter
> and now I see that it was important. Here goes the select again:
>
> SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
>B.dthr_occurrence as open,
>
Hi, Sergei.
In myisam/ftdefs.h I changed:
#define MIN_WORK_LEN 4
to:
#define MIN_WORD_LEN 2
and I commented out the line:
#define COMPILE_STOPWORDS_IN
(this should leave out stopwords right?)
There were no changes to ftstatic.c
recompile, reinstall, restart mysql.
To test I dropped and rec
Sorry, but I've omitted part of the where clause to make the message shorter
and now I see that it was important. Here goes the select again:
SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurence, INTERVAL B.dthr_occurrence HOUR_MIN
Hi!
On Nov 18, Kevin Lewandowski wrote:
> I'm using mysql fulltext indexes and want them to see words of 2 or
> more characters, and no stopwords. I've edited the appropriate files
> (ftdefs.h, ft_static.c), then recompile, install, restart mysql,
> rebuild indexes, and there is no change. It s
Hi,
I tried taking out the new MYSQL, and my application dumps -- it doesn't
look like mysql_init is actually allocating memory for the MYSQL object
because then mysql_real_connect is called with a NULL pointer.
Is that supposed to happen?
--Anna
Ben Goodwin wrote:
Hi!
mysql_init will detec
On 20 Nov 2002, at 14:40, Felipe D. Ramalho wrote:
> SELECT ..., B.dthr_occurrence as open,
> DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
> HOUR_MINUTE) AS during,
> DATE_SUB(D.dthr_occurrence, INTERVAL B.dthr_occurrence
> HOUR_MINUTE) AS late
>
> FROM CALL A
Syntax errors. Try:
SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )
Ignatius
- Original Message -
From: "Francesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROT
On Wed, 20 Nov 2002, Francesco wrote:
> Hello,
> I tried to execute the following query:
> SELECT studenti.*
> FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
> WHERE valutazioni.sid IS NULL;
Hi!
I think you don't have to specify valutazioni in the FROM subclause
Hello,
I tried to execute the following query:
SELECT studenti.*
FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE valutazioni.sid IS NULL;
and give me the following error message:
ERROR 1066: Not unique table/alias: 'valutazioni'
I have the Mysql 4.0.1 alpha ve
Hi,
I'd like to obtain the number of hours and minutes between two fields
datetime and I'm trying to proceed just like the documentation says.
SELECT ..., B.dthr_occurrence as open,
DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
HOUR_MINUTE) AS during,
DATE_SUB(
Hi,
Currently, my program creates a new MYSQL object each time a connection
is needed to save or load information from my MySQL database.
Sometimes, this connection is created 10,000 or more times during one
use of the program. I'm wondering if I reuse the connection (have a
static MYSQL attr
Hello,
I have several mysql 3.23 daemons running in a Windows
XP Professional computer. To achieve this, I have run
the following commands:
mysqld-opt --basedir=C:\mysql
--datadir="C:\mydb\data1"
--port=3020
--standalone
--default-table-type=MyISAM
--tmpdir="C:\mydb\temp1"
mysqld-opt --based
thanks a lot for both replies.
I just asked as this question was brought up with the post before mine.
I will ask further off-list :-).
Thomas
On Wed, 20 Nov 2002 15:25:32 +0100 Thomas Seifert <[EMAIL PROTECTED]> wrote:
>
> and how on-the-fly?
>
>
> Thomas
>
> On Wed, 20 Nov 2002 09:18:1
A question:
I've a Mysql System with a Master and two slave.
Can I configure my master to automatically forward the select queries to =
the slaves?
Massimo Bandinelli
System Administrator
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39
I would like to export the full contents of one particular table in a
database to a csv file once every day. I will then email this file I am
running MySQL 3.21 on a RedHat 7.2 server. Is there an automated way of
doing this?
This e-mail is in
Well, I've done imports of about 50.000-100.000 posts from other databases.
I've gone another way then, and through perl/vi generated a file of
mysql commands
that I've then run. Maybe is a bit slower, but you get a complete log in
case some things dont
work out when you have logging turned on.
Hi Thomas,
This would be a question for your OS support list, however an
example from FreeBSD:
bash-2.04$ sysctl -a | grep files
kern.maxfiles: 2
kern.maxfilesperproc: 19000
kern.openfiles: 1569
bash-2.04$ su
tuvok# sysctl kern.maxfiles=20001
kern.maxfiles: 2 -> 20001
tuvok#
Hope thi
Can somebody suggest some good English magazines on MySQL ?
Rgds
Insane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
To optimize speed I would like to use a HANDLER sql query to get data
from my database.
HANDLER questions OPEN;
HANDLER questions READ FIRST WHERE qid = 1 LIMIT 1;
[Php code collects data]
HANDLER questions CLOSE;
Is that the best way to use HANDLER?
Can I make it even faster?
If any of you spe
If you with Linux, you can use the 'sysctl' programm.
sysctl -h gives you the parameters (i.e -u is for the maximum
number of processes created by a user). I use the sysctl command
in the safe_mysqld script to increase this number. if you want to
set a parameter systemwide you may also use /etc/sys
MySQL Gurus:
I am working on a process to import data from a VMS database (SJ2) to
MySQL.
The table that I am importing has 10378507 (over 10 million) records in
it. I have the records
exported to a comma-delimited text file, as the fields within the
database do not
contain any commas at all.
and how on-the-fly?
Thomas
On Wed, 20 Nov 2002 09:18:15 -0500 "Ken Menzel" <[EMAIL PROTECTED]> wrote:
> Yes, you are correct and it can be worse because you have not
> considered that there are some descriptors required by other processes
> running. I suggest you increase your file limit to
Yes, you are correct and it can be worse because you have not
considered that there are some descriptors required by other processes
running. I suggest you increase your file limit to at least 2048.
Good luck
Ken
- Original Message -
From: "Lance Lovette" <[EMAIL PROTECTED]>
To: "MySQL"
kwagner,
Wednesday, November 20, 2002, 2:27:45 PM, you wrote:
kapdd> I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try
kapdd> to load a Database from a textfile I got message "Error 1148 The error used
kapdd> Command is not allowed with this MySQL-Version".
kapdd> I used f
David,
Tuesday, November 19, 2002, 5:20:23 PM, you wrote:
DN> (sorry if this is a duplicate -- I don't think the original made it)
DN> Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
DN> is working fine, but I'm running into errors with the replicate-rewrite-db
DN> dir
Bingo! Thanks Dan
Missing were:
ftp://mysql.nixc.net/pub/mysql/Downloads/MySQL-4.0/mysql-4.0.5-beta.ta
r.gz
ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-4.0/mysql-4.0.
5-beta.tar.gz
http://mysql.mirrors.netnumina.com/Downloads/MySQL-4.0/mysql-4.0.5-bet
a.tar.gz
I only tried 3 befor
Greetings
I think the path for the file is not correct. Try giving the complete path
with (\) in the directory name changed to (/). Also specify the escaping
characters properly.
For more information you can check out the MySQL docs on LOAD LOCAL INFILE.
Rgds
Insane
SQLyog - The Definitive Windo
Thanks a lot.
-Messaggio originale-
Da: Roger Baklund [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 20 novembre 2002 13.59
A: [EMAIL PROTECTED]
Cc: Massimo Bandinelli
Oggetto: backticks & replication (was: Re: Slave sincronize)
* Massimo Bandinelli
> * Roger Baklund
> > * Massimo Bandine
* Massimo Bandinelli
> * Roger Baklund
> > * Massimo Bandinelli
> > > mysql shell doesn't accept
> > > > create database foo-db;
> > >
> > > Do you know something about this??
> >
> > The '-' character makes this name difficult for the mysql parser to
> > understand, it could be interpreted as "foo
MySQL is good on the Win32 platform ... slower than on Linux / Unix / BSD
etc., but nonetheless it is a good performer.
We have several of our Win32 clients who have switched to Linux servers or
have augmented their Win32 servers with Linux servers to specifically handle
database duties... the mig
John,
Wednesday, November 20, 2002, 8:32:35 AM, you wrote:
JC> After I dump the database what is the command to import it into another
JC> computer?
mysql -h -u -p [database_name] <
dump_file.sql
JC> Do I have to create a new database and then import all tables
JC> and data or will it create th
Stephen,
Wednesday, November 20, 2002, 5:48:35 AM, you wrote:
SA> I've managed to build my first web database using MySQL and accessing
SA> it with Python CGI scripts. I only have two tables going, and not
SA> many columns per table, but I'm suspecting that there will be many
SA> calls to INSERT,
p_action969,
Wednesday, November 20, 2002, 11:11:03 AM, you wrote:
paydc> mySQL package from SGI freeware will not install on
paydc> irix 6.2. It fails at the mysql_install_db script. The version i'm trying to
install is 3.22.21
paydc> >How-To-Repeat:
paydc> just run the mysql_i
Pallavi,
Wednesday, November 20, 2002, 11:01:51 AM, you wrote:
PAP> i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
PAP> Apache 1.3.24 .
PAP> i have encounter following error for load data local infile when i
PAP> tried to use an example on mysql site's documentation file :
[skip]
Hello,
I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try
to load a Database from a textfile I got message "Error 1148 The error used
Command is not allowed with this MySQL-Version".
I used following Command: LOAD DATA LOCAL INFILE "verlagdaten.txt" INTO
TABLE verlag;
Any
David,
- Original Message -
From: "David Mechner" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 20, 2002 1:59 PM
Subject: Re[2]: delete where column <=> null
> Ok, so it seems to be a bug. What's the procedure for reporting it (or
> do the developers re
Pallavi,
> mysql> load data infile "pet.txt" into table pet;
> ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
> mysql> load data infile "pet.txt" into table pet;
> Query OK, 8 rows affected (0.00 sec)
> Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
>
> mysql> select * from pet;
> +
Hello Pallavi,
> i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
> Apache 1.3.24 .
> i have encounter following error for load data local infile when i
> tried to use an example on mysql site's documentation file :
> mysql> use test;
> Database changed
> mysql> show tables;
> +-
Simon,
I have been asked to support/bug-fix a Windows based web site using MySQL.
I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows.
How does MySQL compare on Linux and Windows for stability and performance ?
=congratulations. Your relief appears in the phrase, MySQL is MySQL
[EMAIL PROTECTED] wrote:
>Description:
After installation and setting basic authentication data I tried to
connect to MySQL from other machine with the mysql client.
I could not connect, I just got an error message
"ERROR 2013: Lost connection to MySQL server during query"
It does not
Thanks Lenz. Now, after modifying the init script, I don't get the advise.
Iago Sineiro.
> -Mensaje original-
> De: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
> Enviado el: miércoles, 20 de noviembre de 2002 12:27
> Para: Iago Sineiro
> CC: MySql Mail List
> Asunto: Re: Problems installing m
Dear Readers,
I have a little mySQL problem here.
Maybe it's a bug, maybe I'm just too stupid to read the documentation
correctly, who knows... I'm sorry if I bother anyone with my stupidity.
I run a simpy query like:
SELECT INTERVAL((UNIX_TIMESTAMP(ReceivedDateTime) -
UNIX_TIMESTAMP(StartDate
Oh, yes, I know this option.
The problem is quiet different, because if I create a db using php with mysql_create
function, I can use the name with minus foo-db.
Analizing the binary log I see the command
> create database foo-db;
and when the slave process the query, it returns an error.
--
Hi Support Team,
I'm quite a novice in installing Mysql. I needed to do this because of a task i had to
accomplish by installing webtts for which mysql was a pre-requisite.
during the installation process of webtts, i had the following errors
"install_driver(mysql) failed: Can't load '/usr/local/l
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 20 November 2002 11:41, Iago Sineiro wrote:
> I resolved the problem of starting mysql server changing permissions of
> /tmp directory to permit user mysql write /tmp/mysql.sock.
>
> But when I start mysql server with /etc/init.d/mysql se
* Massimo Bandinelli
> I've problems sincronizing a Slave DB with a Master.
>
> I've a db created with name "foo-db" from phpmyadmin but the
> mysql shell doesn't accept
>
> > create database foo-db;
>
> Do you know something about this??
The '-' character makes this name difficult for the mysql p
Hi
I have been asked to support/bug-fix a Windows based web site using MySQL.
I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows.
How does MySQL compare on Linux and Windows for stability and performance ?
Simon
--
Simon Windsor
mail: [EMAIL PROTECTED]
-
Hi all.
I resolved the problem of starting mysql server changing permissions of /tmp
directory to permit user mysql write /tmp/mysql.sock.
But when I start mysql server with /etc/init.d/mysql server start I get
error @HOSTNAME@.
prototipo mysql # /etc/init.d/mysql.server start
/etc/init.d/mysql.
Rafal,
the table cache size limit parameter in my.cnf affects also InnoDB. MySQL is
not aware that InnoDB does not open any files when InnoDB creates a handle
to a new table.
Hmm... I doubt that "opening tables" really takes much time. You can try
empirically if the table cache size has any effec
I've problems sincronizing a Slave DB with a Master.
I've a db created with name "foo-db" from phpmyadmin but the mysql shell doesn't accept
> create database foo-db;
Do you know something about this??
Thanks, Massimo.
-
Befo
On Tue, 19 Nov 2002, Bill Easton wrote:
> I'd be happy to write up a short example for inclusion in the MySQL manual,
> if there were some indication from MySQL, AB, that it would be included.
I guess they will; after all it would fit perfectly into the tutorial and
would be most welcome to all r
Dobrý den,
terça-feira, 19 de novembro de 2002, 23:10:11, napsal jste:
PB> Hi,
PB> I like to know if you can help me. I installed mysql-3.23.53-win.zip
PB> which should have the Innodb feature as part of MySQL. However, I am
PB> unable to create an Innodb database. The problem may be that one o
Frank,
if the tables are InnoDB type, then the following patch might fix the
problem. The patch will be in 3.23.54, which, I guess, will be released
around December 5th, 2002.
"
MySQL/InnoDB-4.0.5, November 18, 2002
...
Fixed a bug: if a SELECT was done with a unique key from a primary index,
and
Frank,
if the tables are InnoDB type, then the following patch might fix the
problem. The patch will be in 3.23.54, which, I guess, will be released
around December 5th, 2002.
"
MySQL/InnoDB-4.0.5, November 18, 2002
...
Fixed a bug: if a SELECT was done with a unique key from a primary index,
and
1 - 100 of 107 matches
Mail list logo
