Skip to main content

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











Post a Comment



















Popular posts from this blog



















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




















7 comments









Read more




























oracle drop all tables and sequences in a certain schema




























 --  please never put a comment starting with " / "  as this character means execute the previous line   BEGIN      FOR i IN (SELECT us.sequence_name                FROM USER_SEQUENCES us) LOOP      EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||'';    END LOOP;        FOR i IN (SELECT ut.table_name                FROM USER_TABLES ut) LOOP      EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS ';    END LOOP;   END;  -- the following character executes the whole block of pl sql code  /  




















4 comments









Read more




























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 أبتثجحخدرزسشصضطظعغفقكلمنهوى", myAr...




















3 comments









Read more