How to repair mysql database in linux jobs

. Filters Section Enhancement • Current Issue: • Filters are limited in functionality and do not provide an optimal user experience. • Upgrade Requirements: • Add advanced filters for properties (e.g., price range, bedrooms, bathrooms, property type). • Ensure filters work seamlessly on both desktop and mobile devices. • Optimize the backend queries in MySQL for faster filtering results. 2. Map Fixes • Current Issue: • The map is either broken or lacks the necessary interactivity. • Upgrade Requirements: • Ensure the map updates dynamically when filters are applied. • Add functionality for users to click on map pins to see property details. 3. Update Login Options • Current Issue: ...

Reusable Photoshop Templates Company Overview: EB Profix LLC specializes in dental equipment repairs and installation, providing high-quality service to dental professionals. We need custom, reusable, and editable Photoshop templates for our marketing materials to promote our services effectively on various platforms. create a set of reusable and editable Photoshop templates for business cards, flyers, and social media content that can be used across various advertising channels. The goal is to make sure the designs are flexible for future updates and adaptable to various content (i.e., offers, promotions, new services, etc.). The contest winner will be required to submit the following templates in Photoshop (.PSD) format: Business Cards ...

I'm currently facing a challenging situation with my disk encryption. I've forgotten the passphrase for my LUKS encrypted disk. Additionally, I've been experiencing slow read/write speeds, which I've attempted to troubleshoot, but without success. Ideal skills and experience for the job: - Expertise in LUKS disk encryption - Experience with data recovery - Knowledge of disk performance troubleshooting - Familiarity with Linux systems - Strong problem-solving skills - Excellent communication skills

I need a skilled professional to install XUI Panel on my Ubuntu Linux server and integrate it with Plex. The installation will need to accommodate custom user permissions, so expertise in setting user permissions within XUI Panel is crucial. Key Requirements: - Proficient in Ubuntu Linux system - Experienced in installing XUI Panel and Plex server - Able to configure custom user permissions in XUI Panel - Knowledgeable in Linux security best practices Please provide evidence of similar projects you've completed. Thank you.

We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!

I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail

I've accidentally deleted critical files and a user associated with my website. I need a freelancer with solid experience in Divi to urgently rebuild my Home and Contact Us pages and integrate my order system before Monday. Details: - Home Page: This needs a Hero section with a call-to-action. - Contact Us Page: This should include a Contact form and Social media links. Ideal Skills: - Proficient in Divi - Quick turnaround time - Experience with integrating order systems - Good communication skills for timely updates on progress. This is an urgent job. I need the website up and running before Monday. Please only bid if you can meet this deadline.

I've got some leaks in my pool's PVC connections that need urgent attention. The leaks are specifically at the fittings. Ideal Skills: - Plumbing expertise, particularly with pool systems - Experience in repairing PVC connections - Ability to identify potential future issues Please provide a detailed proposal on how you plan to fix the leaks. Thank you!

I'm in need of a skilled technician to repair and repipe the PVC connections around my pool. The leaks are primarily near the filter. Key Requirements: - Assess and identify the extent of the damage - Perform necessary repairs and repiping - Ensure all connections are secure and leak-free Ideal Skills: - Extensive experience with pool equipment repair - Proficient in plumbing and repiping - Able to provide long-lasting solutions Please note, these PVC connections have never been worked on before, so a thorough inspection and careful handling is paramount. I am looking for a professional who can ensure the job is done right the first time.

I'm experiencing consistent formatting problems across all my Google Docs. I need a freelancer to diagnose and repair these issues.

I'm in need of a Windows (Linux would be considered) software application that takes input from an RFID tag, converts it to decimal, sends this decimal to a web API, and displays the returned result on the screen. The current output is HTML, but we can switch to JSON if necessary. The RFID tag readers are OmniKey 5022, with 13.56MHz ISO14443A tags. Currently, we have a simple web page setup with a clock, an entry box, and a submit button. We're using a third-party software to read the RFID cards, but it doesn't always work as intended due to startup sequence issues. This new application should: - Display the web API response on the screen - Not require any user authentication - Show error messages on screen for any issues, ...

