run_xampp.bat

Posted October 8th, 2009 in blog by admin

I am making new run_xampp.bat. The new code can be stop MSSQL server and IIS also. Sometime, we can’t run apaceh because of MSSQL service. So, we need to stop it or we need to change apaceh port. I choice to stop MSSQL service because I just use MySQL. Ok… This is my new code

iisreset.exe/stop
net stop IISADMIN
net stop MSSQLSERVER
net stop MSSQLServerOLAPService
net stop MsDtsServer100
net stop SQLWriter
net stop ReportServer
C:\xampp\xampp_start.exe

Excel To MySQL with MySQL Migration Toolkit

Posted October 4th, 2009 in blog by admin

If we want to change excel file to mysql, we can change with MySQL Migration Toolkit that contain in MySQL GUI Tool.

 

1. Change .Excel file to MS Access. You can import excel file in MS Access.

2. Open MySQL Migration Toolkit and choose MS Access. You will do setp by step with wizard. It’s easy, don’t worry it.

3. You will see new database in mysql. Ok. Export only tables from phpmyadmin and then import the another database that you want to import.

 

It’s easy and you can do csv to mysql like that. You need to open csv with excel and save as xls. After that you can do from step 1.

 

Cheer!!!