Design of MySQL Stored Procedure for creating db based on dump of existing database
- or -
Post a project like this2523
$$
- Posted:
- Proposals: 11
- Remote
- #1573161
- Completed
Senior .NET web developer, AWS, Azure, Linux cloud hosting, Angular development
London
Blockchain | Web | Mobile | IOT | LAMP | MEAN/MERN | .Net | Python/Django | DevOps | Microsoft Azure | Cloud Expert| AWS | AI | Virtual Reality
Amsterdam
Digital Marketing | Graphics, 3D, Animation Expert | Shopify, WordPress expert
Chandigarh
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
Enterprise web solutions, Web Media and Branding, Digital Marketing & Mobile and Desktop Application Development
Ahmedabad
1501577597098197448645550026193559910507541079205156980415701451642446
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Web based application
Database management system (DBMS): MySQL
Description of requirements/functionality: We have a MySQL database that we would like to use as a basis for new databases created on our MySQL Server. We have used the "export" tool in MySQL Workbench to create a dump file that contains the script for generating the required database structure and inserting some initial data.
We need this converting into a Stored Procedure that we can call with a single parameter for the name of the new database. The purpose of the Stored Procedure is to be able to create new databases based on the original database as defined in the dump file.
The dump file will be supplied to the selected developer.
The database is not huge. It contains 40 tables.
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/functionality: We have a MySQL database that we would like to use as a basis for new databases created on our MySQL Server. We have used the "export" tool in MySQL Workbench to create a dump file that contains the script for generating the required database structure and inserting some initial data.
We need this converting into a Stored Procedure that we can call with a single parameter for the name of the new database. The purpose of the Stored Procedure is to be able to create new databases based on the original database as defined in the dump file.
The dump file will be supplied to the selected developer.
The database is not huge. It contains 40 tables.
Extra notes:
Ian B.
100% (8)Projects Completed
4
Freelancers worked with
4
Projects awarded
33%
Last project
4 May 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi...
Do you want to create the database based on the DDL SQL in the dump file, or is the dump file just as a reference.
I am just thinking of what would happen if you change something in the original database. Then you would have to change the dump file definition as well, or do you want to create the new database based on the original database?Ian B.16 May 2017Based on the dump file.
When we want to change the structure in the future we will simply modify the stored procedure.
418852
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies