Completed

MySQL database upgrade script (bash)

Requirements:

· Must be in a bash script

· You will have to use a MySQL 5.7 database

A database upgrade requires the execution of numbered SQL scripts stored in a specified folder, named such as '[login to view URL]'

- The scripts may contain any simple SQL statement(s) to any table of your choice, e.g. 'INSERT INTO testTable VALUES("[login to view URL]");'

· There may be gaps in the SQL file name numbering and there isn't always a . (dot) after the beginning number

· The database upgrade is based on looking up the current version in the database and comparing this number to the numbers in the script names

- The table where the current db version is stored is called 'versionTable', with a single row for the version, called 'version'

· If the version number from the db matches the highest number from the scripts then nothing is executed

· All scripts that contain a number higher than the current db version will be executed against the database in numerical order

· In addition, the database version table is updated after the script execution with the executed script's number

· Your script will be executed automatically via a program, and must satisfy these command line input parameters exactly in order to run:

- './your-script directory-with-sql-scripts username-for-the-db db-host db-name db-password'

You will need to satisfy all requirements with adequate tests carried out

Also create a a readme documenting steps required to run the script, document like you’re explaining it to someone who is non technical if possible

Skills: MySQL, Database Administration, Microsoft SQL Server, Bash Scripting

See more: php mysql database load script, php mysql database query script, access database upgrade script, mysql database migration script, read xml file create mysql database php script, save xml mysql database php script, create mysql database installtion script php project, insert csv mysql database perl script, update primavera database upgrade script sql, amazon data mysql database php script, mysql database cleanup script, online mysql database creator script, mysql database deployment script, auto backup mysql database php script, mysql insert into select values, how to export mysql database to script

About the Employer:
( 0 reviews ) Dulwich, United Kingdom

Project ID: #30570951

Awarded to:

AnilMaram22

I am expert in writing shell scripting (BASH ) and complex sql queries, i would like to work on your project

£20 GBP in 2 days
(13 Reviews)
3.6

2 freelancers are bidding on average £18 for this job

citadel98

DATA BASE EXPERT!!! GOOD IN SQL HELLO DEAR CLIENT I have gone through your project details and the work is DOABLE since its within my area of EXPERTISE.I will tackle are required guideline to deliver desired goal Pleas More

£15 GBP in 1 day
(2 Reviews)
3.5