I added those line to the slave's my.cnf and mysql would not start
replicate-wild-ignore-table=parallax%.watchdog%
replicate-wild-ignore-table=parallax%.cache%
Nestor
On Thu, Dec 6, 2012 at 4:39 PM, Néstor wrote:
> HI Igor,
>
> Are you saying to add these lines to the my.cnf fil
rror...
I do not see how replication works so well for others if I am using the
steps in the link
on top of this message.
THANKS!!!
On Wed, Dec 5, 2012 at 3:42 AM, Manuel Arostegui wrote:
>
>
> 2012/11/30 Néstor
>
>> I am trying to set up mysql replication on 2 systems but Once
I was about to reply with a long message of all the steps I followed to
create replication but I did my steps about an hour ago and I have not
seen the replication fail so far.
BTW, I created my replication following the info on this web page:
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-u
aborted. Fix
the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'mysql-bin.000265' position 99451408
I done searches on google and I look at several sites and basically they
say to do the following:
mysql> stop slave;
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql> start slave;
mysql> show slave status\G
But after doing this a couple of minutes later I get the same situation
I have re-installed the database on the slave also to see if this fixes the
problem
but after a few minutes I get the same error. I have repeated the
replication from the
beginning but I get the same problem after a while.
Does anyone know a way to fix this?
Thanks,
Néstor
Is 26K Euros enought money to live in Europe?
On Thu, Oct 27, 2011 at 8:14 AM, Garcia, Monica wrote:
> Hello people,
>
> We are looking for a MySQL DBA, based in Malaga (Spain). If you have
> 5+ years experience administering MySQL and you are interested in join
> an international company, plea
I did not see any messages about $20
Maybe the sender sent it to you only.
Again, you got angry, take breath and ask your questions anytime.
:-)
On Wed, May 4, 2011 at 2:13 PM, Akachi Pictures wrote:
>
> No, not offended at all! Trust me, i'd much rather get no responses than a
> rather insult
Calm down,
There a many tutorials online. You do not need a tutor because when you ask
a
question here you will get many responses. You will get everyone here to
help you.
Start asking.
Good luck,
Nestor :-)
On Wed, May 4, 2011 at 12:54 PM, Akachi Pictures wrote:
>
> GUYS. I NEVER ASKE
I have an sql file that I dump(mysqldump) and then I installed on a new
system and some how
the dashes on the file were changed to some wierd character.
When I look at the sql file in my windows machine using PUTTY
I get stuff like "1.01.A â the second"
When I look at the same file from my linux
I tried this but when I upload the backup it just does not look the same.
Thanks,
Nestor :-
On Mon, Sep 14, 2009 at 8:04 AM, wrote:
> Use sqlyog its a freeware
> Sent from my BlackBerry® on Reliance Mobile, India's No. 1 Network. Go for
> it!
>
> -Original Message
I did it again and using sqlyog did work.
I also found out that the tool that comes with mysql admin 1.1 also has
a backup tool that works.
Thanks to all,
Nestor :-)
On Mon, Sep 14, 2009 at 9:16 AM, Néstor wrote:
> Sorry, I meant to say that the backup DB does not look the same as
Sorry, I meant to say that the backup DB does not look the same as the
original DB.
Maybe it has to do with what Todd and Mychael mentioned.
The percona tool does not work on Windows OS. I could not find a windows
executable.
Thanks,
Nestor :-)
On Mon, Sep 14, 2009 at 9:13 AM, Néstor wrote
Maybe one of you experts know the answer.
I have a Innodb database that I want to back up. Is there a free tool to
do this?
mysqlhotbackup is a paid tool, is that the only one available?
If I do a mysqldump of the innodb databse, will I be avail to uploaded into
a myisam
database and will it wo
ell. 4. Restart mysql
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: Néstor [mailto:rot...@gmail.com]
> Sent: Thursday, September 10, 2009 11:28 AM
> To: mysql@lists.mysql.com
> Subject: DB/table problem
>
> I am running mysql 5.0 on a windows 20
I am running mysql 5.0 on a windows 2003 host with php and apache
I am trying to restore a database from 08/28/2009. The backup is done by
windows and all I do is copy the "data/scroller612" folder to the DATA
folder in the MYSQL directory.
when I restore/copy it I get the following errors my .e
It will great if the MYSQL guys were to buy mysql from Oracle for half the
price that Sun paid.
They would come out making lots of money and back controlling their own
destiny.
:-)
On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller wrote:
> I hereby bet the farm that this shall not occur. I have $1
Am I totally missing something? Why do you believe the two queries should
> return the same # of rows? First one has a qualification of proj_adv_date <
> '2008-12-16' whilst the second one does not...
>
> On Mon, Dec 15, 2008 at 12:12 PM, Néstor wrote:
>
> > I have
I have a char fiel where I am keeping dates formatted as year-month-day
(2006-10-09)
Now I am trying to find all the records between 2 strings (2 dates). The
2 queries below
should return the same number of records by they do not.
My query is this:
SELECT COUNT(*) FROM proj where proj_archive=0
by following the process explained on the links.
Take care,
Néstor :-)
On Mon, Apr 7, 2008 at 11:44 AM, Kaushal Shriyan <[EMAIL PROTECTED]>
wrote:
> On Tue, Apr 8, 2008 at 12:02 AM, Néstor <[EMAIL PROTECTED]> wrote:
>
> > Kaushal,
> >
> > That worked. I f
-masterslave-replication-in-mysql-centos-rhel-fedora/
2) Master/Master replication
http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/
Thanks,
Néstor :-)
On Sun, Apr 6, 2008 at 11:28 PM, Kaushal Shriyan <[EMAIL PROTECTED]>
wrote:
&g
Kaushal,
I will try it tomorrow to see if it works. It is similar to something I
tried
a couple of weeks ago and it work but when I changed the ip address it stop
working.
I will try this tomorrow and let you know.
Néstor :-)
On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan <[EM
YEs, both of MySQL are running on each system.
Show status display a big long list of items, any specific?
uptime is 3239 on 10.100.1.170
uptime is 3353 on 10.100.1.171
Thanks,
Néstor :-)
On Tue, Apr 1, 2008 at 3:46 PM, Srini <[EMAIL PROTECTED]> wrote:
> is your mysql running on t
query' errno: 2013 retry-time: 60 retries: 86400
HELP!
Thanks,
Néstor :-)
Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor <[EMAIL PROTECTED]> wrote:
> You guys are correct, that i
top 5 values within each array.
Thanks,
Nestor :-)
On 11/6/07, Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote:
>
>
> --- [EMAIL PROTECTED] wrote:
>
> > Néstor wrote:
>
> >
> > I think you'd best begin by normalising your
> > database. Something alo
Sanchez Vela <[EMAIL PROTECTED]> wrote:
>
>
> --- Néstor <[EMAIL PROTECTED]> wrote:
>
> > I can do simple select statements but I need your
> > brains to create query
> > statment.
> > I am using mysql 4.0 in my 1and1 site.
> >
> > I have a ta
I have a table with about 9 fields, and record ID field an
agency name field and the # of gallons that a erson pledges to save:
--
|ID| agency| 5g | 8g | 10g | 12g | 15g | 18g | 20g |
---
I need to come out with top 5 *tips *per agency
|Helix | 8g = 2 | 10g = 2 | 15g = 2 | 8g = 2 | 40g = 2|
|Corp| 8g = 1 | 12g = 1 | 15g= 1 |
Is there an easy way to do this?
I hope I made myself understood.
Thanks,
Néstor :-)
mysql_num_rows()
http://www.php.net/manual/en/ref.mysql.php
:-)
On 9/15/07, Chris W <[EMAIL PROTECTED]> wrote:
> Mahmoud Badreddine wrote:
> > it is more of a PHP question , I admit.
> > I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result.
> > And I am sure there's more than z
Can you explain what each of those lines do?
Thanks,
Nestor
PS
Great work on the mysql article
On 6/4/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
Thanks for the magazine. I already incorporated a little extra SQL
injection checking into my db.inc.php wrapper...
//[dv] added to remove
That was interesting. I have 2 rhel 3 servers and they both have been
update to handle the DST. They both yield different results when I ran the
command:
SERVER=RALPH
+---+---+
| UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_
edit my table and convert all my fields to -MM-DD
before I can sort it.
Any help is welcome.
Thanks,
Néstor :-)
31 matches
Mail list logo
