How to run MySQL command on Pantheon ?

[#1]

I am importing the data from Live environment to Dev-environment and trying to truncate the data from watch_dog table. I am using Pantheon Dev-box. Please let me know the procedure to run the MySQL command.

mysql> mysql -u <username> <password> -h <host> -P <port> pantheon;

[anilsr]

@Shirish ,

That's correct, In fact you can see the command line command to login into mysql box in pantheon dashboard page, Connection Info tab,

You need mysql client installed in your machine to run this command. You can also install GUI MySQL clients to connect to pantheon db & run mysql commands.

You can download GUI client like MySQL Query browser .

BTB ,

Idea is to delete watchdog table, You can do it using drush ,

$> drush watchdog-delete