Mariadb jobs

I am having a login issue and undefined variable error on my Magento store and need it resolved urgently. To help speed this up, I can provide access to my site's backend, so the issue can be resolved as quickly as possible. This on our test domain and it seemed to happen after moving hosts. Important: Please bid based on 3 hrs of work and if it takes longer than that we can...can provide access to my site's backend, so the issue can be resolved as quickly as possible. This on our test domain and it seemed to happen after moving hosts. Important: Please bid based on 3 hrs of work and if it takes longer than that we can start new job. Thanks. Once this task is done I will be exploring some server side optimization testing (ie litespeed, opcachem, memcached, testing mariad...

...web-based back-office tool designed to streamline communication across multiple platforms, including email, WhatsApp, Facebook, Instagram and others. The primary function of this tool is to consolidate incoming messages from these varied channels into a single, unified interface where office users can easily manage and respond to communications. Preferred framework: React, Preferred database: MariaDB, MongoDB; later to be Amazon RDS for AWS Core Features: 1. Multi-Channel Integration: The tool should be capable of receiving messages from various communication channels including but not limited to: - Email - Website/App-Chat - WhatsApp - SMS - Signal - Facebook Messenger - Instagram Direct - Twitter - more channels to be added 2. Unified Inbox: A ...

We have a server which receives users requests, call third parties API, get response and notifies users. We are experiancing PHP crushes in case the third party API respond slowly (Many pending requests). We are lloking then a expert to see logs and cause of those...requests, call third parties API, get response and notifies users. We are experiancing PHP crushes in case the third party API respond slowly (Many pending requests). We are lloking then a expert to see logs and cause of those PHP down and do necessary so that PHP can still working even in case of many pending requests waiting response from third party API. The server is Centos 7 and use Mysql MariadB database. Mysql still working fine when PHP goes down. I want you you describe how you caount to proceed. Not seriou...

I am in need of a SQL query expert who has experience working with Sphinx search. The specific problem I am trying to solve is improving search performance. Database System: MariaDB I do not have any specific requirements or criteria for the SQL query, and I am open to suggestions. Ideal Skills and Experience: - Proficiency in SQL query optimization - Experience working with Sphinx search - Strong understanding of MySQL database system - Ability to suggest and implement effective solutions for improving search performance

I have custom MariaDB installation for Windows. I am looking for a skilled professional who can optimize my MariaDB file. The maximum size of my MariaDB database is less than 500MB and it uses only ARIA tables. Program with MariaDB can be installed on different machines, they can be from 2GB-16GB RAM or with CPU with 2-7-or_more cores. Person who bids needs to be expirienced with optimizing MariaDB database performance and configuration, wiling to spend some time in chat and explaining his/hers reasons for adding/removing/altering specific values. Payments will be released on work completion.

mysqldump suddently not working upon running the query shows error mysqldump: Couldnt execute 'show fields from 'table1' : Lost connection to Mysql Server during query 2013 This is a mariadb 10.3.39 version installed on Rockylinux

Hi, I need to setup a python automation to BACKUP databases on my LINUX machine that will scan and read ALL the databases from the server mariaDB giving connection settings as url, port, username, password, analyse and check my given list of databases in csv or excel as one on each line, etc. and backup the tables of each database name provided one by one and BACKUP / SAVE the tabales of each database in this structure root/folder_database_name_1_sql/services_table ; root/folder_database_name_1_sql/products_table, root/folder_database_name_1_sql/courses_table etc. THEN FOR THE 2nd database root/folder_database_name_2_sql/services_table ; root/folder_database_name_2_sql/products_table, root/folder_database_name_2_sql/courses_table etc., so on for all

Hi, This is a python project. I need to setup a python automation on my LINUX machine that will scan and read ALL the databases from the local server mariaDB giving connection settings as url, port, username, password, analyse and check my given list of databases in csv or excel as one on each line, etc. and delete / drop the tables of each database name provided one by one! !IMPORTANT! I do not need and I do not want to delete the whole database because it will affect the whole processes of the server and that's very slow too. I just need to go into a given list of database names and select each database from the list and drop the tables one by one. This should run daily. Looking forward to work with someone with experience in python. Best

Hi, I need to setup a phyton automation on my LINUX machine that will scan and take my each one of my .zip databases from the folder path backups/todaydate/, backups/todaydate/, backups/todaydate/, backups/todaydate/, etc. and IMPORT those into the MariaDB local database. Ideal it MUST import only the tables with difererences OR to drop the 1 day older database and import the new database of today. This should run daily. Looking forward to work with someone with experience in phyton. Best Regards

Create a CRM Website Backend - Node Frontend - React Database - MariaDB

Create a CRM Website Backend - Laravel Frontend - Any Database - MariaDB

Create a CRM Website Backend - Node Frontend - React Database - MariaDB

**Description:** We are in search of a highly skilled developer with a deep understanding of optimizing MySQL MariaDB queries. **Project Scope:** - The developer will conduct a thorough analysis of all database queries, with a particular focus on identifying and addressing slow queries. - This analysis will encompass both normal and peak usage periods, as our server currently handles approximately 40,000 queries per second. During peak hours, the server experiences high load averages and CPU usage. - The developer should possess the expertise to access slow queries via SSH and, if necessary, utilize tools like Percona for in-depth analysis. **Deliverables:** The developer will provide a comprehensive report with the following details: 1. Identification of slow queries: A li...

...syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (cpotv.manage_stock = 1)' at line 1, query was: SELECT DISTINCT `cpotv`.`option_id` FROM `catalog_product_option_type_value` AS `cpotv` WHERE (option_id IN ()) AND (cpotv.manage_stock = 1) Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (cpotv.manage_stock = 1)' at line 1 Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB...

I need a basic site where I can create persons, set up monthly plans under that person, and keep track of payments (by person, and link the payment with their specific plan). The person can have multiple plans. Login/logout, and keep track of which user recorded which payment. All data entry will be done manually, so for now, there's no need for any API integration. I would prefer that...person, and keep track of payments (by person, and link the payment with their specific plan). The person can have multiple plans. Login/logout, and keep track of which user recorded which payment. All data entry will be done manually, so for now, there's no need for any API integration. I would prefer that this is created with PHP and framework of your choice (Codeigniter if possible), and...

Project Title: Troubleshoot and Fix Constant MariaDB Shutdown Issue on Windows OS The Job Should be done on Anydesk. the error i get: The full MariaDB error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/lib/mysql/' (111) Attached is what my website looks like Description: I am experiencing a recurring issue with my Virtuamin MariaDB on my Windows operating system. The database consistently shuts down, requiring manual restart or even VPS restart on Hostinger. I am seeking a skilled professional who can help me resolve this issue and ensure a stable and uninterrupted operation of the MariaDB. Skills and Experience Required: - Strong expertise in troubleshooting and fixing MariaDB issues on W...

I need a basic site where I can create persons, set up monthly plans under that person, and keep track of payments (by person, and link the payment with their specific plan). The person can have multiple plans. Login/logout, and keep track of which user recorded which payment. All data entry will be done manually, so for now, there's no need for any API integration. I would prefer that...person, and keep track of payments (by person, and link the payment with their specific plan). The person can have multiple plans. Login/logout, and keep track of which user recorded which payment. All data entry will be done manually, so for now, there's no need for any API integration. I would prefer that this is created with PHP and framework of your choice (Codeigniter if possible), and...

I am looking for an experienced Ubuntu Server Administrator to assist me with the following tasks now: SSL Installation ( we will provide the SSL Certificate ) MYSQL Database ( MariaDB ) php8.2

Hi, I'm lookin...Script should also be able to automatically purge the old database entries. 8. The Script should also work if a user has disabled Cookies and Caching in his browser. 9. The Script should also have an option to enable FingerPrintJS (). 10. The page load should not be impacted to much by this Script. 11. Needs to be compatible with PHP 8.2 and MySQL 8.4 (MariaDB 10.11) and vanilla JavaScript (No jQuery). 12. All additional improvement ideas your bring into this Project will be paid extra. -> Please post what coding method you would use to stop/remove the rendering of the Ad HTML code for a blocked IP address. -> Also quick post your creative way on how you would code this script and why it would be the best solution in your option.

I am looking for an Ubuntu - MariaDB - Wordpress Encryption Expert to help me with the implementation of AES-256 encryption for my database. Here are the specific requirements for the project: Specific Encryption Method: - AES-256 encryption method Encryption Implementation: - I need assistance with the implementation of encryption for my database Components for Encryption: - Encryption should be applied to the database only Ideal Skills and Experience: - Strong knowledge and experience in Ubuntu, MariaDB, and Wordpress - Expertise in AES-256 encryption method - Experience in implementing encryption for databases - Familiarity with database security and encryption best practices If you have the necessary skills and experience, please provide your proposal for this projec...

I am looking for a talented web developer who will be able to create a customized web application for coffee cultivation management. I need an application to be created to carry out all coffee production management. This application must be developed with Java + Spring Boot and MariaDB. Requirements: -It is possible to register numerous farms; -It is possible to register numerous plots; -It is possible to register numerous Harvests; -It is possible to register numerous users; --It is possible to register numerous employees; -On each farm, I can have 1 plot or many. -Each plot is planted with a quantity of coffees; -Each plot receives care such as fertilizers and labor during a harvest. And all of this has costs; - The harvest lasts 11 to 14 months; -The system must calculate the en...

...merging our housing sales and administration system into a unified system - Solving support tasks that require a programmer - Participate in operations and onboarding to the extent necessary We imagine that you: - Has 5+ years of experience as a programmer, including as a Java programmer - Understands and can write SQL statements and knows the difference between an inner and an outer join (We use MariaDB/MySQL) - Has experience working in Vue.js on the front end. You will initially primarily work in Vue, b - Has experience working in Jira (and preferably also a little ) - Willing to work in an agile Scrum based setup - Speaks and writes English fluently, so you can easily collaborate with your future colleagues in India - Understand IT architectures, but that you are not an ...

...orders. Our infrastructure utilizes MariaDB, and we are urgently seeking a seasoned database specialist who can diagnose the bottlenecks and implement solutions to optimize and speed up our database. Responsibilities: Conduct a comprehensive audit of our current database structure and configuration. Identify inefficiencies and performance bottlenecks within the database. Develop and implement a plan to optimize the database, focusing on speeding up order retrieval and other WooCommerce-related queries. Work closely with our internal team to test and validate the implemented solutions. Provide documentation on changes made and offer best practices for maintaining optimal database performance moving forward. Requirements: Proven experience optimizing MariaDB databases, sp...

I am in need of an OKD/Openshift expert who has specific expertise in installation and configuration. Project Timeline: - The project needs to be completed within a short-term timeframe, preferably within a week. Acce...completed within a short-term timeframe, preferably within a week. Access to System: - I will be sharing my screen and the freelancer help me to complete the task. - Or if needed, I'm sharing access and the freelancer needs to do the necessary deployment. Ideal Skills and Experience: - Strong experience in OKD/Openshift installation and configuration. - Operator and Helmchart - Nextcloud and Mariadb - Proficiency in troubleshooting and debugging any issues that may arise during the project. - Expertise in application deployment and scaling on the OKD/Open...

We're looking for someone to configure a Microsoft Power Automate operation that does the follow: Operation 1: Logs into a website (if it's not already signed in) Clicks a button Filled out a booking form based on values stored in a MariaDB database Wait for the success message Update our database of successful post Operation 2: Login to the same website Exact data from that page and store it in in our database Operation 3: If data in our database changes: Login to the same site Open a specific URL (stored in the database) Click a couple of buttons and fill out the form. Click Submit. There are a couple of extra steps involved, error handling, checking, validation etc. We're developers, we can help with database query, or an API to format the data as JSON or what ...

