Bash: removes and imports the mysql table
The task:
Create a bash script that removes the table1 every hour and immediately after it is removed, imports the table2
More detail, as I see the result:
In the folder on the server is the script.sh and the table2.sql file.
Through the planner every hour the script removes the table1 and instead imports the table2.sql.
that is. you need the script.sh itself, as well as the planner's team for its launch, as well as a short instructions on the starting setting.
This is all.
Client's review of cooperation with Vladimir Ilchishin
Bash: removes and imports the mysql tableFast and in case. satisfied with the work. I recommend it.
Freelancer's review of cooperation with New Consult
Bash: removes and imports the mysql tableI recommend the customer,
Nothing is excessive, everything is a pleasure.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 1 day 22 hours back ∙ 51 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day 23 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 11 hours back ∙ 10 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 17 hours back ∙ 12 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 15 hours back ∙ 26 proposals |