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.

Comments

Convert DLFileEntry To simple java file

We can convert liferay com.liferay.portlet.documentlibrary.model.DLFileEntry to java.io.File with help of below method. File file1 = DLFileEntryLocalServiceUtil.getFile(user.getUserId(), dlFileEntry.getFileEntryId(), dlFileEntry.getVersion(), true);

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...

Add custom field in user expando api liferay 6.2

Custom Field Liferay 1) The easiest way to add customfield is add customfield with control panel. Admin -> Control panel -> Configuraton -> custom fields -> Click user -> Add custom field -> Add key and Type (e.g key - nickname type - Text field index) Click on save Now you done. Create One Hook Liferay -> https://www.liferay.com/documentation/liferay-portal/6.2/development/-/ai/customize-and-extend-functionality-hooks-liferay-portal-6-2-dev-guide-en Override html\portlet\users_admin\user\details.jsp Add below code in jsp for the custom field nickname. <div class="exp-ctrl-holder"> <liferay-ui:custom-attribute className="<%= User.class.getName() %>" classPK="<%= (selUser != null) ? selUser.getUserId() : 0 %>" editable="<%= true %...

Liferay

Search This Blog