John Taylor-Johnston schrieb:
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
where
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
Thanks,
John
DROP TABLE IF EXISTS `
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database. I was told that
>
Hi,
On 3/19/08 3:51 PM, "Brown, Charles" <[EMAIL PROTECTED]> wrote:
> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database. I was told that
> the cnf
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file allows security over rides. Please help
I have tried mysql -uroot. It
Here is something radical if you want to record the grants yourself:
Run the following query
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') UserGrants FROM
mysql.user WHERE user IS NOT NULL AND user <> '' AND host IS NOT NULL AND host
<> '';
This query will create a SHOW GRANTS FO
Yes !!!
mysqldump -h... -u... -p... mysql > MySQLSchema.sql
Give it a try !!!
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 2:17 PM
Cc: mysql@lists.mysql.com
Subject: RE: mysql privileges
On Wed, 19 Mar 2008, Rolando Edwards <[EMAIL PROT
On Wed, 19 Mar 2008, Rolando Edwards <[EMAIL PROTECTED]> wrote:
Yes you will have all the GRANTS for every user sitting in the
'mysql' schema (from mysq.user) if you use the --all-databases
option of mysqldump.
Can I safely assume that dumping the database named "mysql" dumps just
as well as us
Yes you will have all the GRANTS for every user sitting in the 'mysql' schema
(from mysq.user) if you use the --all-databases option of mysqldump.
Here is something radical if you want to record the grants yourself:
Run the following query
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''
Yes. Just use --all-databases as mysqldump option and the 'mysql' schema is
included.
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 12:15 PM
To: mysql@lists.mysql.com
Subject: Are user privileges included in MYSQLDUMP
Using mysqldump, I
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Using mysqldump, I'm about to dump all databases and import to another
> instance - new . My question is do I need to define all security and
> users in the new mysql or the security definitions and privileges will
>
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be included in the dump file created by mysqldump. What is the function
of mysql_fix_p
Brown, Charles schrieb:
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file c
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file created by
mysqldump.
Pl
On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
<[EMAIL PROTECTED]> wrote:
> Hi all!
>
> Well, question is how could I to retrieve information about
> types supported . In PostgreSQL the query would be:
>
> --
> SELECT pg_type.oi
15 matches
Mail list logo
