05-05-2009
Take all db dump with username and passowrd
Hi All
I have mysql server,That have many Database with different username and password for each,How can i dump all database collectively,And then restore to an other mysql db sever .
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
2. UNIX for Dummies Questions & Answers
hello everbody:
I've just faced this weird case, on my sol8 machine i created user called:
mmsctest, and assigned its passwrd to be same as user name "mmsctest".
however when I enter the password follwoed by any charecters like:
mmsctest1,mmsctest123,mmsctest666
Im managed to log in wth that... (2 Replies)
Discussion started by: aladdin
2 Replies
3. AIX
Hey,
i'm using AIX 5.3 which authenticates against a Microsoft Active Directory.
Everything works fine but like everytime there's a problem.
I created users with usernames with more than 8 characters.
Now i tried do login on AIX with these users, which didn't work. The login-window... (3 Replies)
Discussion started by: damn-86
3 Replies
4. Shell Programming and Scripting
I'm trying to use lynx --dump to keep an eye on updates for a website.
The site needs a username and password and I can't find a way to log in using lynx --dump
Any ideas??
Thanks in advance! (12 Replies)
Discussion started by: 64mb
12 Replies
5. Post Here to Contact Site Administrators and Moderators
Is it possible to change my username in this site or is thre a way to delete my account and then create a new one with a diffrent user name (2 Replies)
Discussion started by: floresr
2 Replies
6. Forum Support Area for Unregistered Users & Account Problems
Hi
i have registered but my username is set to default value ( my email). can i change this ? (2 Replies)
Discussion started by: customizeemai
2 Replies
7. Post Here to Contact Site Administrators and Moderators
Moderators,
I want to change my username. I tried but unable to find a way to do that. Can you please assist?
Thanks & Regards
Abedi (1 Reply)
Discussion started by: katherine2008
1 Replies
8. Solaris
Hi all,
System is Solaris10
There is one script which i was able to execute with following entry:-
su user1 -c "/u01/scripts/mfg/_db-start.all"
But when I do this, which asked to do with -i option
su -i user1 -c "/u01/scripts/mfg/_db-start.all"
It gives following message:-... (1 Reply)
Discussion started by: manalisharmabe
1 Replies
9. Solaris
Password got expired but not prompting for new passowrd in soalris 10 and another user got locked why it got locked and when it got locked how to check the logs (1 Reply)
Discussion started by: upender
1 Replies
10. UNIX for Beginners Questions & Answers
Greetings,
The title pretty much says it all. I've snooped everywhere and can't find anything on this. Since our organization went to numeric usernames, using the u|U option for ps returns no processes. Example passwd entry:
320074:DjZAJKXun8HBs:10129:6006:Joe Y:/cadhome/analysis/jy:/bin/bash... (4 Replies)
Discussion started by: crimso
4 Replies
LEARN ABOUT CENTOS
pmdamysql
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
NAME
pmdamysql - MySQL database PMDA
DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.
INSTALLATION
pmdamysql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/mysql/mysql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Remove
pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
Binary Status values in text
Some of the status values are in the form of YES/NO or ON/OFF.
Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
(NO/OFF).
Eg:
o mysql.slave_status.slave_io_running
o mysql.slave_status.slave_io_running_num
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/mysql/mysql.conf
configuration file for pmdamysql
$PCP_PMDAS_DIR/mysql/Install
installation script for the pmdamysql agent
$PCP_PMDAS_DIR/mysql/Remove
undo installation script for the pmdamysql agent
$PCP_LOG_DIR/pmcd/mysql.log
default log file for error messages from pmdamysql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et:
3.8.10 Performance Co-Pilot PMDAMYSQL(1)