Wiley,
E:\mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
Error 13 means permission denied. Check if the MySQL has write access
to E:\. BTW, I don't think E:\ is a very good place to store your
databases. I would recommend at
Fax: +49 30 7970948-3
- Original Message -
From: Alex Shi [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql
group [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 10:39 PM
Subject: Re: datadir and socket
Hi Stefan,
Thanks a lot! With your help my issue
Message -
From: Alex Shi [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql
group [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 3:27 AM
Subject: Re: datadir and socket
There are three my.cnf you should look for:
1) /etc/my.cnf = global options
2) datadir
: Inbal Ovadia [EMAIL PROTECTED]
To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; Inbal
Ovadia [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 12:43 PM
Subject: RE: database mirroring in mysql
Hi and thanks for the reply.
After I read all about replication, I have a little
Daniel,
(you posted this question twice, but I will only answer it once ;-)
have a month string January from a get query string like so
?month=January ,
and i need to check a range of results within an endate so i need
WHERE end_date
$_GET['month'] ,
You could use the DATE_FORMAT() function
Peter,
sorry to say, but I guess your data have gone to Nirvana.
Is there any logs of the database commmands
There is. It's called binlog (binäre update log), and you can turn it on
by starting the server like mysqld --log-bin (or put log-bin in the
[myslqd] section of your my.cnf / my.ini).
Mustafa,
How i list connected users(active) to mysql server?
mysql SHOW PROCESSLIST;
++---+---+--+-+---+
| Id | User | Host | db | Command | Time |
++---+---+--+-+---+
| 2 | superuser | localhost | test |
Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: JD [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 5:18 AM
Subject: Making Lin/Win share DataSource
On Fri, 2003-01-31 at 06:39, Stefan Hinz, iConnect (Berlin) wrote
Gary,
[h24-85-217-157:/usr/local/bin] garydr% mysqldump -h localhost -u root
bpw_dbbpw_db_backup.sql
bpw_db_backup.sql: Permission denied.
This means that MySQL is not allowed to write in this directory. Which
directory? ;-) Well, as you don't specify a path, bpw_db_backup.sql will
be created
Paul,
I have the same problem, the file does exist and the ownership is the
mysql user, but the entry in the log file still says it cant find this
file when starting mysql daemon.
And the manual said: If you don't set up the grant tables, the
following error will appear in the log file when
Alex,
However, for local connections, say connections from a locally hosted
web site via PHP, or a command line connection issued from shell, it
Remote connections are made through TCP/IP. That's why you get the sock
error only for local connections.
will return following error message:
Inbal,
Is there a possibility, in MySql, to define a mirror to my database,
Yes. In MySQL, it's called replication, and it's quite easy to setup.
More info: http://www.mysql.com/doc/en/Replication.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH
Marco,
mysql update T_ORDH set STATUS=2 where PK_ID=26272;
ERSTELL_DATUM is set to the current date. I know that a timestamp
takes the current time, if set it to NULL, but since I'm not touching
it, it shouldn't change, should it?
A quick workaround is
mysql update T_ORDH set STATUS=2,
Prasanth,
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
An easy way to slice it into chunk would be:
CREATE TABLE tblPart_1 SELECT * FROM tblFull LIMIT 0,1000;
CREATE TABLE tblPart_2 SELECT * FROM tblFull LIMIT 1000,1000;
CREATE TABLE
30 7970948-3
- Original Message -
From: Sherzod Ruzmetov [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; JD
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 2:04 AM
Subject: RE: Making Lin/Win share DataSource
Wow, one hell of a discussion
Tarik,
- what is the stored character code of the enter key in the text
field, i am
figuring out to find that character and replace it with the br
element,
for the exact display,
The character is \n (the new line character).
If you use PHP and have magic_quotes=on in your php.ini, PHP will
Mary,
The Production server has MYSQL 3.23 and an older version of MYODBC
then I
have.
They run in 8 minutes on my test server , about 4 minutes each.
Printing to
a PDF driver.
On the Production Server they take HOURS to run and print.
Maybe this won't help too much, but I've experienced
Elby,
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
You do this with mysql in batch mode, not with mysqldump:
shell mysql your_database file.sql
Regards,
--
JD,
my answer may seem ridiculous, too, but with the following setup you
should be able to use MySQL databases and tables both under Linux and
Windows on the same machine.
About the only thing you need is access to the MySQL data directory from
both Linux and Windows. Regardless of the operating
Jonathan,
The O'Reilly Managing Using MySQL show on page 288 a table been
created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
But the MySQL manual says or:-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
or AUTO_INCREMENT = #
Oh, I stumbled
Steve,
this list is not the right place to ask JavaScript questions. Please
check out an appropriate list at http://php.net/.
But, anyway, it's possible to mix JS and PHP, no problem.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Vikram,
Can someone point me to amn (exhaustive) list of features in MySQL Max
that
are not present in MySQL Standard? Or any other documentation that
lists
the differences between the two?
http://www.mysql.com/products/mysql/index.html (not too exhaustive,
though)
Regards,
--
Stefan Hinz
Mike,
Has anyone done any work with getting images into and out of a MYSQL
database? I have used mysql for some time, but never stored an image
in a
blob field. I am curious on how to insert the image from a web form
upload,
and how to display the picture on another HTML page.
You might
Thomas,
I installed MySQL on my server and after reboot i got the error
message
when starting mysql:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
Is mysqld up and running? Try ps xa | grep mysqld.
Regards,
--
Stefan Hinz [EMAIL
Dirk,
you're right. LOCAL is disabled by default with all newer versions of
MySQL (server and client). One can enable LOCAL by _compiling_ MySQL
with --enable-local-infile, but this is not possible for binaries, of
course.
The manual says you can enable LOCAL with --local-infile=1, either for
Dhanashri,
ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 )
Error on rename of '.\etime\timesheet.MYI' to
'.\etime\#sql2-64c-19.MYI'
(Errcode: 13)
I had the same kind of problem with ALTER TABLE and MySQL 4.0.5 under
Win2K. Errorcode 13 means it's a permission problem. I never solved
Vicente,
language=spanish
You could try language=c:/mysql/share/spanish. With my 4.0.7 on Win2K,
both works.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
Victor,
good shot! I thought of this one in the first place:
SELECT u.user_id
FROM user_profile u
LEFT JOIN team_member t
ON u.user_id = t.user_id
WHERE t.team_id 2
But unfortunately, it will yield:
+-+-+
| user_id | team_id |
+-+-+
|1000 | 1 |
|
Vicente,
How can I change my error language in SQL (MySQL)? Have I to introduce
a new
set-variable in my.ini?
In the [mysqld] section of my.cnf / my.ini, type:
language=spanish
Alternatively, you can start mysqld with the --language=spanish option.
Regards,
--
Stefan Hinz [EMAIL
- Original Message -
From: Vicente Valero [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, January 27, 2003 1:06 PM
Subject: Re: Language errors
Hi,
I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section
Variables, language
Obafemi,
Please can someone tell me how to run a SELECT between databases on a
network.
With MySQL, this is not possible. AFAIK there are no plans to implement
this in the near future, or to implement this feature at all.
Customers using MS SQL Server asked me the same thing, as MS SQL Server
Devin,
GRANT ALL PRIVILEGES
ON devin.*
TO dmiller@%
IDENTIFIED BY password;
The command returns a Query ok and 0 rows affected. However, when I
try to
login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied
error.
With mysql -u dmiller -p, the hostname will be localhost (the
Manuel, Benjamin,
/usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757
Segmentation
fault
And again, this looks like the SuSE bug to me. Here's my posting about
an error like this on Red Hat:
cite who=myself
Synopsis: Server crashes on remote connection
I'm not a Unix guru but I
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Manuel Kiessling [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Cc: Benjamin Pflugmann [EMAIL PROTECTED];
[EMAIL
Scott,
I was wondering, is there a program simialar to MS SQL server - Query
Analyser, where you can write sql queries to query MySQl databases?
It's called EXPLAIN. More info: http://www.mysql.com/doc/en/EXPLAIN.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO
Darren,
Where does the mysql client store the query history information?
.mysql_history in your home directory, for example. Under Win it doesn't
get stored, AFAIK.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
Lewell,
ERROR 1064 at line 1: You have an error in your SQL syntax. Check
the
manual that corresponds to your mySQL server version for the right
syntax to
use near 'mysql_fix_privilege_tables' at line 1
The script your speaking of is a Unix shell script, and there is nothing
like that in
Chuck,
select * from orderheader where orderid like '$date' ;
The $date variable equals 20030124%
Am I right to suppose your query doesn't work? Did you try something
like:
$sql = select * from orderheader where orderid like '$date';
print $sql;
in your application?
If have not enough
Pag,
as Rich said:
select * from mytable limit 10,10
select * from mytable limit 20,10
In your PHP (?) application, you would have this like:
select * from mytable limit $start,$range
You could set up range (e.g. in config.inc.php) to whatever you want for
the site, and you would add $range
Mike,
example birthday=1972/02/14
How do i tell mysql to order by the day (14) only so that I can list
same
birthday in a month in acending order.
If your birthdays are stored in a DATE column, your example would be
1972-02-14. In this case, you can use the date functions of MySQL.
Here are
Darren,
Is the InnoDB table type available on Windows?
Yes. If you want it to be the default table type, start the server
with --default-table-type=innodb. Note that you will have to use a newer
version of MySQL ( 3.23.somewhat). In 3.23.x, you will have to enable
InnoDB, in 4.0.x, it's enabled
Scott,
most probably, you've got a glibc problem on your Red Hat box. Try
upgrading to a newer version of glibc, and if the problem (mysqld dies
when trying to connect from anywhere else than localhost) has gone, I
was right :)
(There was a very similar question a couple of days ago on this
Murthy,
how to insert only blank spaces into a field using insert query. Its
getting
trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL (Values are not padded; instead, trailing spaces are
removed when values are stored. (This space removal
a question:
i need also to change structure of the master table (have only a
primary key) or
the changes made on the updatable_table are enough?
regards,
fabrizio
On Fri, 24 Jan 2003 00:10:19 +0100
Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] wrote:
Fabrizio,
please send
Andrew,
Good morning everyone
Thanks for your optimism. It's 5 o'clock in the afternoon, here in
Berlin ;)
I tried the following in Windows; but stopped
mysqldump after the resulting file exceeded 1GB:
mysqldump -q -C -uusername -ppassword dbname
dbname.dmp
Well, Unix seems to be so much
Norris,
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I remember this well but I don't remember what I did to fix it.
Not to be impolite, but I'd say you should simply start the MySQL server
:)
Check system control administration services if there is a service
called
Elby,
I want to construct a table, and in this table I have a column (date
type)
that if I insert blank date, the MySQL automaticly insert the current
date
of system.
You can use a TIMESTAMP column for this. If you insert NULL (or even
nothing at all) it will be set to the current date and
Fabrizio,
please send the table structures of table_1 and table_2 (DESCRIBE ...)
so we can do more for you than just guess what the problem might be.
REPLACE seems good in the first place, but if it just INSERTs then
there's a problem with the (primary) keys.
Regards,
--
Stefan Hinz [EMAIL
-
From: Norris, Joseph [EMAIL PROTECTED]
To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; Norris,
Joseph [EMAIL PROTECTED]; Mysql_List (E-mail)
[EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 5:20 PM
Subject: RE: Install on WIN2k
Stefan,
I have checked these things. To re-state
Martin, Larry,
Synopsis: Server crashes on remote connection
I'm not a Unix guru but I experienced the same sympton on SuSE Linux
8.0/8.1, and I heard of people reporting the same of Red Hat Linux
7.x/8.x.
MySQL runs stable, you can connect from localhost via socket and tcp/ip,
but as
Octavian,
seems like LAST_INSERT_ID() will not always return the correct value. If
you use ANSI-SQL INSERT, the function works fine. If you use MySQL
extended INSERT (i.e. with more than one record per insert statement),
the function will return the ID of the _first_ record inserted with an
Daniel,
you can find a list of the new features here:
http://www.mysql.com/doc/en/News-4.1.x.html
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
-
Steve,
([Defendant] Query WITH a join - 8.79 seconds!
EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE
Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND
(Defendant LIKE owen% OR Defendant LIKE pitts% OR Defendant LIKE
general%);
First thing that comes into
Dear Velmani,
what do you mean with Indian? AFAIK there are 36 languages spoken in
India. Do you mean English? ;-)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30
[EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Cc: Octavian Rasnita [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 7:29 PM
Subject: Re: Which is the difference?
Hello.
On Wed 2003-01-22 at 08:53:23 +0100, [EMAIL PROTECTED] wrote:
seems
Steve,
SQL joins are damn slow! I have a simple database of about 37,000
records in [Court Cases] and 2,000,000 records in [Defendants] (soon
to
be more).
Please post the structures of your 2 tables (at least, the relevant
parts), and the join query that gets so slow. Otherwise, we can only
Tom,
I have Database 1, table userdata, field username
I need to copy the above mentioned data to:
Database2, Table chat_data, field nick
in phpMyAdmin 2.3.3pl1 you can accomplish this as follows:
1. Choose Database 1 in the left frame.
2. Click table userdata in the left frame.
3. Click the
Craig,
I want to have users give a description in a form and varchar(255)
wont give
me enough space so I thought I would use text(650) but it seems the
'text'
type wont take the limit of (650), it simply offers the user (65535):
way
too much.
In MySQL, you have TINYTEXT (2**8 = 256, like
Frank,
Yep Jermey are right what he says - Anyone know about using Database
link in Mysql???
This is not built in. You will have to do this within your application.
You can also use some of the MySQL helper apps for this, like mysqldump
in combination with mysql (the command line tool), like
Dave,
I am looking for an
easy to use, easy to install mysql client which would enable users to
query
my database.
What about a web browser? It's most probably installed on all laptops.
You could use some simple PHP script (not as mighty as phpMyAdmin, I
would suggest) to convert SQL queries
Robyn,
Could anyone please tell me how I write an SQL statement to seperate
text from one field into multiple fields based on a aprticular
character
(i.e. tab/comma/space). For example, I have a text field containing:
Text=Robyn Bailey Brisbane
I understand you have all of this in just ONE
Jon,
Where can I look to see the Warnings?
MySQL 4.1 will come with an enhanced error/warnings reporting system
where you can use SHOW ERRORS and SHOW WARNINGS (see
http://www.mysql.com/doc/en/SHOW_WARNINGS.html for details).
If you don't have 4.1 (as most of us) you can tell the server to log
Jannie,
/etc/my.cnf. But there is no my.cnf file at that directory.
So my question is:How to generate my.cnf based on existing
configuration?
You can see the server options for the MySQL server by issuing
mysqld --print-defaults
The output is pretty ugly, but it will show you all settings
Octavian,
mysql create table test(id float);
mysql insert into test values(1.123), (3.1495);
mysql select * from test where id=1.123;
Empty set (0.00 sec)
Shouldn't this last query show me the record that has the id=1.123?
Well ... 1.123 is greater than 1.123, see:
mysql select id from
Doll,
My web server only accommodates mysql.
I wouldn't say only, though :)
Now, what do I need to do get this table operational for my website?
I
wanted to create a search program for users.
Use PHP. It's easy to learn and works smoothly with MySQL. You will find
lots of examples how to
Nedim,
I am new to MySql. I need to obtain information about tables including
the
names and types of each column, the primary keys etc.
SHOW TABLE STATUS;
To see only tables starting with t: SHOW TABLE STATUS LIKE 't%';
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
Regards,
--
Stefan
Hi,
but the commnads don't work unless i have ./ infront of the command
for example: mysqladmin won't work unless its written ./mysqladmin.
If you're logged in as root, log out and log in as another Linux user.
(I'm a Windoze fan, but AFAIK root must type ./ for command for security
reasons.)
Ryan,
this line is not correct:
$line = mysql_fetch_array($result, MYSQL_ASSOC);
Instead, you will need to loop through the result set, like:
while($row = mysql_fetch_array($result)) {
for($i=0; $i mysql_num_fields($result); $i++) {
echo $row[$i];
}
}
You can find more info
Brian,
create table test(id int unsigned);
insert into test values(10);
select 15 - id from test;
The result is 18446744073709551611 instead of -5.
Trying to confirm this with MySQL 4.0.7 on a Win2K box:
mysql create table test(id int unsigned);
Query OK, 0 rows affected (0.56 sec)
Ryan, Eric,
Did u compile PHP with mysql support enabled?as in did your configure
line
have something like this ./configure --with-mysql=/path/to/mysql?
You can test this by writing a file (named whatever you want, I call it
phpinfo.php) with one single line like this:
?=phpinfo()?
Check in
Rob,
If you don't have a PRIMARY KEY and some applications ask for the
PRIMARY KEY in your tables, MySQL will return the first UNIQUE key,
How does any application ask for the PRIMARY KEY? Is this an
ODBC call, or are their command line and built-in functions? I
couldn't find this in the
http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Rob Pecherer [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Sent: Saturday, January 18, 2003 7:57 PM
Subject: RE: PRIMARY KEY
Cesar,
your PHP problem is here:
$query1 = SELECT * FROM r2k_admin WHERE adminuser = $user;
It's supposed to be WHERE adminuser = '$user' , because $user is a
string.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
Neil,
GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY
'testPass';
FLUSH PRIVILEGES;
I then tried to access the databse via the command-line client:
/usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter
And I get this error:
ERROR 1045: Access denied for user:
Michael,
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an
fgNumber
field and currently has no data.
I'd like to add all 944 fgNumbers to the categoryRelatedToProducts
table.
INSERT INTO
Haisam,
I want to insert into content an entire text document. How do I do
that without
puting the entire content into a variable, let's say in perl, and then
writing the
INSERT statement.
In MySQL, you have the LOAD_FILE() function to do this:
Vicente,
the language on this list is English. I will try to answer your
question, anyway.
The patch you're speaking of is no patch, but another table handler in
MySQL. Native tables are MyISAM, and MySQL has a number of alternative
tables it can handle. One of them is InnoDB. In MySQL, you can
Ahmed,
1. How can i trigger a database archive when a certain data base limit
is reached in a table.
Ex: when 1,00,000 records is reached, archive to file and clean table.
You will have to wait for MySQL 5.0. This version will have SQL
triggers.
2. How can i restore multiple files into
: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 13, 2003 2:55 PM
Subject: re: Re: MySQL 4.0.7-gamma: Bugs affecting the privilege system
On Wednesday 08 January 2003 22:32, Stefan Hinz iConnect \(Berlin\)
wrote:
Have you tried to reproduce them?
Bug #1
Maximo,
My company's website is running version 3.23.53a, and the main client
that
uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in
PHP? Although this manual entry is talking about the C API functions,
I
assume PHP uses these to communicated with MySQL. Perhaps I might be
Ed,
That would work but is there no way to completely remove their
record?
With REVOKE, you can partially or totally revoke privileges from users.
What you can't do with REVOKE (in MySQL) is to erase a user completely.
For this, you will have to DELETE FROM mysql.user WHERE User =
Herbert,
Using MySQL, I have a problem where I am attempting to upload a 16.4MB
file
into a BLOB field, but the insert fails with a
ERROR 1030: Got error 139 from table handler
BLOB can store data up to 64 KB only. Use MEDIUMBLOB (up to 16 MB) or
LONGBLOB (up to 4 GB).
For MEDIUMBLOB, be
Christopher,
030111 13:41:11 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
Did you run the install_db script? If not, MySQL can't find the grant
tables.
See http://www.mysql.com/doc/en/Post-installation.html for details.
Regards,
--
Stefan Hinz [EMAIL
,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED];
[EMAIL
Dirkjan,
I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
encountered a
weird problem: when trying to ALTER a TABLE, MySQL said that it no
permissions to rename the *.myi file for that table.
Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
neither on Win98,
30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 3:37 AM
Subject: Re: Copying MySql database to others
Thanks everyone for your input
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Octavian
Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:49 AM
Subject: Re: Resetting the auto_increment to start from 1
At 20:39 +0100 1/8/03, Stefan
Message -
From: Jennifer Goodie [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Charles
Mabbott [EMAIL PROTECTED]; 'Prathmesh J. Mahidharia'
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 11:21 PM
Subject: RE: Re: Load local data infile problem
Nick,
CREATE DATABASE LookAtMe;
the database is created but as:
lookatme
This is not a bug, but a feature. By default, MySQL 4.0.x has
lower_case_table_names set to 1. If you want to change this behaviour,
put this in the [mysqld] section of your c:\my.cnf or c:\winnt\my.ini
file, and restart
Dmitry,
MySQL server segmentation faults when remote mysql client
tries to connect on source and binary distributions. Local
client connect does not cause any problems whatsoever.
I had the same sort of problem with MySQL 3.23.5x servers on SuSE Linux
8.0/8.1, and some newsgroup postings
GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Charles
Mabbott [EMAIL PROTECTED]; 'Prathmesh J. Mahidharia'
[EMAIL
PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Charles Mabbott [EMAIL PROTECTED]
To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED];
'Prathmesh J
Octavian,
I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
DELETE FROM tbl_name WHERE 1 0;
In MySQL 3.23, this was a workaround to force the server to delete a
table row by row. By default, 3.23 would on DELETE FROM tbl
: RE: MySQL 4.0.7-gamma: Bugs affecting the privilege system
Hi Stefan,
-Original Message-
From: Stefan Hinz, iConnect (Berlin)
Alexander,
- After having set up both machines completely, I installed
the Win32 binary distribution of MySQL 4.0.7-gamma. Although
I did
Frank,
I need to copy a MySql Production database to QA. What is the best
method of
doing this? Do I need to write SQL queries or is there another
quicker method?
There are alot of possibilities to accomplish this fast.
From the command line?
shell mysqldump -uusername -ppassword
Prathmesh,
I have just installed mysql and am facing problems with the
Load data local infile problem. I went through the manual and did
all that was said like including the command
--enable-local-infile and --local-infile[=1], but it does not
seem to work.
I posted the same problem a
Richard,
I agree with the post... I feel there should be an inbuilt backup
routine.
AFAIK there's going to be a hot backup routine build into MySQL 4.1. At
this moment, my net connection has gone done, but you should find it at
http://www.mysql.com/doc/en/News-4.1.0.html.
Regards,
--
Stefan
Paul, Dave,
If I understood the initial question correctly, your first suggestion
is not
what he wants. I think he's talking about accessing two servers from
the same
connection, which is not possible:
[snip]
You can't write a SQL statement that refers to tables hosted by
another server.
Rob,
as Jennifer stated, the problem is that your query doesn't use indexes.
SELECT something to select FROM table1 LEFT JOIN table2 ON
(table1.ID =
table2.table1_ID) WHERE some condition;
some condition would be of interest here. If MySQL can't use indexes
here, it will have to scan all of
Francesco,
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is
better.
Most probably. I had problems like that with 4.0.3 and 4.0.4, but not
yet with 4.0.7 (all under
1 - 100 of 158 matches
Mail list logo