Sorry forgot to isnert the list email address.
Thanks for your help. I will search prepared statement in the manual. Will
post again if have next/ other questions.
Thanks a lot.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Friday, November 25, 2005 12:18 PM
To: mysq
Hi.
I have a production server that has a whole series of -bin files.
I want to get rid of them because they are consuming too much space.
Can I safely delete them?
Some date back to April of this year.
I've seen the 'PURGE MASTER LOGS TO 'mysql-bin.0XX';'
Thanks for any replies.
Kind regards.
You should not contact people on the MySQL list offline; all communication
should be via the list so that everyone can benefit from the discussion.
As I said earlier, your WHERE clause does not make sense the way you
expressed it in your first email. I explained how it should look in my first
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the simple mysqldump and when we tried to restored the database dump, it just
failed. There is no error as such. The execution of dump command simpl
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the mysqldump and upgraded it to version 5.0. But, when we tried to restored
the database dump, it just cannot restore it back.
We searched on the
Hi,
Need your help in restoring mysqldump from version 4.1 to 5.0
We wanted to update our mysql server from version 4.1.0 to version 5.0, we took
the mysqldump and upgraded it to version 5.0. But, when we tried to restored
the database dump, it just cannot restore it back.
We searched on the
Is your database connection auto-commit? MyISAM commits everything at
once, where InnoDB you can commit whenever you want. You might want to
commit at the end of your batch.
Also, look at your indexes - indexes make selects fast, but slow down
inserts and deletes, and can slow down updates i
Thanks.
On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote:
> Hi Ezra,
>
> I fixed the root user by following the instructions laid out at
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
> .
>
> The root user was somehow corrupted.
>
> I started mysql with the mysqld_safe --
hello, here are my current setttings:
# MySQL Server Instance Configuration File
# --
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
#
Hi Ezra,
I fixed the root user by following the instructions laid out at
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html .
The root user was somehow corrupted.
I started mysql with the mysqld_safe --datadir=/my/new/location ... plus the
other parameters set out in the docs.
Th
Hello.
>From my experience on RH based systems you should install appropriative
rpm (it is php-mysql-5.0.4-10.4 in Fedora, for example).
Sanjay Arora wrote:
> Please help. Newbie running Centos 4.2 with mySQL & PHP (binary RPM
> install) as per versions given below. Getting error in ve
Hello.
It doesn't run on Windows NT 4 and below. See:
http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html
Wolfgang Bogenrieder wrote:
> Hallo,
>
> ich have a problem with
>
> mysql-administrator-1.1.5 and
> mysql-query-browser-1.1.17
>
> r
Hello.
Without seeing at least your configuration it is difficult to say
what's going on. Please, provide your config file.
Andrew stolarz <[EMAIL PROTECTED]> wrote:
>When I do a bulk import into a MyIsam engine database, I can reach about 2-3
>thousand records imported per second.
>
>
How did you accomplish that?
Ezra
On 11/24/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote:
> Thanks Gleb, Ezra.
>
> Fixing the root user was the trick.
>
> I've got it working now.
>
> ~mm
>
>
> On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote:
> >
> > Did you set the permissions on the new datad
Thanks Gleb, Ezra.
Fixing the root user was the trick.
I've got it working now.
~mm
On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote:
>
> Did you set the permissions on the new datadir?
>
> Ezra
>
> On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote:
> > Hi,
> > I'm on Solaris 9 with mysql
Hello.
I have a similar issue on FreeBSD, which I've solved by increasing
the open-files-limit. Follow recomendations from:
http://dev.mysql.com/doc/refman/5.0/en/not-enough-file-handles.html
I needed to increase the system limits as well (kern.maxfilesperproc
sysctl variable).
Hello.
Complete answer about licensing policy you can
obtain only from [EMAIL PROTECTED] It means,
that you should forward you message to this address.
George Vanev <[EMAIL PROTECTED]> wrote:
>Dear Sirs,
>
>This is my 3rd time I am writing to you.
>May be there is a problem!
>
>
Hello.
I've checked this and found that ANALYZE table really doesn't work, but
OPTIMIZE table made its work. In case it won't help you send to list
complete definitions of you tables and queries.
Allan Miller wrote:
> Hi Gleb,
>
> Thanks for the quick response. Unfortunately, ANALYZE
Hello.
>From my experience in most cases it is recommended to store images
in files.
ESV Media GmbH wrote:
> Hey,
>
> we´ve large amount of Images ( nearly 2 GB ).
> And they will increase, cause or Editors will submit several articles a
> day where they´re allowed to upload
> some ne
Hello.
> Becomes to like varName or varTmp ?
Sorry, but I'm not completely understanding your question
(may be because I'm not familiar with dreamweaver). What
does it mean 'like varName or varTmp'? Do you want to change
the name from reg_one to var_one? Or you want to be able
dynamically
Please help. Newbie running Centos 4.2 with mySQL & PHP (binary RPM
install) as per versions given below. Getting error in vegadns package
(DJB TinyDNS GUI) :
Fatal error: Call to undefined function: mysql_connect()
in /home.www/html/vegadns/src/connect.php
Some diagnostics I ran for info on vers
Did you set the permissions on the new datadir?
Ezra
On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote:
> Hi,
> I'm on Solaris 9 with mysql 4.1.
>
> I've moved the datadir to a new location, and edited the mysql start script
> directly so that it now has the line:
>
> datadir=/export/www1/dat
On 24/11/2005, Alec worte:
> I think this is your problem: MySQL does not properly support Unicode
> until version 4.1. I am successfully using FullText with MySQL 4.1 to sort
> UTF-8 encoded Japanese text. I see no reason why it should not work for
> Arabic - if you upgrade.
Dea
Hi Marco!
I had a similar problem and was advised that the native filesystem is faster
than doing lookups and some sort of rendering. So storing the link in the
db will do it, and then just have the images at the pointed-to location.
Cheers!
-Warren
- Original Message -
From: "ES
Hi Martijn
>I tried that, but in Delphi with the particular component-set I'm
using,
>this raises: mySQL Error Code: (1312)
>PROCEDURE test.p_Select() can't return a result set in the given
context
Ah, you're not the first to have that error message, eg see the
discussions at http://forums.m
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 17:48:29:
> Dear list,
>
> I'm considering programming a simple "Search Engine" for a website,
> to find Arabic/Persian data within a MySQL database.
> This database contains a huge amount of data, encoded with
Unicode(UTF-8).
>
>
Dear list,
I'm considering programming a simple "Search Engine" for a website,
to find Arabic/Persian data within a MySQL database.
This database contains a huge amount of data, encoded with Unicode (UTF-8).
The big deal is to ** reduce the response time ** to end-users.
My f
Dear All
I have a problem with mysql_num_rows
if I execute it on a result returned by mysql_query,,, and that
result is empty then I will get an error saying that this result is not a
valid mysql result
I am using count(*) and checking if my SQL statements will return
more than 0
I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion, what group
Hallo,
ich have a problem with
mysql-administrator-1.1.5 and
mysql-query-browser-1.1.17
running under Windows NT Sp6. Starting the tools I get the error
message, like
"procedure GetFileSizeEx not found in Kernel32.dll". Suppose you have to
define #ifdef NT while compiling, or similar, becau
Hello List,
When I do a bulk import into a MyIsam engine database, I can reach about 2-3
thousand records imported per second.
However when I use the InnoDB engine, I am only importing about 30-50
records per second?
Am I missing something here?
its a P4 3 Ghz machine with 1024mb ram. running M
I have following query:
SELECT SQL_NO_CACHE users.user_name assigned_user_name, accounts.* FROM
accounts LEFT JOIN users ON accounts.assigned_user_id=users.id where
(accounts.assigned_user_id='1') AND accounts.deleted=0 ORDER BY
phone_office asc LIMIT 620300,20
In your opinion, what group
- Original Message -
From: "asus77x" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 24, 2005 2:07 AM
Subject: select command
I have a command :
SELECT * FROM reg_one WHERE 'varName' like 'varTmp' %
This is made within dreamweaver mx.
I think there must be a typo in the statemen
Felix Geerinckx wrote:
On 24/11/2005, Lowell Allen wrote:
but I'm looking for a way to convert the short hash values into
comparable long hash values.
This is (fortunately) *not* possible.
Apparently the upgrade procedure can successfully convert
short-to-long hash values for MySQL user pa
> >CREATE PROCEDURE P_Select()
> >READS SQL DATA
> >begin
> >select * from enum_table;
> >end
> >How would I get a resultset?
>
> No need for an OUT param, just call the sproc, you'll see.
I tried that, but in Delphi with the particular component-set I'm using,
this
raises:
mySQL Error Code:
Martin
>CREATE PROCEDURE P_Select()
>READS SQL DATA
>begin
>select * from enum_table;
>end
>How would I get a resultset?
No need for an OUT param, just call the sproc, you'll see.
PB
-
Martijn Tonies wrote:
Hi there,
I cannot figure out how to use a Stored Procedure that returns a
resu
Thanks i also found the function CAST which works ok.
So now i have three options:
CAST
LPAD
Adding zero
Any other sugestions are welcome!
Quoting [EMAIL PROTECTED]:
> Test USER <[EMAIL PROTECTED]> wrote on 11/23/2005 07:36:43 PM:
>
> > Is the only way to sort numbers stored in a varchar colum
Hi there,
I cannot figure out how to use a Stored Procedure that returns a
resultset and I cannot find it in the documentation.
For example:
CREATE PROCEDURE P_Select()
READS SQL DATA
begin
select * from enum_table;
end
I believe that CALL can only be used for output parameters, correct?
Ho
Hi,
Thanks Again. You are really helping me
Well it get a lot of "query ok, 0 rows affected <0.00 sec>"
And one like this :
query ok, 2 rows affected <0.01 sec>
Records: 2 Duplicates: 0 Warnings: 0
But it look like everything is in the Database now ?
What is this "Source" Comman
Dear George,
THis is a public mailing list, not the MySQL sales channel;-). You may want to
contact MySQL directly.
Their contacts are written at their homepage http://www.mysql.org.
Best regards
Nils Valentin
Quoting George Vanev <[EMAIL PROTECTED]>:
Dear Sirs,
This is my 3rd time I am w
On 24/11/2005, Lowell Allen wrote:
> but I'm looking for a way to convert the short hash values into
> comparable long hash values.
This is (fortunately) *not* possible.
> Apparently the upgrade procedure can successfully convert
> short-to-long hash values for MySQL user passwords
It doesn'
Dear Sirs,
This is my 3rd time I am writing to you.
May be there is a problem!
We want to buy some MySQL 5.0 licenses.
What happens after 1 year expires - do we have to buy another licences or
not?!
Also we want to upgrade from 4.1.18. Do we need a license for this purpose?!
Best Regards
Hey,
we´ve large amount of Images ( nearly 2 GB ).
And they will increase, cause or Editors will submit several articles a
day where they´re allowed to upload
some new pics.
So, whats the better solution ? To store them in the filesystem ( with
only the path in the db )
or to store them as BL
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html
Nathan Gross wrote:
> Hi;
> I have been running this server, 4.1.14 on Linux FC 4 for while, no problem=
> s.
> Yesterday I fiddled with my.cnf via the Administrator console to,
> tried some graphs,
Jeremy Cole wrote:
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
I guess I can ask the obvious question. Why are you trying to use
InnoDB, if your data/filesystem is read only? Why not use MyISAM
inste
45 matches
Mail list logo