MySQL. InnoSetup. “Тихая установка”. Загрузка своей базы данных при инсталляции

Продолжаю прошлую тему – устанавливать “тихо” MySQL сервер мы научились. Что дальше?

В данном посте посмотрим как при инсталляции сервера MySQL добавить в него свою базу данных. Для этого нам нужен собственно дамп базы, далее нужно дать команду серверу, после инсталляции создать пустую базу и загрузить в неё этот дамп.

Пусть у нас есть дамп базы под названием test_dump.sql – о том как его сделать я писал в другой статье, но если кратко и здесь, то

1 способ, через командную строку под администратором Windows

mysqldump test_db > С:\PathToFile\dump.sql

1	mysqldump test_db > С:\PathToFile\dump.sql

2 способ

-через WorkBench >DataExport > Export To Self Contained File

Итак, дамп у нас есть, остается придумать как его использовать в InnoSetup,

1-е изменение, которое я внес, это в сектор [Files]

[Files]
...
Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\test_dump.sql"; DestDir: "{app}"; Flags: ignoreversion
; NOTE: Don't use "Flags: ignoreversion" on any shared system files
...

[Files]

...

Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\test_dump.sql"; DestDir: "{app}"; Flags: ignoreversion

; NOTE: Don't use "Flags: ignoreversion" on any shared system files

...

2-е изменение, которое я внёс, это в сектор Run, нам нужно каким-то образом дать серверу mysql команду на создание пустой базы данных и импортирование в неё данных, это можно сделать следующим образом…

;------------------------------------------------- Creating Empty Database and loadind dump 
Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -e ""create database test_db;"" "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

; Loading dump 
Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey test_db < {app}\test_dump.sql; "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden
;-------------------------------------------------

;------------------------------------------------- Creating Empty Database and loadind dump

Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -e ""create database test_db;"" "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

; Loading dump

Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey test_db < {app}\test_dump.sql; "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

;-------------------------------------------------

Полный код тихой инсталляции MySQL для InnoSetup

; Script generated by the Inno Setup Script Wizard.
; SEE THE DOCUMENTATION FOR DETAILS ON CREATING INNO SETUP SCRIPT FILES!

#define MyAppName "MySQL_Install"
#define MyAppVersion "1.5"
#define MyAppPublisher "My Company, Inc."
#define MyAppURL "http://www.example.com/"
#define MyAppExeName "MySQL_TestInstall.exe"

