LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 06-22-2003, 04:27 AM   #1
LammaDog
LQ Newbie
 
Registered: Sep 2001
Location: Colorful Colorado
Posts: 8

Rep: Reputation: 0
MySQL - matchings users to dbs?


Hey Guyz,

I'm putting together a new backup script, that stores the daily backups in the user directorys (sorta like Cpanel does it) But I also want to backup the users databases there too.

The problem I'm having, is that I don't know which database is owned by which user. And I'm afraid to experiment with the Grant tables on the live server. (I'm getting ready to move, and my test box is packed away)

Can someone please give me the command to query who owns a particular mysql database?



Thanks in Advance
Troy
 
Old 06-22-2003, 04:57 AM   #2
LammaDog
LQ Newbie
 
Registered: Sep 2001
Location: Colorful Colorado
Posts: 8

Original Poster
Rep: Reputation: 0
oh ok, I got it. that was way too easy

I just had to 'use mysql' and it was all right there for me.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting and reusing existing mysql permissions/dbs/tables after update deesto *BSD 0 10-29-2005 03:46 PM
deleting users from mysql jsheffie Linux - Software 4 10-18-2005 09:29 PM
Can I place mysql dbs in a folder that I define macmichael01 Suse/Novell 5 06-28-2005 01:35 PM
can't add users to mysql niehls Linux - Software 2 02-21-2003 05:33 AM
MySQL ~users santiagodelgado Linux - Networking 1 11-30-2001 08:58 AM


All times are GMT -5. The time now is 07:48 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration