Hi all, I don't understand why "sql" command gives access to any base on any cluster and "mysql" command gives access to bases on s2 cluster only.
For exemple: cluster s1 sql enwiki_p runs mysql -D enwiki_p doesn't run
cluster s2 sql dewiki_p runs mysql -D dewiki_p runs
cluster s3 sql frwiki_p runs mysql -D frwiki_p doesn't run
Under these conditions, tell me how does you start a command line query on s1 or s3 databases? For example to replace: mysql -D enwiki_p -e "sql-queries"
Thank you for your help.
Regards, Richard (Escaladix)
--------------------------------- Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
Richard ROCCA:
RR> Hi all, RR> I don't understand why "sql" command gives access to any base on RR> any cluster and "mysql" command gives access to bases on s2 cluster only.
"sql" is a wrapper script around "mysql" which automatically connects to the correct server for the database you specified. for example, "sql enwiki_p" runs "mysql -hsql-s1 enwiki_p".
RR> Under these conditions, tell me how does you start a command line query on s1 or s3 databases?
mysql -hsql-s1 -e "query" enwiki_p
- river.
River, Thank you for your so quick answer. Richard (Escaladix)
River Tarnell river@wikimedia.org a écrit : Richard ROCCA:
RR> Hi all, RR> I don't understand why "sql" command gives access to any base on RR> any cluster and "mysql" command gives access to bases on s2 cluster only.
"sql" is a wrapper script around "mysql" which automatically connects to the correct server for the database you specified. for example, "sql enwiki_p" runs "mysql -hsql-s1 enwiki_p".
RR> Under these conditions, tell me how does you start a command line query on s1 or s3 databases?
mysql -hsql-s1 -e "query" enwiki_p
- river._______________________________________________ Toolserver-l mailing list Toolserver-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/toolserver-l
--------------------------------- Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
toolserver-l@lists.wikimedia.org