I am looking for a skilled PHP developer who can create a script using the Gmail API to receive emails. The script should have the following functionality: - Receive and access emails using the Gmail API - Sort and filter received emails by sender, subject line, and body - Store the email in a MariaDB database. - Move emails to a folder or spam depending on the rules. Ideal Skills and Experience: - Strong proficiency in PHP programming - Experience working with APIs, specifically the Gmail API - Knowledge of email handling and filtering - Attention to detail and ability to accurately sort and filter emails - Familiarity with Gmail API's documentation and best practices The end project will have our involvement, once the emails are stored in the database, a cron will run ove...

...to point to the new server which may take 4-24 hours. - Snapshots of your current VPS will NOT carry over. - All dedicated IPs will be migrated over to the new server. - If you are using custom nameservers, the glue records will need to be updated to match the IPs on the new server. - The main PHP and MySQL/MariaDB versions the websites run on will be updated. Please confirm with your developer that there would not be an issue with newer versions of PHP and MySQL/MariaDB. Please keep in mind that newer operating systems may be limited on what PHP versions are available. - Any modifications done to the server with root access or requested custom configurations will not carry over to the new server. If you need time to work through this with your developer, plea...

I am looking for a skilled developer to create a mobile-first webpage ...Verify using compareFaces to see if user photo matches their ID, return an error if it does not. 5. Submit Fail: If face isn’t detected; liveness fails; id isn’t detected and/or text is not found; face/id do not match and/or other errors, return to form w/ validation errors. 6. Submit Succeed: If everything checks out, write the form inputs to database; write what was extracted from the ID to a MariaDB database I assume for demo we won’t want to store the images but in real scenario we might One important one: there are many types of driver's licenses -- we are looking to capture info from the 10-provincial driver licenses, and 50 state driver licenses at least. If we can OCR f...

