Hi All,
I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
Before upgrading, I have like below :
# rpm -qa | grep mysql
mysql-4.1.12-3.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
And after upgrading, I have like below :
#rpm
Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like
Fauzan Azhary wrote:
Hi All,
I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22.
Before upgrading, I have like below :
# rpm -qa | grep mysql
mysql-4.1.12-3.RHEL4.1
mysql-server-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
And after upgrading, I
Hi,
If you have like insert statments try using this as
login into mysql
mysql -u root -p
use database-name
\. /tmp/filename.txt
Thanks Regards
Dilipkumar
- Original Message -
From: Marc Alff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, July 17,
On Thursday 13 July 2006 16:52, Peter Brawley wrote:
Jean-Claude
I agree that LEFT JOIN is probably part of the solution. But the command
you suggest do not work, perhaps because several Chimeric_Cluster_IDs and
Unigene_ID are void or NULL. I want a list of AC from
Chimeric_Cluster_IDs
I have local mysql 5.0 and I have developed an arabic site. The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has mysql 4.1 and
as I restored the database there, some special arabic character
Hello,
I am having a problem, and am hoping this is the wright list to post to.
I have a TEXT field with text in them (duh!)... this text also contains
special characters like é ß ü etc...
But when i convert the TEXT field to a BLOB field these signs are lost
and i get �
So does anyone know
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 2:43 AM
To: Dan Trainor
Cc: Kaushal Shriyan; mysql@lists.mysql.com
Subject: Re: Incremental Backup
Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having a problem, and am hoping this is the wright list
to post to.
I have a TEXT field with text in them (duh!)... this text
also contains
special characters like é ß ü etc...
But when i convert the TEXT field to a BLOB
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0 and I have developed an arabic site.
The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has
mysql 4.1 and
as I
From: Mike van Hoof Sent: 18 July 2006 12:18
To: Addison, Mark
Subject: Re: Converting TEXT to BLOB with special chars
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having a problem, and am
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 12:18
To: Addison, Mark
Subject: Re: Converting TEXT to BLOB with special chars
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having a
On 7/18/06, Kaushal Shriyan [EMAIL PROTECTED] wrote:
On 7/18/06, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 2:43 AM
To: Dan Trainor
Cc: Kaushal Shriyan; mysql@lists.mysql.com
Subject: Re:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0 and I have
Hi.
I want to recover the more recent data from a MYISAM/ISAM table. Any idea?
Iago.
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
-Original Message-
From: Kaushal Shriyan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 7:45 AM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Incremental Backup
On 7/18/06, Kaushal Shriyan [EMAIL PROTECTED]
Amir Bukhari wrote:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but
we got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field... but i think i am
Chris Sansom schreef:
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but we
got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG
hello
I would like to upgrade from 4.1.7 to 4.1.20 on Solaris 2.9. I have
looked at the upgrade section of the doc. But I can only see upgrade
from 4.0 to 4.1.
In the lists and forum, I have seen people doing the almost same upgrade
(4.1.x to 4.1.y) having problems.
My question is : do I
I found the solution in my case.
I just copy libmysql.dll from the php folder do \windows\system32 folder and
everything works fine.
Kay C. Tien [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Hi All,
The simple script I'm testing works on a Linux server. I got tired
of
At 14:16 +0200 18/7/06, Mike van Hoof wrote:
And for the everything in utf8... will try this next time i get this
kind of a problem...
When you do, you'll need to send out the proper header from your php scripts:
header ('Content-type: text/html; charset=UTF-8');
and put this in your MySQL
Hi,
I have a strange problem. I am running mysqld (5.0.20) on NetBSD 3.0 and
after the startup scripts are complete the mysqld process ramps up to
100% utilization. However this only happens if I make mysql calls from
within the startup scripts.
If I wait until the startup scripts have completed
I'm about to re-create a mulit master replication setup that was
dismantled during server hardware/software upgrades.
Replication setup:
A - B - A
|
C
One thing I can't remember is do I have to set an option somewhere to
tell the masters to ignore the queries in the binlog that
On 7/18/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I want to recover the more recent data from a MYISAM/ISAM table. Any idea?
Yeah, backups. Other than that, only complicated or expensive methods
can recover data directly from the disk (but it all depends on your
filesystem and OS). You
Replication setup:
A - B - A
|
C
One thing I can't remember is do I have to set an option somewhere to
tell the masters to ignore the queries in the binlog that oringated from
them?
Make sure you set different Server IDs on each machine and you should be
just fine.
--
MySQL
My question is : do I have to follow the upgrade procedure from 4.0 to
4.1 or can I juste installed the new binaries? We are not ready yet for
the version 5.
As always when upgrading: Make sure you have a backup :)
Then install the new version and move (copy if you have the space) the
On Tuesday 18 July 2006 16:08, Dominik Klein wrote:
My question is : do I have to follow the upgrade procedure from 4.0 to
4.1 or can I juste installed the new binaries? We are not ready yet for
the version 5.
As always when upgrading: Make sure you have a backup :)
This becomes a pain
-Original Message-
From: Dominik Klein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 11:06
To: mysql@lists.mysql.com
Subject: Re: Multi master replication question
Replication setup:
A - B - A
|
C
One thing I can't remember is do I have to set an
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock privilege tables: Table 'mysql.host' doesn't
exist
What am I doing
On Tuesday 18 July 2006 08:23 am, Calselli, Fabrizio WI wrote:
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock
On 7/18/06, Duncan Hill [EMAIL PROTECTED] wrote:
On Tuesday 18 July 2006 16:08, Dominik Klein wrote:
My question is : do I have to follow the upgrade procedure from 4.0 to
4.1 or can I juste installed the new binaries? We are not ready yet for
the version 5.
As always when upgrading:
On 7/18/06, Tim Lucia [EMAIL PROTECTED] wrote:
-Original Message-
From: Obed Soto Déctor [mailto:[EMAIL PROTECTED]
Sent: Monday, July 17, 2006 7:28 PM
To: mysql@lists.mysql.com
Subject: problem with double data
Hi, i'm sorry for my english, i'm from México and i'm gonna do my
I have that copied in there. Even tried a
different version from the most recent MySQL
download. Still getting the same error -
PHP Warning: PHP Startup: Unable to load dynamic
library 'C:\WINDOWS\SYSTEM32\php_mysql.dll' - The
specified procedure could not be found. in Unknown on line 0
the below query worked great in mysql 3.23, but we just moved to 5.0 and it
broke, i can see that the join rules changed in 5.0, but i can't get the
right syntax to make this query work. any help would be appreciated.
On 6/28/06, Peter Brawley [EMAIL PROTECTED] wrote:
Tanner
I am trying to
I actually solved my own problem...
SELECT t1.item_id, t1.dt, t1.text ,t3.*
FROM table AS t1, table3 as t3
LEFT JOIN table AS t2 ON t1.item_id = t2.item_id AND t1.dt t2.dt
WHERE t2.item_id IS NULL;
becomes
SELECT t1.item_id, t1.dt, t1.text
FROM (table AS t1, table3 as t3)
LEFT JOIN table AS
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect(localhost, george_full, passwd) or die
(formatSQLError());
george_full has full priveleges on localhost with his password.
localhost resolves to 127.0.0.1 using the host
Is it possible to have general query type logging on just a specific
database or table? I don't want all queries to all databases, I just
need a log of accesses to a specific table. I figure I can use stored
procedures or a separate mysql instance as a workaround if I need to,
but would
On 7/18/06, Steve Strong [EMAIL PROTECTED] wrote:
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect(localhost, george_full, passwd) or die
(formatSQLError());
That's the only line of your .php script?
george_full has
Normally I try to be as descriptive as possible with subject lines but.. not
quite sure what else to call it.
So basically, I was given ALL access by our sysadmin to a particular database.
Now, somehow I was able to create a database and use it! It's my
understanding that there is nothing
here is the entire function:
function readonlyConnect()
{
$dbh=mysql_connect (localhost, george_readonly, tiWhs!asAt!) or
die (formatSQLError());
mysql_select_db (george_crwash2);
return $dbh;
}
a die() statment before the first line of code in this function echos to
the
Tanner Postert wrote:
I actually solved my own problem...
SELECT t1.item_id, t1.dt, t1.text ,t3.*
FROM table AS t1, table3 as t3
LEFT JOIN table AS t2 ON t1.item_id = t2.item_id AND t1.dt t2.dt
WHERE t2.item_id IS NULL;
becomes
SELECT t1.item_id, t1.dt, t1.text
FROM (table AS t1, table3 as
Steve Strong wrote:
we are using php to connect to our mysql database and when we call the
php function with this line:
$dbh = mysql_connect(localhost, george_full, passwd) or die
(formatSQLError());
george_full has full priveleges on localhost with his password.
localhost resolves to
Martin Jespersen wrote:
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was a bit of a bother to me since i have tons
of users defined in my grant tables.
Dan Buettner wrote:
Dan, I wouldn't bother with the intermediate steps (4.0, 4.1) . Waste
of
Using dumps are almost always the way to go, upgrading the datafiles
themselves is something you should avoid unless you are into heavy
wizardry and/or pain.
Dan Trainor wrote:
Martin Jespersen wrote:
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was
Dan T -
Well, if all your data files are MyISAM, then I only see one potential
problem, and that is the area of user permissions. I believe that
things in that area have changed around enough that if you simply
re-use those tables as-is (as-are?), you may have some difficulties.
All your other
I use MySQL version 4.1.18 with redhat-linux-gnu
(i686). I have created a InnoDB database consisting of
210 GB ibdata files. I used InnoDB to allocate more
memory and speed up the load. I want use it for
read-only purpose and it works fine with one MySQL
server instance.
I am trying to run
David Felio wrote:
Is it possible to have general query type logging on just a specific
database or table? I don't want all queries to all databases, I just
need a log of accesses to a specific table. I figure I can use stored
procedures or a separate mysql instance as a workaround if I need
pradhuman jhala wrote:
I use MySQL version 4.1.18 with redhat-linux-gnu
(i686). I have created a InnoDB database consisting of
210 GB ibdata files. I used InnoDB to allocate more
memory and speed up the load. I want use it for
read-only purpose and it works fine with one MySQL
server instance.
On 7/13/06, Dan Trainor [EMAIL PROTECTED] wrote:
Martin Jespersen wrote:
Dan has a very good point, be mindfull of the changed password
algorithm, that actually was a bit of a bother to me since i have tons
of users defined in my grant tables.
Dan Buettner wrote:
Dan, I wouldn't bother
Hey Gang.
I wanted to get this out on the list and facilitate some feedback.
http://www.feedblog.org/2006/07/announce_lbpool.html
I CC'd both lists because this might be of interest to the larger MySQL
community as the techniques I used here could be implemented in other
languages.
==
51 matches
Mail list logo