Mysql

To load a script into a database from a shell on linux, Centos 5.3

mysql -u root -p dbname

Create database

mysql> create database dbname character set utf8 collate utf8_generic_ci

Loading data
From shell

>mysql -u root -p logista < /path/to/script.sql

Or from mysql
mysql> source /path/to/script.sql

Drop database

mysql> drop database dbname;