Bash script mysql query sendmail jobs

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

...developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Ski...

...should be a step-by-step walkthrough, including screenshots to help illustrate each point. - - Extensive experience with Discord and great communication skills are must-haves for this project. I look forward to seeing your proposals. 3. For the voice over i will give you access to my elevenlaps account where i cloned my voice you can use my voice for the videos all you have to do is write the script and it will generate the voice for you. each video i will be paying $7 Australian dollar which is $4.5 Us dollar. 7*10=70 which is about $45 Us dollar. If we understand and i like your quality of work I have additional 50 discord short tutorial videos that needs to be done. Each video I will be creating a seprate milestone so video 1 $7 and so on. Also you will be signing IP...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need...

I need a FB cover photo for a group. The Title should be "Merchants of Camelot" and say "Hosted by Andrea Oliver". It should include the attached image in black & white and the website Colors - Yellow/Gold and Dard Red Theme - Camelot with Red Roses Fond - Variations between script, bold and regular are appreciated.

I'm looking for a professional who can set up an automatic download of mainly .csv files from FTP, SFTP, https and webscraping-login. The script should be configured to run daily/weekly at pre-defined time - configurable for each file. Requirement: Check after each download that the download has actually been downloaded. Notify user if any errors occur. Key Requirements: - Configure FTP download automation on Windows enviroment or hosted. - Schedule the download to occur at defined day/hour. - Check if download has been succesful. - Clear commented code. I only respond to bids where the bidder clearly has read the description...sorry (not really sorry, lets not waste each others time :) ) I prefer fixed price, but have entered hourly - let me know your suggestion.

Describe in your proposal if you have had experience with ready-made slot games, if you have done any, share a reference link. Preference is for freelancers who already know this script the front end according to the references below. Insert a clock into the prize draw template. Note: I will provide the watch. Create a more attractive presel, redirecting users to the Telegram group. Review and correct the prize draw model to carry out a draw scheduled by date and time and display the draw winner randomly and automatically

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...

I'm seeking Spanish speakers for a project where you will be reading conversational scripts in a formal tone. Your role will be to: - Read Spanish scripts in a formal tone - Ensure the scripts are conversational in nature The ideal freelancer for this job would have: - Native proficiency in Spanish - Ability to convey a formal tone - Experience with voiceover work would be advantageous - Knowledge of different regional Spanish accents is a plus. PLEASE FIND ATTACHED THE PROCEDURE YOU NEED TO FOLLOW TO DO THE RECORDING.

...server to send out automated email notifications for a custom-built application. Key requirements and expectations for this project include: - Setting up an SMTP server specifically utilizing Sendmail software on a Debian server - Ensuring that the configuration is optimized for automated email notifications - Providing guidance or documentation on how to integrate the SMTP server with my custom-built application Ideal candidates for this project should possess the following skills and experience: - Proficiency in working with Debian servers and setting up SMTP servers - Prior experience with Sendmail configuration - Understanding of how to optimize SMTP servers for automated email notifications - Capability to provide clear documentation and guidance for integration w...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I'm looking for a skilled Python developer who can create a tool that can convert VCE (Visual CertExam) files to PDF. The script needs to be compatible with Windows, and ideally, it should: - Provide output in a format that is both viewable and editable - Operate solely via a command line interface Ideal applicants will have experience in Python programming, data manipulation, and an understanding of file conversion processes. A background in creating command line tools is a plus. Your experience in delivering clean, efficient code is highly valued. Please provide examples of previous work when applying. I'm on a tight budget ($10 - $15)

Hi I will share the details with the shortlisted candidates. Thanks

I will make a script SuperTrend AI & StochR & Squeeze v1.1, as detailed in this document:

This is a juke box musical, i have a loose storyline. See the website with the same name.

...developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data security and ...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading PDF files; the ...

More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.

Website Designer , Php , E Commerce having knowledge of MySQL

I'm in need of an experienced Java Script developer that can resolve a peculiar issue with my implementation. Here are the specifics: - All of the data I'm showcasing are ALL DAY events. - The events are not appearing in the Week and Day views, however, they do display as expected in the Month and List views. - I am using a version of that's not the latest. I'm looking for a professional who can: - Investigate the issue and implement a fix to ensure the ALL DAY events are correctly displayed across all views. - Offer advice on whether updating to the latest version of would help address the problem. The ideal candidate should have: - Profound experience in Java Script development. - A deep understanding of functionalities and

