How to import/export database using MySql command line

Sometimes when you have large databases, phpmyadmin or similar tool might fall when it comes to exporting or importing.
The easiest (and fastest) way is to use command line.

To export use this command:
mysqldump -u USER -p PASSWORD DATABASE > filename.sql

To import database from dump file (in this case called filename.sql) use:
mysql -u username -p password database_name < filename.sql

If you are on Windows you will need to open CMD and go to directory where mysql.exe is installed. If you are using WAMP server then this is usually located in:
C:\wamp\bin\mysql\mysql5.1.36\bin (*note the version of mysql might be different)

So you will:
cd C:\wamp\bin\mysql\mysql5.1.36\bin

and then execute one of the above commands.

Screenshot:

cmdimportdb

Advertisements

Benefits of DOJO

Dojo toolkit provides many widgets to develop the UI for web applications. Dojo is one of the robust ajax framework that can be used to develop enterprise grade application.

Following are the benefits of Dojo.

Associative arrays
Loosely typed variables
Regular expressions
Objects and classes
Highly evolved date, math, and string libraries
W3C DOM support in the Dojo
Disadvantages of Dojo Following are the Disadvantages of Dojo.

Developer depends on the browser support for the Dojo
There is no way to hide the Dojo code in case of commercial application

Why Dojo?
Choosing a ajax framework for your next web application can be very difficult task for you. There may be many choices for the ajax framework. There are many frameworks already available in the market for developing ajax applications. Both commercial and free ajax software’s provides many features.

What is DOJO? Features of it??

In this first section of Dojo tutorial we will familiarize you with the Dojo framework. Dojo is another great JavaScript framework to develop ajax based application.

What is Dojo?

Dojo is JavaScript framework released as open source software. This JavaScript toolkit provides many components to develop rich internet applications.
You can use Dojo toolkit to develop dynamic web applications. Dojo toolkit will put life in your web application and turn it into highly interactive application. You can turn your web application into desktop like web application.
Dojo offers many widgets, utilities and ajax libraries to develop your application.
Dojo is released under BSD or AFL license
Dojo is free and can be used to develop free or commercial application.

Features of Dojo
Dojo is based on HTML and JavaScript, so its easy for the developers to learn it fast.
There is no requirement of learning new programming language. Just HTML and JavaScript knowledge if sufficient.
Dojo provides higher abstraction layer to the programmer. So, it helps the programmers to develop powerful functions very easily.
Dojo has already invented the wheels for the programmers and now programmers just have to use the Dojo api into their application
Here is the list of components that comes along with Dojo framework:

DOJO Tree
DOJO Button
DOJO Calendar control
DOJO Grid
DOJO List box
and many more..
In the next sections you will be learning about all these components in details.