google.com, pub-5747754088801811, DIRECT, f08c47fec0942fa0 Skip to main content

MYSQL Import and export database through command line

Update environment variable path upto mysql bin

e.g. C:\Program Files\MySQL\MySQL Server 5.7\bin



Check whether mysql path set up correctly just execute mysql command




Go to command line 

Fire below command to export db
mysqldump -u root -p mydb > exportedmydb.sql


Fire below command to import db
mysqldump -u root -p importeddb < exportedmydb.sql

It will ask password once you execute command provide mysql password.
 
Labels:

Comments

Post a Comment

Popular posts from this blog

Liferay portlet with alloy Ui form validator example.

 Alloy Ui  is built on YUI and we can use it in our liferay portlets.  Yui provides many component which are easy to use in our portlets  Here we see basic form validator.example with liferay portlet. Create portlet AlloyUi-portlet in eclipse. Add below content in view.jsp file Here we create two link for two JSP. <%@ taglib uri="http://java.sun.com/portlet_2_0" prefix="portlet" %> <script src="http://cdn.alloyui.com/2.5.0/aui/aui-min.js"></script> <link href="http://cdn.alloyui.com/2.5.0/aui-css/css/bootstrap.min.css" rel="stylesheet"></link> <portlet:defineObjects /> <portlet:renderURL var="basicform"> <portlet:param name="mvcPath" value="/BasicFormValidatorExample.jsp"/> </portlet:renderURL> <portlet:renderURL var="fullform"> <portlet:param name="mvcPath" value="/FullFormValidatorExample.jsp"/> </portlet:re...
Post a Comment
Read more

Model Listener Hook

                             Liferay Hook provide facility to create listener on particular model. We require to implement implements ModelListener on our custom class. Lets create one Hook which allow to do action on the various activity on particular model action. Create one hook.(e.g. UserListener-hook) Add portal properties inside liferay-hook.xml file under web inf.  <?xml version="1.0"?> <!DOCTYPE hook PUBLIC "-//Liferay//DTD Hook 6.2.0//EN" "http://www.liferay.com/dtd/liferay-hook_6_2_0.dtd"> <hook> <portal-properties>portal.properties</portal-properties> </hook>  It will create portal.properties inside src folder.  Add below property inside portlet.properties file             value.object.listener.com.liferay.portal.model.User=com.sa.CreateAccountHook In above property we have created listener for the Us...
3 comments
Read more