Please Sign Up or Login to see details.

Hi please help, very quick project making a VIN decoder. I need an expert to help me integrate a Zoho Creator form with rapidAPI.com. Here are the details: 1. I have a simple zoho creator form with following fields: Inp...creator form with following fields: Input fields: Rego State Output fields: Vehicle_Make Vehicle_Model Year_field Vehicle_Type 2. Field "Rego" should have dummy data "830IC3" Field "State" should have dummy data "QLD" By entering dummy data into input fields, I need script to fetch vehicle details from this API: API has free subscription. 3. I have made the attached Deluge script, but something is broke, it's not working. Can you please make a deluge script to pull data out of this API? Than...

...skilled designer to transform a video script into an engaging infographic. The key content for this project is expert advice on the subject matter. Requirements: - You will need to create the infographic in Canva (editable Canva file to be shared with me), using the provided colour palette and logo. - The design should be visually appealing and easy to grasp. - The expert advice should be presented in a high-level overview format. This means you should distill the advice into brief, impactful insights. Ideal Skills and Experience: - Proven experience in infographic creation. - Familiarity with Canva. - Ability to interpret and present expert advice. - Attention to detail and creativity to make the design visually appealing. Here is an example of the script to be conver...

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

I'm looking for a talented scriptwriter who can help me to craft a terrifying script for my YouTube horror video, which consists of vlogs of people who encountered some strange things during their vlogs. Key requirements: - Tone: I'm aiming for a horror theme, with a specific focus on mystery. The script should keep the audience on edge, eager to discover what happens next. - Audience: The video will be targeted at viewers of all ages, so the script should be engaging and scary without being overly explicit or inappropriate. - Elements: I'd like the script to include a strong mystery plot. The idea is to captivate the audience with a series of unexplained events, leaving them wanting more. Ideal skills and experience: - Proven experience in sc...

...first script as per the below mentioned instructions which you provided me. We’re looking to bring the remarkable journey of Domino's Pizza to life in our next faceless YouTube video. We want this script to feel like a casual chat between friends, not a boring video simply stating facts. The tone should be light, engaging, and sprinkled with a touch of humor or irony here and there. Here's what we're aiming for: - Tone and Style: Think of telling a fascinating story to a friend over coffee. Your script should be conversational, lively, and engaging. Although we're not looking for a "funny" video per se, feel free to throw in witty remarks or playful jokes to keep things interesting. - Content Points: * You have complete creat...

I'm in search of a specialist who can assist in installing a Flutter script for a full app on both iOS and Android, alongside the required admin panel. Key Requirements: - The Flutter script is already chosen; hence, the primary need is for installation and configuration. - The app design is ready in the form of a mockup, which will be provided to the successful freelancer. Ideal Skills and Experience: - Proficiency in Flutter and its setup is a must. - Familiarity with configuring admin panels for Flutter apps. - Prior experience in installing pre-made scripts for full app development. - Strong communication skills to ensure that the provided design mockup aligns perfectly with the final product. The role is primarily focused on the technical aspect of the project, ...

I need a proficient scriptwriter experienced in writing captivating recaps for English films in Telugu. While I have not specified a specific genre, you should be flexible and versatile in writing for a broad spectrum of genres from action, comedy to romance. Key Requirements: - Write a 10-15 minute movie script. - Experience in writing Telugu movie scripts. - Ability to work with a diverse range of genres. - Understands the various target audiences of Telugu cinema, from adults to families and teenagers. If you are a scriptwriter with a knack for engaging readers and can create a short recap that is an exciting consumption of a Telugu film, then I would love to hear from you.

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs ...discussed based on project scope. Timeline: Fastest to complete. Preferred Communication Channel: Freelancer platform messaging system. Additional Notes: Collaborate closely with frontend developers to ensure seamless integration. Prioritize security and data integrity in backend implementation. Skills Required: Node.js RESTful API Development Database Management (e.g., MongoDB, MySQL) Authentication and Authorization Systems

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