[Setup]
; NOTE: The value of AppId uniquely identifies this application.
; Do not use the same AppId value in installers for other applications.
; (To generate a new GUID, click Tools | Generate GUID inside the IDE.)
AppId={{73F53ED9-3A82-4F4D-8E0C-19BDDE5AD3E6}
AppName={#MyAppName}
AppVersion={#MyAppVersion}
;AppVerName={#MyAppName} {#MyAppVersion}
AppPublisher={#MyAppPublisher}
AppPublisherURL={#MyAppURL}
AppSupportURL={#MyAppURL}
AppUpdatesURL={#MyAppURL}
DefaultDirName={pf}\{#MyAppName}
DisableProgramGroupPage=yes
OutputDir=C:\Users\NoName\Desktop\ComplierOutput
OutputBaseFilename=MySQL_TestSetup
Compression=lzma
SolidCompression=yes

[Languages]
Name: "english"; MessagesFile: "compiler:Default.isl"

[Tasks]
Name: "desktopicon"; Description: "{cm:CreateDesktopIcon}"; GroupDescription: "{cm:AdditionalIcons}"; Flags: unchecked
Name: "quicklaunchicon"; Description: "{cm:CreateQuickLaunchIcon}"; GroupDescription: "{cm:AdditionalIcons}"; Flags: unchecked; OnlyBelowVersion: 0,6.1

[Files]
;Source: "C:\Program Files (x86)\Inno Setup 5\Examples\MySQL_TestInstall.exe"; DestDir: "{app}"; Flags: ignoreversion
Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\InnoSetup_Test.exe"; DestDir: "{app}"; Flags: ignoreversion
Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\mysql-5.5.23-winx64.msi"; DestDir: "{app}"; Flags: ignoreversion
Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\test_dump.sql"; DestDir: "{app}"; Flags: ignoreversion
; NOTE: Don't use "Flags: ignoreversion" on any shared system files

[Icons]
Name: "{commonprograms}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"
Name: "{commondesktop}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"; Tasks: desktopicon
Name: "{userappdata}\Microsoft\Internet Explorer\Quick Launch\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"; Tasks: quicklaunchicon

[Run]
;Filename: "{app}\{#MyAppExeName}"; Description: "{cm:LaunchProgram,{#StringChange(MyAppName, '&', '&&')}}"; Flags: nowait postinstall skipifsilent

;------------------------------------------------------INSTALLING
Filename: msiexec; Parameters: "/i ""{app}\mysql-5.5.23-winx64.msi "" /qn INSTALLDIR=""C:\mysql"" DATADIR=""C:\mysql\data"" "; WorkingDir:{app}; StatusMsg: Please wait while we install mysql-5.5.23-winx64.msi;  Flags: runhidden

;Filename: msiexec; Parameters: "/i mysql-5.5.23-winx64.msi /qn INSTALLDIR=""C:\mysql"" DATADIR=""C:\mysql\data"" "; WorkingDir:{app}; StatusMsg: Please wait while we install mysql-5.5.23-winx64.msi;  Flags: runhidden
Filename: C:\mysql\bin\mysqld.exe; Parameters:" --install"; WorkingDir: {app}; StatusMsg: Installing MySQL services; Description: Installing MySQL Service; Flags: runhidden


;-------------------------------------------------------CONFIGURING
Filename: C:\mysql\bin\MySQLInstanceConfig.exe; Parameters:"-i -q ""-lC:\mysql\mysql_install_log.txt"" ""-nMySQL Server 5.5"" ""-pC:\mysql"" -v5.5.23 ""-tC:\mysql\my-template.ini"" ""-cC:\mysql\my2.ini"" ServerType=SERVER DatabaseType=MIXED Port=3306 StrictMode=yes ConnectionCount=15 Charset=utf8 ServiceName=MYSQL AddBinToPath=yes RootPassword=masterkey"; WorkingDir: {app}; StatusMsg: Configuring MySQL services; Description: Configuring MySQL Service; Flags: runhidden  

; Here we starting mysql service
Filename: net.exe; Parameters: start mysql; StatusMsg: Starting MySQL server; Description: Starting MySQL Server; Flags: runhidden

;-------------------------------------------- Setting new password for root user

Filename: C:\mysql\bin\mysqladmin.exe; Parameters: "-u root password ""masterkey"" "; WorkingDir: {app}; StatusMsg: Setting new password; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-e ""update mysql.user set password=PASSWORD('masterkey') where user='root';"" -u root"; WorkingDir: {app}; StatusMsg: Configuring MYSQL ; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-e ""flush privileges;"" -u root -pmasterkey"; WorkingDir: {app}; StatusMsg: Configuring Database Servers; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -h localhost --execute=""SOURCE database.sql"""; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden



;------------------------------------------------- Creating Empty Database and loadind dump 
Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -e ""create database test_db;"" "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

; Loading dump 
Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey test_db < {app}\test_dump.sql; "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden
;-------------------------------------------------

Filename: "{app}\{#MyAppExeName}"; Description: "{cm:LaunchProgram,{#StringChange(MyAppName, '&', '&&')}}"; Flags: nowait postinstall skipifsilent

[UninstallRun]
Filename: msiexec; Parameters: "/i ""{app}\mysql-5.5.23-winx64.msi "" "



[Code]
function MySQL_Is(): Boolean;
var
iResultCode: Integer;
begin
  Result := true;
  if (not RegKeyExists(HKLM, 'SOFTWARE\MySQL AB\MySQL Server 5.5')) or 
   (not FileExists(ExpandConstant('{reg:HKLM\SOFTWARE\MySQL AB\MySQL Server 5.5,Location}\bin\mysql.exe'))) 
  then begin
     ExtractTemporaryFile('mysql-5.5.23-winx64.msi');
     Exec('msiexec.exe', '/i mysql-5.5.23-winx64.msi /qn INSTALLDIR="C:\mysql"', 
      ExpandConstant('{tmp}'), SW_HIDE, ewWaitUntilTerminated, iResultCode);
         if not FileExists(ExpandConstant('{reg:HKLM\SOFTWARE\MySQL AB\MySQL Server 5.5,Location}\bin\mysql.exe')) then begin
            MsgBox('Something went wrong! Installation should be terminated', 
              mbInformation, MB_OK);
            Result := false;
         end;
  end;

end;

100

101

102

103

104

105

106

107

108

109

; Script generated by the Inno Setup Script Wizard.

; SEE THE DOCUMENTATION FOR DETAILS ON CREATING INNO SETUP SCRIPT FILES!

#define MyAppName "MySQL_Install"

#define MyAppVersion "1.5"

#define MyAppPublisher "My Company, Inc."

#define MyAppURL "http://www.example.com/"

#define MyAppExeName "MySQL_TestInstall.exe"

[Setup]

; NOTE: The value of AppId uniquely identifies this application.

; Do not use the same AppId value in installers for other applications.

; (To generate a new GUID, click Tools | Generate GUID inside the IDE.)

AppId={{73F53ED9-3A82-4F4D-8E0C-19BDDE5AD3E6}

AppName={#MyAppName}

AppVersion={#MyAppVersion}

;AppVerName={#MyAppName} {#MyAppVersion}

AppPublisher={#MyAppPublisher}

AppPublisherURL={#MyAppURL}

AppSupportURL={#MyAppURL}

AppUpdatesURL={#MyAppURL}

DefaultDirName={pf}\{#MyAppName}

DisableProgramGroupPage=yes

OutputDir=C:\Users\NoName\Desktop\ComplierOutput

OutputBaseFilename=MySQL_TestSetup

Compression=lzma

SolidCompression=yes

[Languages]

Name: "english"; MessagesFile: "compiler:Default.isl"

[Tasks]

Name: "desktopicon"; Description: "{cm:CreateDesktopIcon}"; GroupDescription: "{cm:AdditionalIcons}"; Flags: unchecked

Name: "quicklaunchicon"; Description: "{cm:CreateQuickLaunchIcon}"; GroupDescription: "{cm:AdditionalIcons}"; Flags: unchecked; OnlyBelowVersion: 0,6.1

[Files]

;Source: "C:\Program Files (x86)\Inno Setup 5\Examples\MySQL_TestInstall.exe"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\InnoSetup_Test.exe"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\mysql-5.5.23-winx64.msi"; DestDir: "{app}"; Flags: ignoreversion

Source: "C:\Users\NoName\Desktop\MySQL_InstallTest_SourceFiles\test_dump.sql"; DestDir: "{app}"; Flags: ignoreversion

; NOTE: Don't use "Flags: ignoreversion" on any shared system files

[Icons]

Name: "{commonprograms}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"

Name: "{commondesktop}\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"; Tasks: desktopicon

Name: "{userappdata}\Microsoft\Internet Explorer\Quick Launch\{#MyAppName}"; Filename: "{app}\{#MyAppExeName}"; Tasks: quicklaunchicon

[Run]

;Filename: "{app}\{#MyAppExeName}"; Description: "{cm:LaunchProgram,{#StringChange(MyAppName, '&', '&&')}}"; Flags: nowait postinstall skipifsilent

;------------------------------------------------------INSTALLING

Filename: msiexec; Parameters: "/i ""{app}\mysql-5.5.23-winx64.msi "" /qn INSTALLDIR=""C:\mysql"" DATADIR=""C:\mysql\data"" "; WorkingDir:{app}; StatusMsg: Please wait while we install mysql-5.5.23-winx64.msi; Flags: runhidden

;Filename: msiexec; Parameters: "/i mysql-5.5.23-winx64.msi /qn INSTALLDIR=""C:\mysql"" DATADIR=""C:\mysql\data"" "; WorkingDir:{app}; StatusMsg: Please wait while we install mysql-5.5.23-winx64.msi; Flags: runhidden

Filename: C:\mysql\bin\mysqld.exe; Parameters:" --install"; WorkingDir: {app}; StatusMsg: Installing MySQL services; Description: Installing MySQL Service; Flags: runhidden

;-------------------------------------------------------CONFIGURING

Filename: C:\mysql\bin\MySQLInstanceConfig.exe; Parameters:"-i -q ""-lC:\mysql\mysql_install_log.txt"" ""-nMySQL Server 5.5"" ""-pC:\mysql"" -v5.5.23 ""-tC:\mysql\my-template.ini"" ""-cC:\mysql\my2.ini"" ServerType=SERVER DatabaseType=MIXED Port=3306 StrictMode=yes ConnectionCount=15 Charset=utf8 ServiceName=MYSQL AddBinToPath=yes RootPassword=masterkey"; WorkingDir: {app}; StatusMsg: Configuring MySQL services; Description: Configuring MySQL Service; Flags: runhidden

; Here we starting mysql service

Filename: net.exe; Parameters: start mysql; StatusMsg: Starting MySQL server; Description: Starting MySQL Server; Flags: runhidden

;-------------------------------------------- Setting new password for root user

Filename: C:\mysql\bin\mysqladmin.exe; Parameters: "-u root password ""masterkey"" "; WorkingDir: {app}; StatusMsg: Setting new password; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-e ""update mysql.user set password=PASSWORD('masterkey') where user='root';"" -u root"; WorkingDir: {app}; StatusMsg: Configuring MYSQL ; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-e ""flush privileges;"" -u root -pmasterkey"; WorkingDir: {app}; StatusMsg: Configuring Database Servers; Flags: runhidden

;Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -h localhost --execute=""SOURCE database.sql"""; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

;------------------------------------------------- Creating Empty Database and loadind dump

Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey -e ""create database test_db;"" "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

; Loading dump

Filename: C:\mysql\bin\mysql.exe; Parameters: "-u root -pmasterkey test_db < {app}\test_dump.sql; "; WorkingDir: {app}; StatusMsg: Loading Database; Flags: runhidden

;-------------------------------------------------

Filename: "{app}\{#MyAppExeName}"; Description: "{cm:LaunchProgram,{#StringChange(MyAppName, '&', '&&')}}"; Flags: nowait postinstall skipifsilent

[UninstallRun]

Filename: msiexec; Parameters: "/i ""{app}\mysql-5.5.23-winx64.msi "" "

[Code]

function MySQL_Is(): Boolean;

var

iResultCode: Integer;

begin

Result := true;

if (not RegKeyExists(HKLM, 'SOFTWARE\MySQL AB\MySQL Server 5.5')) or

(not FileExists(ExpandConstant('{reg:HKLM\SOFTWARE\MySQL AB\MySQL Server 5.5,Location}\bin\mysql.exe')))

then begin

ExtractTemporaryFile('mysql-5.5.23-winx64.msi');

Exec('msiexec.exe', '/i mysql-5.5.23-winx64.msi /qn INSTALLDIR="C:\mysql"',

ExpandConstant('{tmp}'), SW_HIDE, ewWaitUntilTerminated, iResultCode);

if not FileExists(ExpandConstant('{reg:HKLM\SOFTWARE\MySQL AB\MySQL Server 5.5,Location}\bin\mysql.exe')) then begin

MsgBox('Something went wrong! Installation should be terminated',

mbInformation, MB_OK);

Result := false;

end;

В принципе, это тот же код, который был у нас в прошлом посте, но здесь внесены 2 изменения, указанные выше.

MySQL. InnoSetup. “Тихая установка”. Загрузка своей базы данных при инсталляции

Полный код тихой инсталляции MySQL для InnoSetup

MY PROJECTS

Recent Posts

Categories