...objectives: - Set up a NestJS backend to securely interact with a MariaDB database using Prisma ORM. - Implement a login feature in the Angular frontend. - Enable users to create, edit, and email quotes and invoices to clients. - Containerize the entire application using Docker and deploy it on a server. requirements: step1_backend_setup: - Set up a NestJS backend - Use Prisma ORM to establish a secure connection with a MariaDB database - Dockerize the backend and database step2_login_data_management: - Implement a login feature in the Angular frontend - Design a data structure for quotes and invoices using Prisma ORM - Enable users to create and edit quotes - Store this data in the MariaDB database step3_email_functiona...

...existing website, which is primarily based on PHP (procedural) and MySQL. The ideal candidate should also be able to connect the website to chatGPT. Our website has been developed for several years and is used to support surveys, data analysis and report generation. The main tool we use is the WWW using PHP 7.4 and jQuery, and we additionally use the library. Our database is based on MariaDB 10.6. Specific requirements for this project include: 1. We create statistical reports on the website based on the responses of surveyed participants, at this point each report is created separately, we want to create reports automatically based on previously created ones. 2. Combining our reports with chatGPT to create verbal descriptions of statistical data I am open to the possibilit...

take the code of an opensource CRM and edit it to add an extra function that would be to create multiple sales channels since it only allows you to create one, the CRM is EspoCRM. This means that there should be new functions for it to be functional such as: 1- graphs per channel (all graphs generated can be filtered by chan...channel) 2- create user groups (already exists but you must be able to add user groups to a channel) 3- edit a channel: currently it is possible to create multiple stages in a channel, that means that each channel should be able to manage the stages and the graphics should be functional from those stages. Technical data Apache, Nginx, or IIS server; with PHP 8.0, 8.1, 8.2; MySQL 5.7 (and later), or MariaDB 10.2.2 (and later), or PostgreSQL 15 (supported experi...

I am looking for someone to migrate my mariadb database from its current platform. I have a current backup of the database, which is between 3GB in size. I am seeking someone who is highly experienced with databases to ensure a smooth and successful transition. My current database system is MySQL, but I am open to suggestions should there be a better alternative. I am looking for a quick turnaround, with a smooth and secure transition. Please contact me if you have any questions or concerns regarding this project. Thank you for your time and consideration.

I am looking for someone who can upgrade my PHP installation to 8.2 / or do the entire WP installation from scratch. --------------------------------------- 1. PHP ( 8.2) 2. latest version of WordPress ( 6.3) on my Linux server. 3. install mariadb ( latest) . 3. The server is running Amazon Linux 2 (EC2) and I have root access. 4. person has to do this via shared screen on zoom meeting -- since SSH credentials sharing is not being allowed by client. 5. Ensure WP basic page comes up without errors.

Project Title: Fix Debian / Apache2 / MariaDB freezes I am experiencing freezing and crashing issues with my Debian/Apache2/MariaDB setup. The freezing and crashing appear to be random and not tied to any specific task or action. Just one freeze around 5am is very common, the other one or two over the day seems random. I found one article about MariaDB freezing which exactly describe my problem: Ideal Skills and Experience: - Strong knowledge and experience in Debian, Apache2, and MariaDB - Expertise in troubleshooting and resolving freezing and crashing issues - Ability to diagnose and fix issues without error logs or reports - Familiarity with server performance optimization techniques -

I reinstall virtuemart and the site is not working Go this on error home page You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND = 1' at line 3 Module refering to virtuemart category not working as well Got some error mess installing virtuemart , see attachment Dedicated server on plesk

fix mariadb database server on whm, bad uninstallation of mysql Governor

I am looking for an experienced Android developer to fix two bugs in my existing app. (Adding item to the cart) is what we are facing issue in. The app crash if you try to add additional items to the shopping list. I need these bugs fixed within a week. Skills and experience required: -...crash if you try to add additional items to the shopping list. I need these bugs fixed within a week. Skills and experience required: - Strong knowledge of Android development - Experience in debugging and fixing app crashes - Familiarity with different Android versions and devices to ensure compatibility 1) jdk - Version 1.8 2) Eclipse – Version 4.6.3 3) Tomcat – Version 8.0 4) DBMS – MariaDB 10.2.7 5) DataBaseTool – MySQL Workbench 6) ExERD - Ability to work...

