Using command line tools

If you have command line access to your Drupal server, for example, via secure shell (SSH), and you have the necessary permissions to access the database, you can use command line tools to administer the database.

The procedure for applying an SQL snippet is

1. Save the SQL snippet to a file, say snippet.sql
2. Upload the file to your Drupal/database server
3. Log into your Drupal/database server (using SSH, for example)
4. Run the SQL snippet using the command line tool appropriate to your database (e.g., mysql, pgsql)