I just used mysqldiff for a project, and was successful.
-Original Message-
From: Uma Bhat [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 7:51 PM
To: Andy Shellam; mysql@lists.mysql.com
Subject: Re: Any easier way to compare mysql schema of 50 databases?!
Thank you all, guys!!
Hi,
One of our previous developers decided to obfuscate some columns via the mysql
encode and decode functions. This was done on a 4.x server. Recently, we
converted to a 5.x server, and some of the fields in the rows will not decode
correctly, and I cannot figure out why.
My first thought w
Hi,
Each night I replicate a server running a 4.1 version of mysql via
mysqldump and then import to a box running a 5.0.18-standard. It has
been working well for some four or five months. Suddenly, the job
started failing during the import. After stepping through the job, I
determined that atte
tion
> > I am tring to use seperate forms for dataentry. Thanks again
> > CPK
> > On 7/3/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
>
> Contrary to the advice given on working with MS Access, I've found
that
> I can *only* get things to work with Access 2
> -Original Message-
> From: Jesse [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 12, 2006 1:48 PM
> To: MySQL List
> Subject: Unknown tables
>
> When I do a SHOW TABLES in MySQL, it shows me a list of tables. But
when
> I
> try to do a "select * from countries", I get the error ERROR 1
> -Original Message-
> From: Daniel da Veiga [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 08, 2006 1:55 PM
> To: mysql@lists.mysql.com
> Subject: Re: Backups with MySQL/InnoDB
>
> On 5/8/06, David Hillman <[EMAIL PROTECTED]> wrote:
> > On May 7, 2006, at 11:29 PM, Robert DiFalco wrote:
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 05, 2006 2:37 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: blank user names in user table
>
> Rich,
>
> anonymous access means that '
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 05, 2006 3:00 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: mysqlmanager logging?
>
> su - mysql
> touch /var/lib/mysql/mysqlmanager.log
>
>
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 04, 2006 3:12 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: mysqlmanager logging?
>
> Can the program write to /var/lib/mysql/mysqlmanager.lo
Hi all,
I've got a database I recently inherited where there are a number of
records in the mysql.user table that have no user id. According to the
mysql docs, this is supposed to allow guest access, and there is mention
of how to turn it off.
How does one actually connect in guest mode? My att
> > but you don't know __when__ innodb_file_per_table was set!
> > So it's possible that many innodb tables actually reside in ibdata
> > [1-4].
> > Check your data directory to see the individual innodb files/tables
> > (*.ibd).
>
> This is true, and even on a fresh install that has always had
Hi all,
I've inherited an innodb database that is configured like:
innodb_file_per_table
innodb_data_file_path =
ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend
Um, doesn't this allocate 12G that winds up being unused, since
innodb_file_per_table is set? If so, what is the co
Hi all,
This query works fine on a 4.1 server, but not a 5.0 server:
Select *
from
agentrelationships, agents as a2
left outer join agents
on
agentrelationships.agentidparent = agents.agentid
where
agentrelationships.agentidchild = a2.agentid
On a 5.0 server, I receive 'unknown co
MySQL 5.0.20
I've got two instances running with mysqlmanager. I'm not getting any
logging of any sort.
mysqlmanager --help shows:
- -
log /var/lib/mysql/mysqlmanager.log
pid-file
I just did this last week on a 5.0.18 machine. It's supported by the
mysqlmanager out of the box. Here are a copy of my notes, and worked
well on a Suse machine. The locations of your files may not be the
same.
# stop the server, if running
/etc/init.d/mysql stop
# edit /etc/my.cnf to set up t
Interesting. I have never heard of that option.
LX09:/home/rduz/backup # mysql -p -h. --port=3307
Enter password:
ERROR 2005 (HY000): Unknown MySQL server host '.' (1)
Perhaps it no longer functions?
Thanks.
Regards,
Rich
>
--
MySQL General Mailing List
For list archives: http://lists.mysq
Hi all,
I have two servers that have production data on them, and then one
server where I would like to keep an active copy of the data.
Currently, there is a job that runs in the middle of the night that
basically does a
mysqldump --host=production_server --all-databases | mysql
--host=backup
> -Original Message-
> From: Barry [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 13, 2006 9:41 AM
> To: mysql@lists.mysql.com
> Subject: Re: MySql Error Number 1130
>
> Duzenbury, Rich wrote:
> >>localhost means socket.
> >
> >
> &g
> localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would then be mutually exclusive
iew_priv: Y
> Create_routine_priv: Y
>Alter_routine_priv: Y
> Create_user_priv: Y
> ssl_type:
>ssl_cipher:
> x509_issuer:
> x509_subject:
> max_questions: 0
> max_updates: 0
> max_connections: 0
&
Hi all,
I am setting up two additional instances of mysql on my mysql server,
which is running version 5.0.18-standard-log.
I've got the additional instances set up, and they are running. I can
see that they are bound to the proper ports.
I can connect to them locally like
mysql -p --port=330
21 matches
Mail list logo