Runing multiple mysql instances on one machine

Suppose you have two mysql instances

c:\mysq1 and c:\mysql2

1- create file  c:\mysql1\my.cnf

add the following lines

[mysqld]
datadir = C:/mysql1/data
port = 3308

2- create file  c:\mysql2\my.cnf

add the following lines

[mysqld]
datadir = C:/mysql2/data
port = 3309

3-now run the first instance

cd c:\mysql1\bin

mysqld --defaults-file=c:\mysql1\my.cnf

4-open another command and  run the second instance

cd c:\mysql2\bin

mysqld --defaults-file=c:\mysql2\my.cnf

finsihed ;)

Comments

Installing liferay 6.2 on wildfly 10 app server and oracle 11g database & windows machine

*************************************DATABASE CREATION*********************************************************************************************** DOWNLOAD LIFERAY PORTAL SCRIPTS FROM https://www.liferay.com/downloads/liferay-portal/available-releases Rename the file as liferay.sql put it let say in under c drive , so it will be located like this c:\liferay.sql from cmd dir c:\ SQLPLUS / AS SYSDBA @liferay.sql lportal lportal it will create the db ..after finishing go to sqlplus again to ggrant the below to lportal user SQLPLUS / AS SYSDBA grant create session to lportal; grant connect to lportal; grant resource to lportal; *******************************CONFIGURE WILDFLY TO CONNECT TO ORACLE DB ***************************************************************************************************** configure wildfly to connect to oracle db Download the driver: ojdbc[VERSION].jar Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/oracle/main/ C

itext 2.7.1 writing Arabic and English content in a PDF file

public void createPdf(String filename) throws IOException, DocumentException { Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream(filename)); document.open(); document.add(Chunk.NEWLINE); FontFactory.register("c:/windows/fonts/tradbdo.ttf", "my_arabic"); Font myArabicFont = FontFactory.getFont("my_arabic" ,BaseFont.IDENTITY_H, BaseFont.EMBEDDED); PdfPTable table = new PdfPTable(1); table.getDefaultCell().setNoWrap(false); // table.setRunDirection(PdfWriter.RUN_DIRECTION_RTL); PdfPCell text = new PdfPCell(new Phrase("محمود السنباطيthis is أبتثجحخدرزسشصضطظعغفقكلمنهوى", myArabicFont)); text.setRunDirection(PdfWriter.RUN_DIRECTION_RTL); text.setNoWrap(false); table.addCell(text); //Add the table to the document document.add(table);

Fast Download with progress indication facility using Java NIO

package test; import java.io.FileOutputStream; import java.io.IOException; import java.net.HttpURLConnection; import java.net.URL; import java.nio.ByteBuffer; import java.nio.channels.Channels; import java.nio.channels.ReadableByteChannel; import java.util.Date; public class DownloadProgressExample { public static void main( String[] args ) { new Downloader( "c:/header12.jpg", "http://www.daralshifa.com/images/mainheader/header12.jpg" ); } private interface RBCWrapperDelegate { // The RBCWrapperDelegate receives rbcProgressCallback() messages // from the read loop. It is passed the progress as a percentage // if known, or -1.0 to indicate indeterminate progress. // // This callback hangs the read loop so a smart implementation will // spend the least amount of time possible here before returning. // // One possible implementation is to push the progress message // atomic

Mahmoud Elsonbati

Search This Blog