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

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.

Introduction to DOJO

Hey guys.., I am also new to DOJO (javascript framework)..iam trying to learn this framework..anyways i will share with you guys.. 🙂

Dojo Toolkit (stylized as dōjō toolkit) is an open source modular JavaScript library (or more specifically JavaScript toolkit) designed to ease the rapid development of cross-platform, JavaScript/Ajax-based applications and web sites.

In this tutorial, you will learn everything about the dojo. After completing the tutorial you will be able to develop good applications using Dojo framework.

This advanced Dojo tutorial covers:

Introduction to DOJO
Dojo Events
Dojo Widgets
Dojo Effects
Dojo Vector Graphics
Dojo accessibility
Dojo local storage
Dojo DOM
Dojo HTML and CSS
Dojo Ajax Functions
Dojo Comet
Extending Dojo
Debugging Dojo applications
Digit toolkit
Our Dojo tutorial will also explain you the steps necessary to start developing and testing the example using Dojo framework. We will also explain you the Dojo framework structure, development and testing process.

Dojo is actually based on JavaScript and HTML, so its easy to learn. You can learn Dojo very fast and start developing your next highly interactive web applications.

How to Add Google Analytics to WordPress in Three Simple Steps

This article shows you how to add Google Analytics to WordPress with minimal fuss and very little effort.

Step One: Get a Google Analytics account

If you haven’t already signed up for analytics, you’ll need to venture over to Google and get hooked up with a free account. Don’t worry, it’s quick and painless.

Once you’ve completed the sign up process, you’ll be given a piece of JavaScript code. It looks like this:

Google-Analytics

This code allows Google to gather anonymous data on how your website is being used

Step Two: Add the Google Analytics code to your WordPress theme

To do this, you’ll need to open up the footer.php file of your WordPress theme. You can either use an FTP client to access your server, or edit your theme files directly from the WordPress dashboard. Your file editor is located under the ‘Appearance’ tab in the sidebar menu.

Adding-Google-analytics-code

In the list of template files to the right of the text editor, find footer.php and open it. To add Google Analytics to WordPress, you now just need to copy and paste your code immediately before the closing </body> tag. Like so:

How-to-add-analytics-code-to-footer

 

Make sure you save your footer.php file once you’ve pasted in the new code. Google Analytics should now be able to track every page of your WordPress site and provide you with that sweet juicy data.

Step Three: Double check that your analytics is working

To make sure that the script has installed correctly, go back to your Google Analytics home page and click the admin panel in the top right corner of the screen. Open the relevant account, and click the ‘tracking code’ panel. If the Tracking Status is ‘Receiving Data’, then you’ve successfully added Google Analytics to your WordPress site.

Check-Google-Analytics-status

Alternatively, use a Google Analytics plugin

If you’re not comfortable hacking around in your WordPress template files, or you want to explore some additional options and functionality, you can also add Google Analytics to WordPress with the use of a plugin. These plugins will typically give you an interface in your WordPress dashboard where you can add the code directly, without having to delve into your theme files.

There are quite a few Google Analytics plugins to choose from, and I wouldn’t necessarily recommend one over the others. Have a look for yourself in the WordPress plugin directory. If you have a multi-site solution, I would also suggest checking out WPMU Dev’sMultisite Google Analytics plugin.