test

There are many ways to delete data from a database in MySQL but You’ll need special privilege to create or to delete a MySQL database. In case you want to delete MySQL database here are the process by which you can delete the MySQL database from your web hosting account.

Follow these Steps to delete MySQL database:-

After the page loads you will see a table containing the following information which is split into five columns;
# Database - This entry will be the database name you created in Step 1 above.
# Size - This entry will be the size of the database you created in Step 1 above.
# Users - This entry will be the users in the database.
# Actions - You have once choice:
# Delete Database - Click on this link to delete a database.
# Once you see the table, find the database you want to delete in the “Database” column.
# Then click on the Delete Database in the “Actions” column.
# The following confirmation statement will be seen :
“Are you sure you wish to permanently remove the DATABASE_NAME?”
# Click on the Yes button.
# The following statement will be seen:-
“Deleted the database DATABASE_NAME.”
“Database “DATABASE” dropped.”

Mysqldump program is used to dump the contents of a MySQL database and allow the transfer of a MySQL database and MySQL tables between different MySQL servers. The SQL statements can be redirected to a file though you should be sure that there is no activity going on while you do. Firewalls will not block the access to the MySQL database, A small PHP script which has to be copied to the webserver encapsulates and encrypts the access to the MySQL database.

The mysqldump program supports the following options;

-#, –debug=[options] Output debug information to log. Generally ‘d:t:o,filename`. See Appendix C for further details.
-?, –help Display usage information and exit.
-c, –compleat-insert Generate complete insert statements. (Don’t exclude values that conform to the column default.)
-h, –host=[hostname] Connect to hostname.
-d, –no-data Export only schema information. (Exclude data.)
-t, –no-create-info Export only data, exclude table creation information. (The opposite of -d.)
-p, –password=[password] The password to use when connecting to the web server. Note there can be no space between the -p and the password.
-q, –quick Don’t buffer query results, dump directly to STDOUT.
-u, –user=[username] Username for login. mysqldump will assume you wish to use your current login name if this option is excluded from the command line.
-v, –verbose Print verbose information about the various execution stages of mysqldump.
-P, –port=[port] The port to use when connecting to
-V, –version Output mysqldump version information and exit.

It also enable you to pipe the output of mysqldump to the MySQL client program to replicate a database but you should make sure-no updates are taking place while you’re doing this.

EXAMPLE:
mysqladmin create foo
mysqldump mysql | mysql foo

Microsoft has added several hot keys to accelerate the navigation and usage of Windows 7 to the next level, the new shortcuts include Windows Aero snapping feature easier by using keyboard. Here’s a few keyboard accelerators that new in Windows 7.

Alt+P Display/ hide the Explorer preview pane

Windows Logo+G Display gadgets in front of other windows

Windows Logo++ (plus key) Zoom in, where appropriate

Windows Logo+- (minus key) Zoom out, where appropriate

Windows Logo+Up Maximise the current window

Windows Logo+Down Minimise the current window

Windows Logo+Left Snap to the left hand side of the screen

Windows Logo+Right Snap to the right hand side of the screen

Windows Logo+Home Minimise/ restore everything except the current window

Windows + ? (Up Arrow) - Maximize window

Windows + ? (Left Arrow) - Snap window to left side covering half of desktop space.

Windows + ? (Right Arrow) - Snap window to right side covering half of desktop space.

Windows + ? (Down Arrow) - Minimize the window.

Other popular or common keyboard hotkeys which are already been used in Windows Vista:

Windows + D - Show desktop and restore desktop (minimize or restore all windows).

Windows + M - Minimize all windows.

Windows + T - Show preview thumbnail of running apps in Windows Taskbar one by one without mouse over.

Windows + P - Display options.

Windows + F - Search window.

Windows + G - Bring all gadgets on top and foreground.

Windows + X - Run Windows Mobile Center.

Windows + R - Open ‘Run’ command.

Windows + E - Run Windows Explorer.

Windows + L - Lock the computer.

Windows + [number] - Activate and run the program pinned on Windows 7 Taskbar

If you are planned to shift from window to Ubuntu, you could find this checklist helpful to make switch over, Ubuntu 7.04 can import your files, Windows bookmarks, favorites, documents, and pictures including the software to read and write files from your Windows drive.

Check list before shifting to Ubuntu from window;

* Download and run Ubuntu Live CD

