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.

Command to check the number of connections to mysql server

netstat -antp | grep :3306 | wc -l

load database from mysql command prompt

This command comes very handy when importing a database

mysql>create database new_database; 

mysql>use new_database; 

mysql>source /tmp/database_35.sql