loading database from mysql command prompt

mysql>create database1 database2;
mysql>use database2;
mysql>source /opt/database_0435.sql

It is very useful for making new databases quickly from command. phpmyadmin has its own limitations depending on how its configured over the webserver.