Create a single script and parallel batch file to provide multiple ODOP-specific database operations. Isolate the database access variables in a single file.
The operations may include:
db_size
dump_db (backup)
dump_restore_db
create_db (?)
load_all (?)
dump_db_startup_files (?)
dump_restore_table (?; not yet written)
The database access variables for Development, Test, Staging and Production databases include:
type (development, test, staging, production)
user
password
host
database
This approach should allow a reduction of the number of files in the scripts folder and entries in the .gitignore file.
Create a client/docs/procedures entry describing use of the script/batch_file to recover from a database full situation.
Create a single script and parallel batch file to provide multiple ODOP-specific database operations. Isolate the database access variables in a single file.
The operations may include:
The database access variables for Development, Test, Staging and Production databases include:
This approach should allow a reduction of the number of files in the scripts folder and entries in the .gitignore file.
Create a client/docs/procedures entry describing use of the script/batch_file to recover from a database full situation.