On May 12, 2009, at 11:11 PM, Simon J Mudd wrote:
1. Ensure binlogging is enabled on the master.
2. Ensure you setup grant permissions so the slave can connect to
the master.
3. Configure on the slave the replication (which databases need to
be replicated)
4. Get the master and slave in
History (Arrow Up/Down)
COPY: Select (click + drag)PASTE: right click (or middle click)
2009/5/15 jean claude babin babi...@gmail.com
Hello,
I'm pretty new in MySql. I would like to know how you can copy a statement
like
mysql INSERT INTO customers ( firstname, surname, title, phone)
Hi!
blackwater dev wrote:
I have a hold car data such as color, model, make, year, etc. I want to
allow the user to answer some questions and I'll present them with the car
that 'best' matches their criteria. How do I do this? I still want to
return ones that don't match exactly but want
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date is
entered instead of the default null, and this is not good.
Can I do
Hi Octavian,
One approach is to use a trigger,
mysql set sql_mode = '';
mysql create table temp_date(d date default null);
mysql create trigger temp_date_bi before insert on temp_date for each row set
new.d = if(new.d = '-00-00', null, new.d);
mysql insert into temp_date(d)
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date
is entered instead of the default null, and this is not good.
Can I
Agreed. And don't forget to listen to the warnings MySQL sends back,
e.g.:
mysql create table temp_date(d date default null);
Query OK, 0 rows affected (0.15 sec)
mysql insert into temp_date(d) values('2009-13-99');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql show warnings;
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
It is important to understand deeply mysql client access control.
Basically you need only one root account from the localhost for
administration purposes.
Keep in mind that when you login specifying 'localhost' (either by the
-h flag or implicit) MySQL will use the mysql client socket
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni claudio.na...@gmail.com wrote:
I don't know if you are now more ore less confused!
Claudio
I would say less because you basically explained that I need to have
localhost 127.0.0.1.
Now my problem is that no longer have this and would like to know
Exactly, you need as many rows as many combination user/host
we can also say that an account in MySQL is not the username BUT the
username AND host combination.
If you want to duplicate any account (also the root/localhost) do this:
mysql show grants for 'root'@'localhost';
then have fun!
Anyone using this? I'm looking to install it to see how it works. I read in
some of the documentation that it could be used to set up a replication
server and would automatically roll forward using binlogs. I've done
rollforward using binlogs manually before but I was wondering what kind of
I'm running Windows XP and I'd like to capture the SQL commands that are
sent to the MySQL server. Is there a way to do this on Windows?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Turn On General Logging
In my.ini insert this option in the [mysqld] section
log=C:\MySQLLogging.txt
and restart mysql
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype :
14 matches
Mail list logo