I am trying to relocate MySQL and a database to another hard drive on the
same system. According to this page,
http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the
impression that I should be able to do this by copying the data files to the
new MySQL installation. However, th
On Wed, Feb 20, 2008 at 1:51 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
[...]
> In my opinion there is a tremendous shortage of qualified DBAs for
> MySQL. The certification may establish that you have at least a
> baseline of knowledge. If you're looking for a job, you could hardly
> go w
Hi,
On Wed, Feb 20, 2008 at 7:23 PM, Tanner Postert
<[EMAIL PROTECTED]> wrote:
> I have the following table:
> --
> -- Table structure for table 'media'
> --
>
> CREATE TABLE media (
> id int(10) unsigned NOT NULL auto_increment,
> user_id int(10) unsigned default NULL,
> title varchar(2
I have the following table:
--
-- Table structure for table 'media'
--
CREATE TABLE media (
id int(10) unsigned NOT NULL auto_increment,
user_id int(10) unsigned default NULL,
title varchar(255) NOT NULL,
description text NOT NULL,
`hash` varchar(255) NOT NULL,
length float(9,2) NOT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been looking for a way to fake replication from mysql to a local
BDB database. I'm not finding anything. Anybody ever come across this?
It seems like it wouldn't be too terribly difficult to read from the
relay-log and keep track of where you a
The only way you can do it is with KILL. You will be able to see some
of the progress on rollback in SHOW INNODB STATUS. I recommend
innotop for watching this if you wish.
If you see the process's status as Killed in SHOW PROCESSLIST, you
have killed it.
Have a copy of War and Peace at the read
I am feeling more motivated to interrupt this operation now. What would
be an effective way to do that? As a reminder, I submitted this operation
using the GUI administration tool --- specifically the table editor. The
whole tool is unresponsive while this operation is running. I can run and
Hello,
I'm trying to set up SSL for my MySQL server. As my understanding of
SSL is still a bit shaky and the MySQL documentation on the subject a
bit terse, I thought I'd ask a few questions to make sure I haven't
misunderstood anything:
1. Is the --ssl-ca option to mysqld the public key used by
Hi,
We are developing a Java EE 5 based system in which we run our system using
MySQL on our local test workstation machines. Each night our project is built
and deployed on our test server, which is using PostgreSQL, it's the database
we will be using in our production environment as well (for
Well, I created the lookup table, created my two triggers (as nothing is ever
updated, just added or removed) and did a bulk one time load and it seems to
work. Now I just need to replicate that to the other server. I'll have to
find my easy button and press it a few times.
In fact, on the o
Claudio,
I didn't think about that approach either. The triggers will be much simpler
to implement on the primary servers, then pull it over with a table rewrite to
the intermediate server, then allow that to replicate out just fine. I'll play
around with it a little. The table has million
Hi,
On Feb 20, 2008 6:13 AM, Thufir <[EMAIL PROTECTED]> wrote:
> I'm considering studying for:
>
> Certified MySQL Associate (CMA)
> http://www.mysql.com/certification/candguide#t21
>
> At first glance, it seems to follow:
>
> http://www.mysql.com/training/courses/introduction_to_databases.html
>
Say I have two tables:
table_a
--
a_id (primary key)
b_id
table_b
--
b_id (primary key)
name
there is a one to many mapping between rows in table b and rows in
table a.
Say I had an Id of a row in table a an (a_id, say 5). Now, what I
want to do is delete the row in table_a (ea
Hi,
this Thursday, Stewart Smith will give a MySQL University session:
http://forge.mysql.com/wiki/Checking_Memory_With_Valgrind
Please register for this session by filling in your name on the session
Wiki page. Registering is not required but appreciated. That Wiki page
also contains a section
Ah!
What you actually need is for the users to have SELECT access to
mysql.procs.
GRANT SELECT ON mysql.procs TO user@'%' identified by
Of course this is something of a security risk as well, in that any
use could see any other user's functions and stored procedures, but it
will ac
i tried, but always got error: "ERROR 1221 (HY000): Incorrect usage of DB
GRANT and GLOBAL PRIVILEGES"
i followed this and did found a former discussion. seems to be not possible
to give this privileg by this line.
http://lists.mysql.com/mysql/198421
hmm, bad case, isnt it?
Andre
- Origin
I'm considering studying for:
Certified MySQL Associate (CMA)
http://www.mysql.com/certification/candguide#t21
At first glance, it seems to follow:
http://www.mysql.com/training/courses/introduction_to_databases.html
I can hit the bookstore to find out more, of course. But, what I was
wonderin
Unfortunately, not. For internal uses i can use root or other special user.
But if my users want to do backup on there own with external mysqldump they
get this error.
if i do login with userdata from console i can do mysqldump, its only the
external connect which makes this problem.
- Ori
Hello, thankyou to everyone who has helped me out on this one as I did
not think it was actuallay possible ! :)
This is what worked best for me :
SELECT a.username, a.first_name, a.last_name,COALESCE(COUNT(b.username),
0) AS count
FROM user_list a
LEFT JOIN login_table b ON a.username = b.use
I use a specific user (backup) for my backups, therefore user privileges
are not effected. Is there something like this which you could use?
Andre Hübner wrote:
Thank you for answering.
is there a way to do without granting super-privileg? for security
reasons i cannot grant too high privile
Of course I am talking about a materialized view, did you try?
Here some useful links:
http://forums.mysql.com/read.php?100,21746,21746#msg-21746
and from the reply in the same forum topic
by Waheed Noor 09/10/2007 01:39PM you get this link:
http://www.shinguz.ch/MySQL/mysql_mv.html
Thank you for answering.
is there a way to do without granting super-privileg? for security reasons
i cannot grant too high privileges for normal db-users.
rights should be limited to own db.
Thanks
Andre
- Original Message -
From: "Ben Clewett" <[EMAIL PROTECTED]>
To: "Andre Hübner"
Hi Gary,
Did you try with a view with only the public fields of your table?
Aloha!
Claudio
-Messaggio originale-
Da: Gary W. Smith [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 20 febbraio 2008 1.18
A: mysql@lists.mysql.com
Oggetto: Column level replication q?
We need to replicate a tab
Try:
> mysql -u root -p
mysql> GRANT SUPER ON *.* TO myuser@'%';
mysql> GRANT SUPER ON *.* TO myuser@'localhost';
Andre Hübner wrote:
Hi List,
i wrote this alrready in mysql-forum a few days ago, but did not get any
answer. :(
i try to do backup with mysqldump from external host with
Hi List,
i wrote this alrready in mysql-forum a few days ago, but did not get any
answer. :(
i try to do backup with mysqldump from external host with routines.
mysqldump -R -h my.host.name -u myuser -p'mypass' mydb > filename.sql
I got error: myuser has insufficent privileges to SHOW CREATE F
25 matches
Mail list logo