My WordPress site has a broken registration process. Users are experiencing incomplete registrations. I need a professional to diagnose and fix this issue. Key tasks: - Diagnose and repair the registration process - Implement security measures to prevent fake user hacks Ideal skills include: - Expertise in WordPress - Proficient in website security measures - Strong problem-solving skills It would be preferable if you could provide some previous examples of similar work you have done.

I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your proposal. Thank you.

Hi Moufi K., We just noticed that you posted a project for "Development of a Virtual Employee (AI) for Building and Modifying Systems in Laravel, PHP, and MySQL" (https://www.freelancer.com/projects/php/Development-Virtual-Employee-for/details)

I'm seeking a professional to design and develop a lead generation website for , inspired by several example sites. This project includes creating SEO-friendly, original content (no copy-paste or AI-generated material) for the following homepage sections: About Us, Services, and Testimonials. Key Role Responsibilities: - Design and develop a user-friendly, attractive website aimed at generating leads. - Write unique, engaging content for the specified homepage sections, ensuring it is tailored to our services and brand voice. - Create SEO-friendly content to boost our online visibility and attract potential clients. - Incorporate sections detailing our offerings: Consultations, Compliance checks, and Repair & maintenance services. Ideal Candidate: Th...

...looking for an experienced WordPress developer to customize and implement a multi-tier affiliate commission system for a unique business model. The system will use Ultimate Affiliate Pro or a similar plugin as a foundation and will require custom logic for commission distribution and affiliate activity tracking. Scope of Work: Affiliate Commission System: Configure a 3-tier commission structure with fallback logic for unclaimed commissions. Ensure proper integration with ticket sales or product purchases. Custom Logic Implementation: Develop conditional logic for affiliate commission eligibility based on activity thresholds. Implement fallback handling for inactive or missing affiliate tiers. Dashboard Customization: Customize affiliate dashboards to display key metr...

I need two methods developed for my Selenium WebDriver + Java automation project. These methods should control the internet connectivity of a RemoteWebDriver instance during test execution. - Th...RemoteWebDriver instance during test execution. - The first method should make the browser offline, and the second should bring it back online again. - Both methods should take RemoteWebDriver as input. - The methods should be tested on both Linux and Windows platforms, and on both Chrome and Edge browsers. - Future-proofing is a plus, as I may require varying levels of network latency in the future. Ideal skills for this project include proficiency in Java and Selenium WebDriver, experience with network simulation in automated tests, and expertise in bot...

looking for a skilled freelancer to create a dynamic website with the following pages: 1. Home Page: A visually appealing and responsive landing page that dynamically displays content. 2. Contact Us Page: A functional and dynamic contact form where user inputs are saved to a database and can be accessed via an admin panel. 3. Blog Page: A blog section where I can add, edit, and delete posts dynamically using an admin panel. The blog should support categories, tags, and a search function. Key Features Required: • Fully responsive design (desktop, tablet, and mobile). • Admin panel/dashboard for managing content (blog posts, contact form submissions, etc.). • Backend development with database integration (MySQL or similar). • Fra...

Build A Social Agent for twitter and Telegram Just follow this video - Skills : AI16Z, pnpm, solidity, linux

I need a MySQL stored procedure that calculates both the Exponential Moving Average (EMA) and the Simple Moving Average (SMA) for stock prices. Key Requirements: - The stored procedure should execute daily. - It should process stock prices data. Ideal Skills: - Proficiency in MySQL. - Experience in writing stored procedures. - Strong understanding of stock price data. - Familiarity with EMA and SMA calculations. The successful freelancer will have the opportunity to work on this project regularly as I need this procedure to run daily.

I need help configuring New Relic on my Linux server. The New Relic PHP agent is already installed, but I need help with monitoring MySQL and Apache. Key monitoring tasks: - MySQL: Performance metrics, Query analysis, Error tracking - Apache: General health and performance - Php performance data, average response time, max execution time in peaks, peaks of memory usage and how much memory is used then. - response data from third party applications monitored. Ideal candidates for this project should have extensive experience with New Relic, Linux servers, PHP, MySQL, and Apache. The ability to analyze and interpret performance data is essential.

I need a professional who can help synchronize my MySQL database with my Telegram mini app. This will allow my webapp users to validate their earnings accurately. Key Requirements: - Database Synchronization: You will be responsible for ensuring seamless communication between my MySQL database and the Telegram mini app. - MySQL Proficiency: A deep understanding of MySQL is crucial, as this is the platform currently in use. - Data Validation: The primary focus will be on validating users' reward points. Ideal Skills: Webapp: php Laravel backend, frontend Vue.js Tailwind CSS php frontend react - Expertise in Database Management - Proficient in MySQL - Experienced in working with Tel...

Need a database of companies: Location: Singapore Industries: any Company Name: 100% Email: 100% Industry: 100% Phone: optional Address: optional Postal Code: optional Numer of companies: max

I am seeking a qualified Biomedical Engineer with expertise in servicing life support equipment. The role encompasses a variety of responsibilities, including: - Equipment maintenance - Troubleshooting and repair - Installation of new equipment General experience with life support equipment is sufficient for this role. There is no need for familiarity with specific brands or models. Your knowledge and skills in the field will be critical in ensuring the optimal functioning of our equipment and providing necessary repairs and installations in a timely manner. Please bid if you possess the required skills and experience.

I have a project regarding a proxy server. Everything is available to me. The server is dedicated and has 32/ipv6. I want to create a proxy that works on social media tools. Now I will attach clips. A clip showing the proxy that I have now and another clip. I want the proxy that I have to perform like it. For those interested, the project will be worth $30 if the proxy is done correctly and as I want, there will be other projects of mine and I will pay him whatever he wants I have now : Linux 24 and IPV6/32 range I just need some one do the proxy like in the video Please anyone he don’t no don’t send massages this things need someone expert

I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM with the database by adding missing fields, such as 'Subscription', 'Rating'. - Identify and clean duplicate and dead records, i.e. blocked email addresses. 2. Database Synchronization: - Develop a Python script for fetching data from our database and updating or adding records in Zoho CRM. - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the...

I'm seeking a freelancer who can compile a full list of estate agents across the entire UK. The deliverable should be a CSV file containing the following information for each estate agent: - Name and Address - Contact Details (including email and phone numbers) The ideal candidat...compile a full list of estate agents across the entire UK. The deliverable should be a CSV file containing the following information for each estate agent: - Name and Address - Contact Details (including email and phone numbers) The ideal candidate for this project would have experience in data collection and market research, particularly in the real estate sector. Proficiency in using tools for data extraction and a keen eye for detail will be crucial for ensuring the accuracy and ...

I'm in need of a seasoned mobile app developer with over 3 years of experience, specifically with expertise in React Native, MongoDB, Linux VPS, Websockets, and BLE app development. The project is aimed at creating a long-term collaboration. Key project specifications include: - Development for both iOS and Android platforms - Essential features such as Bluetooth connectivity, Database integration, Map, and GPS Skills and experience that would make you a great fit: - Proficiency in React Native for cross-platform mobile app development - Experience with MongoDB for database integration - Familiarity with Linux VPS for server management - Knowledge of Websockets for real-time communication - Expertise in BLE (Bluetooth Low Energ...

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code ...

...seeking a skilled freelance developer to build a comprehensive online marketplace platform tailored for the scientific research sectors, similar to and Science Exchange. The platform will connect vendors offering scientific services/products with buyers from academic institutions, biotech companies, and pharmaceutical firms. Project Requirements The project will include the development of the following core components: 1. Admin Panel Comprehensive dashboard to manage users, transactions, approvals, and overall platform settings. 2. Vendor Panel A dedicated space for service providers to list their offerings, manage orders, update availability, and communicate with buyers. 3. Buyer Panel A user-friendly interface for researchers and companies to brows...

Project Overview: I am looking for a skilled developer or team to build a Web-Based CRM System that will efficiently handle various HR and employee management functionalities. The system should provide features such as employee data management, attendance tracking, leave management, salary slip generation, performance evaluation, and other HR-related functionalities. I already have a domain and hosting set up; I only need the website to be designed, developed, and deployed. Key Features to Include: 1. Employee Management: Add, edit, and view employee details (e.g., name, department, position, contact information, etc.). Employee ID generation and profile picture upload. 2. Attendance Tracking: Daily attendance logging with check-in and check-out times. Monthly...

I need an experienced professional to download and install a specific older version of JasperReports, version 7.5, on my Oracle Linux system. Ideal candidates should: - Have deep knowledge of Oracle Linux - Be skilled in software installations on Linux systems - Be able to download and install JasperReports version 7.5 Please provide evidence of similar projects you've completed in your bid.

...for a marketplace platform designed to connect service providers and users. The platform will feature user-friendly booking functionality, provider management tools, and integrated payment systems. The goal is to create a seamless and scalable web application with a clean interface and efficient backend. We are looking for a skilled freelance developer to develop this MVP from the ground up. You will be collaborating with our team to create a polished, functional product within a specified timeframe. Scope of Work Core Features: 1. User Platform: - Search and filter options based on location, category, and availability. - Booking and checkout system with guest and registered user options. - User account management (sign-up/sign-in...

...am looking to create a Virtual Developer Assistant, an AI-powered system that acts like a full-time developer. This assistant should be capable of: Building complete systems and applications based on user inputs (e.g., backend, frontend, databases). Modifying existing systems to adapt them to new requirements. Developing complete applications for web and mobile platforms. Deploying systems automatically to platforms like Heroku, Vercel, or custom servers. The AI assistant must function like a professional employee, capable of handling coding tasks autonomously. The user should only provide high-level instructions, and the assistant should deliver complete, functional systems. Key Requirements: AI Features: Use of OpenAI models (e.g., Codex, GPT) for code g...

I have a corrupted Excel file that I'm unable to recover myself. The file contains complex formulas, and I'm unsure how it was corrupted - it could have been from a software crash, a virus attack, or an unexpected shutdown. - Any experience with data recovery from Excel files would be a plus

...connect my Node.js server to a MySQL database in a Kubernetes environment. The connection should utilize a connection pool. - Connection Type: The connection between the Node.js server and MySQL should be established using a connection pool. This means that multiple connections can be reused, improving the efficiency of data handling. - MySQL Operations: The majority of operations will be writing data to the database. Therefore, experience in optimizing write operations in MySQL will be beneficial. - Kubernetes Service: The Node.js server will be exposed using the ClusterIP service. Familiarity with this service and its configuration is crucial. Ideal candidates for this project should have: - Proven experien...

I'm seeking a skilled professional to create an editable PDF report of a sewer scope inspection. This document should be tailored as a comprehensive sewer scope report. Key Content: - Inspection findings - Repair recommendations - Property and client information - A video of the sewer scope in action Ideal Skills and Experience: - Proficiency in PDF editing software - Experience with creating instructional or inspection reports - Ability to embed video and images into a PDF - Attention to detail and ability to present information clearly and concisely This project requires not just technical skills, but also an understanding of how to present this information in a way that is accessible and easy to unders...

I need to install a page on my website, in PHP 8, where I can select an XLSX file and insert some data directly into the Mysql database. On this import page, in addition to inserting the xlsx file, I also add text to explain what it is about. (example in the link ) I tried doing something like the video above, but it didn't work. Database and rows: INSERT INTO Tablegroup (idgrupo, idplataforma, idpais, idestado, idcidade, idempresa, idusuario, idusuario_indicador, ididioma, membros, group_id, titulo, url, status, categoria, datacadgrupo) VALUES (NULL, '1', '2', '70', '0', '1', '7', '7', '1', '12312', NULL, 'Teste Delete'...

...existing CRM website to a completely new server. Setting up new VM on a Dell Server exclusively for this CRM. Server will have latest (or recent version recommendation from you) Ubuntu OS. Update Suite CRM version to very recent or newest. Current site has 1 plugin – a drag and drop capability that allows users to drag and drop documents and forms in addition to menu navigation importing. Ensure we do not lose this capability by employing too new version of OS or SuiteCRM software. Add capabilities: Email send/receive (standard for SuiteCRM send/receive capabilities) Currently, I cannot login to backend using admin username and pass. I see it there in the mySQL databases; I just can’t get it to login. I beli...

I need assistance with installing on my Linux VPS that has no control panel. I have SSH access to the server and would like to store the data files on a remote server. You will be guiding me not installing it for me. Key Requirements: - Expertise in Linux operating system - Experience with installation - Proficient in Remote server data management - Strong understanding of using SSH - Previous experience with installing software on VPS without a control panel Please provide your bid and timeframe for this project.

My WordPress site is experiencing slow page load times, particularly with blog posts. I need a professional who can optimize the database, as it has a lot of slow queries and the Yoast SEO plugin. Ideal Skills: - Extensive experience with WordPress - Proficient in database optimization - Familiar with Yoast SEO plugin - Knowledgeable in speed enhancement techniques - Able to conduct a thorough site assessment Please note that I have not tried any database cleanup or caching plugins yet. Your expertise in enhancing my site's performance is crucial.

I am in need of a professional who can assist in registering my already established business and setting up a comprehensive database for global news distribution. Key Responsibilities: - Register my business with relevant authorities. - Create a database that caters for news distribution, both in the USA and globally. Ideal Skills: - Experience with business registration processes. - Proficiency in various types of databases, including SQL-based, NoSQL-based, and Cloud-based. - Prior involvement in setting up a news distribution system.

...with my PostgreSQL database and need an expert to analyze, optimize, and fine-tune the system for improved efficiency. The Issues: Memory Underutilization: PostgreSQL is not fully utilizing the allocated 32GB of memory, with usage capped at around 17GB even under high workload conditions. CPU usage spikes to use all 16 cores, even when PostgreSQL is idle. Processing takes too long during periods of high access, resulting in delayed responses. Bottlenecks During Data Loading: Loading large datasets causes significant delays, with processing times exceeding 30 seconds. Query execution slows further during bulk operations. Index and Query Optimization: Some queries are slower than expected, likely due to missing or inefficient indexes. Sequentia...

...developer to create an application for my company. Key Features: - The app will display the current time and company name at the top center of the screen. - Users will log in using a personal number and password, both entered into text boxes. The password will be concealed with an asterisk. - The app will include a button to submit the login details, labelled "Anmelden". - There will be a copyright notice at the bottom of the screen, aligned to the right and in a font size smaller than 16. CSS: Background: #000 Font Color #fff Button Color: orange Authentication: - The app will utilize an NFC system for authentication, along with a clear username and password scheme. - Users will authenticate using a text-based password or NFC. Datab...

I need an expert to help me troubleshoot my PostgreSQL database on a Linux system - Specific on Openproject (Live environment) https://www.openproject.org. The application is hosted on Ubuntu server with multiple applications. Tasks: - Backup application and make sure no damage is done to any other applications running oh the machine - troubleshoot database (OpenProject is not displaying hours spend on projects/tasks) - upgrade OpenProject to latest version (community) Ideal Skills and Experience: - Proficiency in PostgreSQL - Extensive experience working with Linux systems - Ubuntu Server - Strong troubleshooting skills - Ability to diagnose and resolve database issues efficiently

...Overview We need a secure, user-friendly website to serve as an index for manuscripts. The platform will provide authorized users access to a centralized database where they can view, upload, search, and manage manuscript-related information. The system will support file uploads, advanced filtering and search functionalities, and administrative controls. Features and Requirements User Authentication and Authorization Secure, password-protected login system. Role-based access control: Regular users: View and upload files, search/filter manuscripts. Admin users: Manage users, delete files, and oversee all system activities. Password reset functionality. Manuscript Index Ability to store detailed metadata for each manuscript, including but not limited to...

Clearly outline the project goals: Preparing ~1,000 PDF pages with images for fine-tuning. Handling image metadata and linking it to text. Formatting content in JSONL for OpenAI fine-tuning. Specify requirements: Experience with OpenAI or similar tools. Familiarity with data preparation for AI training. Knowledge of technical manuals and metadata handling. Mention deliverables: Clean, structured dataset ready for fine-tuning.

need to update a custom MySql CRM , with fixes at contact dashboard and create a new Pipeline Dashboard using database contacts. please check carefully the doc attached. regards

I'm seeking to create a comprehensive database of North American companies in the medical device cleaning and medical facilities cleaning industries. The database should include email contacts for the CEO and other executive roles. Ideal Skills: - Data mining - Database creation - Market research - Lead generation Experience: - Prior experience in compiling corporate databases - Familiarity with the medical device or cleaning industry is a plus. I will buy lists of 1000 contacts each time I may buy lists from more than one bidder, and may buy more than one list per bidder to the extent the lists provided have the right level of quality. You should quote the price for each list of 1000 contacts.

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code ...