Kaushal,
Do a flush logs when you do full backup , And copy your Binary log files
( After Full Backup ) for incremental .
Correct me if iam wrong .
--
Praj
Kaushal Shriyan wrote:
Hi ALL
Can we have incremental backup of MySQL Database and if its there How
do we do it
Thanks and Regards
Kaushal Shriyan wrote:
Hi ALL
Can we have incremental backup of MySQL Database and if its there How
do we do it
Reposting your question again won't change the responses you have
received (it'll actually annoy people more than anything else).
--
MySQL General Mailing List
For list archives:
Hi ALL
Can we have incremental backup of MySQL Database and if its there How
do we do it
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.
==
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
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.
I
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 to
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 multip
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
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
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 tim
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
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 t
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 ech
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 gra
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_f
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 pre
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 ho
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 t
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 t
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
I
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
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 upgra
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 l
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 wr
> -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 i
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
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
data-dir
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.
--
MySQ
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 c
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
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
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 c
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
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 have
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 field...
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 going
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
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 PROT
Hi.
I want to recover the more recent data from a MYISAM/ISAM table. Any idea?
Iago.
> -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
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
> > Subj
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 problem
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 probl
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
> a
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
> -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 kno
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
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 a
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_Clus
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:
Sent: Monday, July 17, 2006 11:21 PM
51 matches
Mail list logo