We are looking an high experienced PHP developper with experience with Cake PHP and familiar with SOAP, WSDL, REST APIs to hire him per hours work (5h per week) and for long duration (more than 1 year). CSS/HTML required. Database (Mysl, MariadB) / server (Linux, Centos7) administration and optimization will be advantage. Having realized integration with mobile operators (airtime top up, USSD) will be excellence. Let us know your Hour Rate and your experience. Thanks.

I am looking for a skilled freelancer to upgrade my MariaDB to the latest version. The project needs to be completed as soon as possible. Requirements: - Experience in upgrading MariaDB - Knowledge of the latest version and its features - Ability to ensure a seamless upgrade process Ideal skills: - Strong understanding of database management systems - Proficiency in MariaDB administration and optimization - Familiarity with data migration and backup procedures Currently it is installed on a Ubuntu server and running cyber panel which hosts a number of Wordpress websites. Please ensure a backup is done of the cyber panel and Wordpress database. Please provide examples of previous MariaDB upgrade projects you have completed successfully.

...performance optimization techniques - Familiarity with object caching and its implementation in WooCommerce - Proficiency in analyzing and optimizing database queries - Experience in improving page render speed for e-commerce websites Some of our server and website stats - We have a high perfomable server running NGINX 1.18.0., PHP 8.1.22, Operating System Linux 5.10.0-21-amd64 x86_64, 10.10.6-MariaDB-1:10.10.6+maria~deb11 more info we can provide in message - Our shop run about 80 plugins which are required - We use WP Rocket cache which delivers average about 0,035s response of cached pages - We need to optimize the response of the server on e.g. ajax queries like product filters which now load in about 2 seconds which is inacceptable for us. For us is ideal under 1 second..e....

