...
The simplest description is:
Copy database
Run current installer
Update new preferences
Quick Check
Copy Database
The first step is to copy over the existing data.
...
| Code Block | ||
|---|---|---|
| ||
@echo off
:: RUN by passing in the election db name
:: Example dump_db election_on
:: SETTINGS AND PATHS
:: Note: Do not put spaces before the equal signs or variables will fail
:: MySQL EXE Path
set mysqldumpexe=C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe
set dbName=%1
set dbHost=localhost
set dbPwd=password
echo Using DB Host %dbHost%
"%mysqldumpexe%" -u root -p"%dbPwd%" -h %dbHost% --port=3306 "%dbName%" --default-character-set=utf8 --single-transaction --quote-names --max_allowed_packet=100MB --log-error="%dbName%_dumpErrors.txt" --routines -r "%dbName%.sql"
echo Dump done!
:: Before importing - create a db with the election name
:: SET NAMES 'utf8' COLLATE utf8_general_ci;
:: |
Copy the Database File
Get the database dump file moved to the new server - the best way you know how.
Create Empty Schema
| Code Block | ||
|---|---|---|
| ||
// versions before 14.9.4.4 use:
CREATE DATABASE IF NOT EXISTS `election_on` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
Copy the Database File
Get the database dump file moved to the new server - the best way you know how.
Create Empty Schema
| Code Block | ||
|---|---|---|
| ||
// version 14.9.4.4 or greater use: CREATE DATABASE IF NOT EXISTS `election_on` DEFAULT CHARACTER SET utf8utf8mb4 COLLATE utf8utf8mb4_0900_generalai_ci; |
Import the Database File
...