* Check if there are any good astronomy programs available

* Make a list of alternative programs you can install and use

* Check the hardware support for my printer, scanner, broadband modem and webcam

* Check if your word processed document formats are supported

* Save all of your web bookmarks and e-mails

* Get together all of the files you want to keep in one folder

* Export all of your accounting files into a spreadsheet

* Copy all of your data (bookmarks, files, etc) onto a DVD

* Test the DVD to make sure everything was copied across

* Make a list and print out of all your mail and Internet connection settings, user accounts, and saved passwords

* Install Ubuntu from the Install CD

* Use System -> Preferences to set everything up how you like it based on your list of settings and account details

* Install everything you need from your list of available programs

* Copy all of your data across into Home directory

* Import e-mail into a mail client

The following lists of keyword shortcuts for SQL Query Analyzer should be helpful to you, the list contains (CTRL+) combination shortcut for SQL Query Analyzer, you would find these shortcut very handy and will surely save your time.

CTRL+O — Connect.
CTRL+F4 — Disconnect.
CTRL+F4 — Disconnect and close child window.
ALT+F1 — Database object information.
CTRL+SHIFT+DEL — Clear the active Editor pane.
CTRL+SHIFT+C — Comment out code.
CTRL+C or Ctrl+Insert — Copy
CTRL+X or Shift+Del — Cut
CTRL-SHIFT-F2 — Clear all bookmarks.
CTRL+F2 — Insert or remove a bookmark (toggle).
F2 — Move to next bookmark.
SHIFT+F2 — Move to previous bookmark.
ALT+BREAK — Cancel a query.
SHIFT+TAB — Decrease indent.
CTRL+DEL — Delete through the end of a line in the Editor pane.
CTRL+F — Find.
CTRL+G — Go to a line number.
TAB — Increase indent.
CTRL+SHIFT+L — Make selection lowercase.
CTRL+SHIFT+U — Make selection uppercase.
CTRL+V or Shift+Insert — Paste.
CTRL+SHIFT+R — Remove comments.
F3 — Repeat last search or find next.
CTRL+H — Replace.
CTRL+A — Select all.
CTRL+Z — Undo.
F5 or Ctrl + E — Execute a query.
F1 — Help for Query Analyzer.
SHIFT+F1 — Help for the selected Transact-SQL statement.
F6 — Switch between query and result panes.
CTRL+P — Print
CTRL+D — Display results in grid format.
CTRL+T — Display results in text format.
CTRL+B — Move the splitter.
CTRL+SHIFT+F — Save results to file.
CTRL+R — Show Results pane (toggle).
Shift+F6 — Switch panes.
CTRL+W — Window Selector.
CTRL+N — New Query window.
F8 — Object Browser (show/hide).
F4 — Object Search.
CTRL+F5 — Parse the query and check syntax.
CTRL+S — Save
CTRL+SHIFT+INSERT — Insert a template.
CTRL+SHIFT+M — Replace template parameters.
CTRL+L — Display estimated execution plan.
CTRL+K — Display execution plan (toggle ON/OFF).
CTRL+I — Index Tuning Wizard.
CTRL+SHIFT+S — Show client statistics
CTRL+SHIFT+T — Show server trace.
CTRL+U — Use database

Wordpress offer a pretty nice feature which let you post in your blog via email, you can set up your blog to publish e-mails as blog posts. To get this implemented, you need to send an e-mail to a specific address you’ve established for the purpose.

Also morelikely you will need the help of your host provider and/or your e-mail provider. This is an optional service so you can still publish posts from the Write Post SubPanel if you don’t want to post via e-mail.

You need to Complete the following fields to post by e-mail:

Mail Server

The mail server store your email for retrieval on your behalf and thus Your mail server will have a URI address, such as mail.example.com, which you should enter here.

Port
You should enter the port number here, the Servers usually use port 110 to receive requests related to emails. If your mail server uses a different port, enter that port number here.

Login Name
If, for example, the e-mail address that you will be using for the writing by e-mail feature is yoursite@example.com, then ‘yoursite’ is the Login name.

Password

Enter the password for the above e-mail address here.

Default Mail Category

All post published via the post by email feature, WordPress will assign this Category. Note: You can also create new Categories in via Administration > Manage > Categories.

More help for the set-up, check with codex at http://codex.wordpress.org/Blog_by_Email.