I am looking for a skilled Laravel developer to migrate the backend of our administrative portal. The current state of the backend is using wordpress and I want to migrate it into Laravel 10.x I am looking for a freelancer who does have following skill: PHP 8.2 Laravel 10.x MariaDB Vue.js The person should have also experienced dealing with linux environment as my application hosted on digitalocean ubuntu image

Please Sign Up or Login to see details.

I NEED A TECHNICIAN WHO IS WELL-VERSED IN MYSQL (MariaDb). I have my VPS set up with Centos 7 and Cyberpanel. I believe I may have deleted a root user or revoked some privileges, which currently prevent me from creating new databases. I cannot create new databases either with PhpMYAdmin or with Cyberpanel. It tells me I do not have the privileges to create databases. In my existing databases, I can still create new tables and use them as usual. I do not want to and cannot reinstall Mysql, as Cyberpanel would likely not recognize the new installation. Additionally, I already have tables in other databases that could be lost. I need a technician who is proficient in MYSQL server and can restore the option for me to create databases with PhpMYAdmin as usual. Thank you very much in...

I am looking for an experienced Angular Node.js and MariaDB application developer to create an application with user authentication and authorization. The application should have a moderate level of user interaction, and should have a user-friendly design. This application should be able to handle multiple concurrent users and provide real-time data streaming, data visualization and analytics. If you have experience developing similar applications, know how to use a variety of methods, frameworks and platforms, then please submit an offer. Let me know your skills, relevant experience and portfolio. I'm looking forward to seeing your ideas and suggestions.

