Wiki Relationships:

Admin Tools:

Commands executed from Shell Prompt

Connecting to a Database

mysql -u username -p database -h localhost

Note: above command prompts for password. Enter your MySQL password for access

Dumping the database

mysqldump databasename > databasename.sql

Restoring the database

mysql -u username -p -h localhost databasename < databasename.sql

Listing the process running in the MySQL

mysqladmin -u root -p -h localhost processlist

Commands executed from MySQL Prompt

Creating a Database

create database databasename

Deleting a Database

drop database databasename

Listing the processes running in the mysql server

Show Processlist

Displaying the mysql variables

Show Variables

Displaying List of databases

Show Databases

Displaying List of tables under databasename

\u databasename or use databasename
show tables

This page has been accessed 3,180 times.

This page was last modified 05:08, 23 June 2006.