MySql

Wednesday, 4 September 2013

Command to check the number of connections to mysql server

netstat -antp | grep :3306 | wc -l
Posted by Vickrant Earnest at 22:38 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: mysql, netstat, no of connections
Location: India

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

Posted by Vickrant Earnest at 22:34 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: mysql, source
Newer Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ▼  2013 (3)
    • ►  November (1)
    • ▼  September (2)
      • Command to check the number of connections to mysq...
      • load database from mysql command prompt

About Me

Vickrant Earnest
View my complete profile
Simple theme. Powered by Blogger.