I am looking for someone to upgrade my Ubuntu 18.04 to 22.04 on my virtual server (hosted by Strato in Germany) which is running a Moodle 4.1 and a Joomla 4.3 site. It is important that both the Moodle and Joomla sites will work flawlessly after the update and the downtime is as short as possible. I can provide more specifications of the installations (MariaDB version, PHP version etc.) if needed. Thank you for making a good offer. Let me know if you need more information.

Hello World:) I hope you are feeling well. I am contacting you because I need to develop a mobile application that allows me to generate QR codes from a database (MariaDB) and have the application disperse the QR code. The application must be compatible with Android and iOS operating systems. Users must be able to log in with a username and password. The code must be 10 numeric digits. The code must be able to be shared from within the app via different media/platforms, such as WhatsApp, Telegram and Messenger. From within the application, users must be able to create new users. From within the application, users should be able to create the QR code from a pre-registration form (the code would be customized according to the user, resident or visitor data). I attach a number of r...

Project Title: MySQL MariaDB Recovery from FRM and IBD File Description: I am in need of a skilled professional who can assist me with recovering my MySQL MariaDB database from FRM and IBD files. The project details are as follows: File Size: - The FRM and IBD files are less than 1GB in size. Backup Availability: - I have backups of the database, but they are old and may not be up to date. Recovery Timeframe: - I am looking for a short-term recovery process, ideally within a week. Skills and Experience: - Proficient in MySQL and MariaDB database recovery. - Knowledgeable in working with FRM and IBD files. - Experience with restoring databases from old backups. If you have the necessary skills and experience to handle this project, please submit your proposal.

- You will get a fresh minimal installation of a dedicated server - you need to make a ftp account on the server, send me the creditals i will upload all files of the project including sql dump file - extract all and check what php/apache version is needed and mysql or mariadb version is needed - you need to install apache or nginx with all needed extensions as the project needs - you need to install mysql or mariadb and a phpmyadmin as the project needs - make the project run again

Title: Support Required for DBA, MariaDB, DBeaver, and Windows Task Scheduler Overview: I am seeking a skilled DBA with expertise in MariaDB, DBeaver, and Windows Task Scheduler to provide support for my project. The primary focus will be on set up and configuration. Need to know how to pull the data from snowflake

We are migrating websites from one AWS account to a new AWS account. The website content and Mariadb were extracted into AWS S3 buckets using Terraform. The DB was exported in parquet format. I need the sites and teh DB to be restored on the new AWS instance. From a data security perspective I need this work do be done on my PC so in essence I need someone to talk me through the restore process.