...Project Overview: The developer will be responsible for setting up Apache Kafka on a Windows environment and developing a master script and worker scripts to facilitate distributed messaging. The key requirement is to implement a mechanism for bulk-reviewing messages in the queues every 10 minutes to filter out unnecessary messages and optimize system performance. Responsibilities: Apache Kafka Setup: Install and configure Apache Kafka on a Windows machine. Set up the necessary Kafka topics, partitions, and brokers to support distributed messaging. Ensure proper security configurations and access controls are in place. Master Script Development: Develop a master script that acts as the central controller for the messaging system. Implement functionality to bulk-r...

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

i am looking for someone who can generate quality Tech support calls from google and Native ads networks. I will provide script, cloaker, hosting domain, landing page. Should have good knowledge and Provide guidance for campaign running

I need a skilled developer with google app script experience to adjust an existing Google App Script that's currently dealing with scraping linkedin from google search api. The purpose of the limit was initially for getting quality data, however, it's currently hindering my ability to extract more social media content - which is crucial for my project's success. I need quick tweak to the script to ensure the limit is removed. It should not only allow for a larger volume of data to be extracted but should also be optimized to prevent any potential server resource issues. Ideal skills and experience for this job include: - Proficiency in Google App Script - Prior experience with web scraping and data extraction - Ability to optimize scripts for p...

I'm seeking a professional to assist with integrating my python scraping script output to my personal WordPress site in real-time. Key Requirements: - The integration should be real-time and without the need for page refresh - The current output of the python script is a CSV file, but can be Json or another Ideal Freelancer: - Proficient in Python and WordPress - Experience with real-time data integration - Familiarity with data formats (CSV, JSON, etc.) - Excellent communication skills to deliver a seamless solution Looking forward to working together.

I'm seeking a developer who can create a script or plugin that pulls content from Facebook, Twitter, and Instagram on a daily basis and automatically imports them into my WordPress site as separate posts. Key Requirements: - Scheduled Import: The content should be imported into WordPress daily as individual posts. - Post Categorization: Each imported post should be assigned a category based on its source (e.g. Facebook, Twitter, Instagram). - Immediate Publishing: The imported posts should be published immediately upon import. - Instructions on how to setup App/ID/secret for each social channel Ideal Skills: - Strong knowledge of WordPress and its internal mechanisms. - Proficiency in working with the APIs of Facebook, Twitter, and Instagram. - Experience in developing autom...

...to develop scripts for five short social media commercials. These commercials are intended for a middle-aged adult audience and will primarily be aired on social media. The script should be around 15-30 seconds and show easy understandable Research about Low Carb food health benefits. Here is an example: The source of the data you write about should be included. Key Requirements: - The focus of the commercials is to inform the audience about our product/service effectively. - Each script should be concise, engaging, and able to hold the attention of the listener. - It should be tailored to appeal to the specified demographic (middle-aged adults). Ideal Candidate:

I'm in search of a skilled Python programmer to create a Python script that's focused on data manipulation, automation, and user interaction. Key Requirements: - The script should primarily function outside of a website, as a standalone application. - It should be capable of manipulating data, performing automated tasks, and engaging with users in a user-friendly way. Ideal Skills and Experience: - Strong proficiency in Python is a must. - Previous experience in creating standalone applications that involve data manipulation, automation, and user interaction.

I'm in need of a skilled programmer to develop a script that can serve as both a Man-in-the-Middle (MITM) and a Reverse Proxy tool. The primary goal of this script is to assist me in intercepting network traffic and bypassing certain network restrictions. Key Project Requirements: - The script should be compatible with Windows, MacOS, and Linux. - It should effectively intercept network traffic and support the following network protocols: HTTP, HTTPS, and TCP. - The script should also have the capability to act as a Reverse Proxy tool when needed. Ideal Skills and Experience: - Proficiency in programming languages like Python, C++, or Java. - Experience in developing network security tools or reverse proxy systems. - Knowledge of network protocols and th...

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial for my b...

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur Budget: $8 per speaker. We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Libby

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Echo

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candida...Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast and communicate ...

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...

I'm seeking a proficient scriptwriter to design an Airtable script that can effectively combine data from a single table that consists of parent-child relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experien...

We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.