Hi,
I've installed MySQL 4.1.10 and phpMyAdmin-2.6.4-rc1 on a RHEL4 box.
And I found that phpMyAdmin forces the character set of pages utf-8.
Though I knew that phpMyAdmin-2.5.7 can work well with gb2312, I want
to make phpMyAdmin work well too.
Anybody knows that how to make phpMyAdmin work with
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written by perl what could replace the shell
script(/mysql-test/mysql-test-run
Hi Listers,
Does anybody know if the MyISAM engine (apart from InnoDB) allows the
use of raw disk space rather than having cooked files? If not, is this
feature likely to be included in a future release? I had a quick scour
of the MySQL website but can't seem to find a page with upcoming
features
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts & digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control a
The lists are managed using ezmlm-idx (http://www.ezmlm.org/). The
subscription lists are kept in a MySQL database, the message archives
are simply kept in the filesystem, the index of messages used by the
news server and web archive are kept in MySQL, and the search index is
kept in MySQL.
Th
Hi Doug,
Thanks for the reply.
That is more or less what I was thinking too. (especially the ANT rant ;-)
I would be looking forward to read the paper in case its published one day.
Best regards
Nils Valentin
Tokyo / Japan
http://www.be-known-online.com
Quoting "Douglas K. Fischer" <[EMAIL PRO
Bruno Cochofel wrote:
From http://www.mysqlusers.com/msg/37105.html we have:
<>Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR 'some_user'@'so
>From http://www.mysqlusers.com/msg/37105.html we have:
<>Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD(
Jonathan,
http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html
"
innodb_open_files
This option is relevant only if you use multiple tablespaces in InnoDB. It
specifies the maximum number of .ibd files that InnoDB can keep open at one
time. The minimum value is 10. The default is 300.
The fi
Bruno Cochofel wrote:
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection
Hi all,
I use MYSQL, it is good, I like it. But when comes to big tables, and
fulltext, it is really slow. I have in table up to 100millions rows,
and 1 querry fulltext (limit 5) last 5-200 seconds.
I use it on FreeBSD, I look for something better, thinking about
Firebird or Postgre. Could you gi
Hi,
I have mysql 4.1.14 on solaris 9 and have just switched to using the
innodb_file_per_table option. Previously I was using MyISAM tables and
created about 700 tables.
The rlim_fd_cur and rlim_fd_max kernel paramteres are set to 256.
I'm getting an error from innodb that it is running out
That was an excellent reply, I always see you helping so many people, keep
the great work going ..
Sincerely,
Kishore Jalleda
On 10/13/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Kishore Jalleda <[EMAIL PROTECTED]> wrote on 10/13/2005 02:25:52 PM:
>
> > Hi All,
> > I have a query wh
Kishore Jalleda <[EMAIL PROTECTED]> wrote on 10/13/2005 02:25:52 PM:
> Hi All,
> I have a query which takes approximately 0.5 seconds to execute , it is
as
> follows
> SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
> gamesessions AS gamesessions
> WHERE valid=1 AND sessiont
Gerald Taylor <[EMAIL PROTECTED]> wrote on 10/13/2005 12:20:53 PM:
> SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid
> FROM pmdata pmd, mnames pm, pmdata mypmd
> WHERE mypmd.uid= ?
> AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid
> AND pmd.uid != mypmd.uid GROUP BY pmd.pmid
Hi All,
I have a query which takes approximately 0.5 seconds to execute , it is as
follows
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
WHERE valid=1 AND sessiontype IN (1,2)
GROUP BY gamename;
EXPLAIN SELECT gives me this, also there is an ind
SELECT avg(abs(pmd.value) - (mypmd.value))) as diff, pm.mname, pmd.uid
FROM pmdata pmd, mnames pm, pmdata mypmd
WHERE mypmd.uid= ?
AND pmd.pmid=pm.pmid AND mypmd.pmid=pm.pmid
AND pmd.uid != mypmd.uid GROUP BY pmd.pmid, pmd.uid ORDER BY pmd.uid
What I would like also to return in this query is a
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection solution to MySQL 4.x..
[EMAIL PROTECTED] wrote:
>>> speculating about that IMO.
>>
> What Oracle will do with Innobase is Oracle's matter, not much use in
>
> Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
> how the
> environment around Innobase / Innodb will change - and with it any
> support
>
(response bottom-posted)
"Ed Reed" <[EMAIL PROTECTED]> wrote on 10/13/2005 12:36:24 PM:
> Can anyone please help me with this? I'm just not getting it.
>
> - Thanks
>
> >>> "Ed Reed" < [EMAIL PROTECTED] > 10/6/05 2:50:46 PM >>>
> Thanks for the reply,
>
> Sorry; I'm using 4.1.11
>
> Thanks ag
Can anyone please help me with this? I'm just not getting it.
- Thanks
>>> "Ed Reed" < [EMAIL PROTECTED] > 10/6/05 2:50:46 PM >>>
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
>>> Pooly < [EMAIL PROTECTED] > 10/6/05 1:51 AM >>>
2005/10/6, Ed Reed < [EMAIL PROTECTED] >:
> I'm tryi
On Thu, 13 Oct 2005, Peter Brawley wrote:
> Hugh,
>
> Agreed that the MySQL error reporter is primitive, and that 'lint for MySQL'
If I were familiar with the code base I'd happy send patches, but I
was hoping "improve diagnostics" might get nudged up somebody's
list by raising it.
> would be
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
>
> MySQL does not normally use " "(double quotes) as name identifiers, it
> uses ` `(backticks). Change all of your " to ` to make your syntax
> correct. That would mean that part of your original statement will look
> like
Thank you.
>
> In thi
Hugh,
Agreed that the MySQL error reporter is primitive, and that 'lint for
MySQL' would be a smash hit, but if you look up error 1064 you'll find
it is a naming error, two of which are visible in your error
report--column names enclosed in double quotes.
PB
http://www.artfulsoftware.com
--
Hugh Sasse <[EMAIL PROTECTED]> wrote on 10/13/2005 11:27:44 AM:
> I'm fairly new to MySQL and am getting an error messages like:
>
> ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for
> the right syntax to use n
On Thu, 13 Oct 2005, [EMAIL PROTECTED] wrote:
> Hugh Sasse <[EMAIL PROTECTED]> wrote on 13/10/2005 16:27:44:
>
> > I'm fairly new to MySQL and am getting an error messages like:
> >
> > ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
> > check the manual that corresponds to y
It did not work Daniel. I added this into my.cnf file:
[mysqld]
log-bin=/var/log/mysql/binary.log
and saved the file in two places:
/etc/my.cnf
/usr/local/mysql/my.cnf
Then, I restart the server:
sudo /Lybrary/StartupItems/MySQLCOM restart
I also did two UPDATE, one INSERT, and one DELETE, b
Hugh Sasse <[EMAIL PROTECTED]> wrote on 13/10/2005 16:27:44:
> I'm fairly new to MySQL and am getting an error messages like:
>
> ERROR 1064 (42000) at line 5: 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
On Thu, Oct 13, 2005 at 02:34:00PM +0900, Dave wrote:
>I am curious to know if the MySQL mailing list uses MySQL in
> managing the list and it's archives. The articles are surely archived in
> a database, and I would assume that if the MySQL developers were to use
> any database, it would be
When you connect without specifing the host, the mysql client will try to
connect using the mysql socket file (usually /tmp/mysql.sock
or /var/lib/mysql/mysql.sock) and when you specify the IP address it will try
to connect using a TCP connection to port 3306.
My guess is the you have name loo
I'm fairly new to MySQL and am getting an error messages like:
ERROR 1064 (42000) at line 5: 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 '"id" int(14) unsigned NOT NULL auto_increment,
"forename" varchar(
What Oracle will do with Innobase is Oracle's matter, not much use in
speculating about that IMO.
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED how the
environment around Innobase / Innodb will change - and with it any support
options and other impacts that might have
I'm using the default Fedora Core 4 Linux mysql RPM package... I just create
x509 certificates and modify the /etc/my.cnf file to use these certificates.
The default mysqld init script doesn't work in its "normal' location, just
moving it to a different folder make it works. MySQL daemon runs by th
Well I've done more than that I wrote a custom init script with the simplest
possible start function containig just the following line:
/usr/bin/mysqld_safe &
and SSL does not work eather... please help...
best regards
Israel
-- Forwarded message --
From: RedRed!com IT Departmen
Hi !
lu ming wrote:
The test system that is included in MySQL Server's Unix source
distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to
run a test against to the MySQL Server. But these tests only can be run
on Unix(linux). If you want to run the tests on Windows, you must
A little more information:
If I use --skip-name-resolve then I get an odd error:
ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using
password: YES)
This seems to suggest that MySQL thinks my client is from '0.0.0.0' and
hence cannot match any GRANT syntax I use. Why would MySQL
AS JIGAL SAID :
make sure you are not creating an INSERT statement bigger than the
max_allowed_packet setting for both your destination server and your
client library (whichever ones you are using). If you attempt to create a
packet that is too large, the server will _ignore_ it. Because the pa
Francesco R. wrote:
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
On linux there is "dbf2mysql"
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import t
Hi folk!
I'm new to mysql and to databases...
I'm using Fedora Core 4 with mysql 4.1.11-2 I need some application clients
to connect the server using SSL connections. I've created and tested x509
certificates using the way mysql documentation explain, I've modified the
/etc/my.cnf [mysqld] and [cl
thanx for the reply , usually , i uploading jpg and gif files into mysql
database , there is no any issue. we can display them correctly.
when i try to upload such huge mp3 files and some .jar files into the databse ,
i used mysqlcc GUI and SQLYOG GUI , from those interfaces also giving
trouble
Dear MySQL,
A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign server 'pho.com' with IP of '192.168.1.1', I
should be able to GRANT using either:
mysql> GRANT all ON test.* TO test@'192.168.%' IDENTIFIED BY 'test';
mysql> GRANT all ON test.* TO t
Peter Brawley <[EMAIL PROTECTED]> wrote on 10/12/2005 04:27:18
PM:
> James,
>
> Both ...
>
> SELECT ...
> FROM a, b LEFT JOIN c ON a.x=c.y
>
> and
>
> SELECT ...
> FROM a
> LEFT JOIN B USING (x )
> LEFT JOIN c ON a.x=c.y
>
> work up to and including version 5.0.10, not in 5.
Hi Guy,
Use SHOW INNODB STATUS and check foreign key error at there
Good luck
Guy Brom wrote:
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang`
as foreign (
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you u
I have the following innoDb tables:
country has `id` as PK
lang has `id` as PK
I want to have a 3rd innoDb table:
countrylang with `cid,lang` as compound key with both `cid` and `lang` as
foreign (cascade-delete) keys to the "master" tables.
However mysql throws error (Cannot create table..) w
Ananda Kumar wrote:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
The short answer: not.
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html
lists the variables you can change by the SET GLOBAL or SET SESSION
command. 'date_forma
Hi List,
When I am trying to connect to mysql 4.0.20 database it is taking very long
time when I specified host like
Mysql -ux -p -h192.168.3.111
But it is connecting very quickly when I tried like below
Mysql -ux -p
It is an urgent issue. Please help me.
Thanks
hi ,
I have crerated a mysql database to store images , mp3 , video files..etc. In
my first stage i stored images as jpg , gif .
But when i try to store little but huge gif files it wont store . I used the
script as follows to upload images,
Upload File To MySQL Database