Import csv data mysqlpekerjaan
In need of a highly diligent individual capable in carrying out manual lookup to augment my existing data list. The data list is currently in CSV format and contains names and addresses. The project involves adding phone numbers and emails to each entry, significantly expanding the details available. Excellent attention to detail, proficiency in data entry and extensive experience handling CSV files will be essential for this task. Please provide your methodology for conducting manual lookup as well. There are 8100 records which need Emails and Phone Numbers.
Website saya ini harus didevelop menggunakan spring boot , jpa dan database mysql. Web ini hanya berisi pengenalan produk (gambar, deskripsi, dll), jadi untuk halaman backoffice nya juga harus mempunyai fitur product management. untuk benchmark websitenya, kurang lebih akan terlihat seperti link dibawah : Desain bisa menggunakan template web yang akan disediakan.
I'm seeking a highly skilled freelancer to develop a comprehensive Powershell script capable of parsing both CSV and Excel file formats. This script is a crucial component of our data processing tasks, aimed at effectively managing and extracting specific data points from our datasets. **Requirements:** - The script must accommodate files containing two header rows plus a unique "header" column that precedes the data columns. - It should efficiently extract data, ensuring to handle the dual nature of the headers and the "header" column seamlessly across both CSV and Excel formats. - The goal is to parse these files to extract specific columns of data, entire rows based on certain conditions, and identify unique entr...
I'm searching for a proficient developer to design and implement a voting system for elections. The mechanism should be developed on PHP/MySQL and integrated into an existing portal where members login. Key Responsibilities: - Fabricate a robust and secure voting system. - Ensure the system supports voting for an array of different votes related to elections. - Integrate the voting system securely with an existing members’ login portal. Ideal skills and experience: - Proficient in PHP and MySQL, with previous experience building and integrating systems. - Familiarity with voting/polling systems. - Solid understanding of system integration and experienced with user authentication systems. - Knowledge of secure coding standards and practices. Features: 1. I have a...
...both CSV and XML formats, adhering strictly to a provided specification. **Key Requirements:** - **Output Format**: Final data must be delivered in both CSV and XML formats, structured according to the provided template. - **Data to be Scraped**: - **Photos:** High-quality images are crucial. - **Descriptions:** Detailed and accurate product descriptions. - **Variations, Options, and Tags:** Must include all available product variations, options, and relevant tags. - **Scraping Frequency**: This is a one-time project, but with potential for future collaboration depending on quality and efficiency of work. **Ideal Skills and Experience**: - **Expertise in Web Scraping**: Proven track record of successful web scraping projects, especially involving pr...
Gradeco has an intranet called GRADENET, and its created in php/mysql platform. Please look at uploaded file for the requirements. Feel free to ask questions.
As the client, I need assistance in creating a PHP website. However, I have not yet specified the required features, the information freelancers should include in their application, or the website's intended purpose. Key Requirements: - Familiarity with PHP and MySQL - Versatility in dealing with various website types and functionalities, as the specifics are currently undecided - Eagerness to adapt to new requests and changes Ideal Application: Freelancers interested in this project should lay out their experience and past work, particularly in PHP. Please submit a detailed proposal for the project, even though the requirements are currently vague, I am open to suggestions.
Me encuentro en la búsqueda de un Administrador de Bases de Datos (DBA) para ayudarme a resolver dudas sobre bases de Datos en MySQL. Se requiere experiencia avanzada en gestión y optimización de bases de datos. El proyecto implica desafíos específicos, como la migración de datos, la gestión de grandes volúmenes de registros, y la implementación de estrategias eficaces para el manejo de datos a gran escala. Las dudas a resolver son las siguientes: - Migración Selectiva de Datos: Explorar la posibilidad de trasladar datos seleccionados de una base de datos existente a una nueva. - Migración Completa de Registros: Migrar todos los datos asociados a registros específicos. - Gestión de Registros...
Sila Dafter atau Log masuk untuk melihat butiran.
...gender etc. (also it will send visited urls to our database) - Ad Block: This browser has Adblock Plus extension but i want Ublock origin istead of Adblock plus. - Youtube Play background and only with voice option (There is firefox extensions already doing that) - Adress Bar modification : users should be able to choice the location of Address bar (Top or Bottom) and choice the color of the bar - import history and bookmarks from other browsers (if possible) - 1 click delete the all history - login their Google account such as a Chrome to use their saved passwords to fill the login forms on websites (if possible) - Ad Network placement : it will place our ads instead of Adsense ads on the webpages Preferred skills and experience: - Proven experience in Android development an...
...categories of roles. You will be provided with a CSV that contains roles for a Technology company, and has the current title (JOBTITLE) of the position, and the prior positions that the individual has held throughout their career. You are to use the descriptions below to determine which value between REFINED_JOB_CATEGORY or JOB_CATEGORY_INTERNAL is the most correct based on the current job title, the context of the prior jobs the individual has held, and the descriptions below. You will write either "Original", "Refined", or "Neither" in column G of the CSV file, noting which value you feel is most correct. A value of "Neither" should only be used if neither of the job categorizations make sense based on the descriptions below. There...
I'm looking to hire a proficient PHP/MySQL freelancer to tackle a couple of issues that have cropped up with our current software. Despite not specifying which bugs need attention, I can provide detailed insights into the issues once we engage in conversation, ensuring you understand the scope and specifics of what needs to be corrected. ### Ideal Skills and Experience: - Proficient in PHP and MySQL - Strong debugging and problem-solving skills - Experience with both front-end and back-end development - Familiarity with software testing and quality assurance - Excellent communication skills to report on progress and findings ### Testing Requirements: - All fixes must undergo thorough **Manual Testing** to guarantee they resolve the issues without introducing new ones. ...
...some mysql queries and joins by DEFAULT there is no filter or condition on the STORE ID as when the script is loaded the first time no store id is selected so ALL data will be loaded for all stores now to filter the data for a specific store i added a WHERE clause to my query where o.orders_stores_id = '" . (int)$_GET['store_id_dd'] . "' '" . (int)$_GET['store_id_dd'] . "' is determined once i select a store from the dropdown filter. then it registers once i press submit however this only works if i add that WHERE clause the issue with that WHERE CLAUSE is that the DEFAULT or NULL case will not work and nothing will be returned as the code is treating it as NOTHING i.e its expecting a store id value ...
Hi Azfar Ullah K., This project is based on the task discussed.
I need to edit a plugin, so that when we export a csv, it includes some more data from the website. The plugin is GiveWP
The Spreadsheet must be able to retrieve data from Database/AWS S3 storage and save the file at the same time, in addition application users can also do data entry in the spreadsheet to update tables in the application. The spreadsheet must look like Excel and must be able to manage Validations, Pivot tables, Charts. Important component is the pop up to configure the creation of multiple complex matrix tables within the spreadsheet. Application end users can Input data manually, Import data from external sources, Export data to other formats into Database or AWS S3
I have existing Sass project for a Laravel-based web application with the aim of developing my business website. I need to some change this for our business. - **Skills Required** - Expertise in Laravel Framework, livewire - Strong background in PHP and MySQL - Experience in Frontend Technologies such as HTML, CSS and JavaScript - Understanding in creating database schemas Ideal developers should have extensive experience in building a wide range of business websites using Laravel.
...and Fixtures: Provide users with an intuitive calendar view for upcoming international and national match schedules. Player Profiles: Include detailed profiles of international and national cricket players, showcasing their statistics and performance history. Teams Information: Present comprehensive information about cricket teams, including squad details, performance analytics, and historical data. News and Updates: Curate a dynamic news section delivering the latest updates, articles, and analysis from the cricket world. Push Notifications: Enable customizable push notifications for live match updates, scores, and breaking news. Allow users to subscribe to specific teams or players for personalized updates. Highlights and Replays: Integrate video highlights and replays of...
Technicien Support Confirmé (Freelance, 35h/semaine) Je suis à la recherche d'un Technicien Support Confirmé en freelance pour rejoindre l'équipe de mon entreprise d'hébergement web LWS.FR. Mes attentes : Fournir un support technique de qualité à nos clients. Diagnostiquer et résoudre les problèmes techniques liés à FTP, MySQL, IMAP, POP, SMTP. Gérer et entretenir des sites sous WordPress. Être à l'aise avec l'utilisation de cPanel ou de systèmes équivalents. Expérience requise : Au moins 3 ans d'expérience dans un rôle similaire. Nature du contrat : Poste en freelance, avec un engagement de 35 heures par semaine. Prof...
I'm seeking a skilled developer...back the shorter term call and sell a new shorter term of the next available expiration with delta 50 (user input). The longer term call should also be rolled, same expiration, to maintain a 90 delta, if necessary. 3. Repeat step 2 every day, week, or month (user input) until the end of the backtest period (user input). 4. Generate a report showing a transaction log with results and export to a csv file. This project provides an opportunity to apply technical and trading knowledge to develop a sophisticated strategy script. The goal is to create a tool that can accurately backtest specified conditions and help in making informed trading decisions. If you possess the required skills and are passionate about trading and coding, I look forward to...
...an experienced PHP developer well-versed in MySQL to build a robust user authentication and database integration system for my project. Here are the key functionalities and requirements for the job: **Functionalities Required:** - **User Authentication:** Ability to support users registering and logging in to access specific features. - **Database Integration:** Seamlessly integrate user data with our MySQL database. - **Security:** Implementing regular security audits to ensure user data is safeguarded effectively. **Ideal Skills and Experience:** - Proficient in PHP and MySQL. - Experience in building secure user authentication systems. - Knowledgeable in conducting and implementing security audit recommendations. - Strong understanding of data...
I need a Freelancer to help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software () but failed. So, we suspect that the origin of the file is not ORACLE SQL. I am happy to provide additional information to help you bid properly.
...proficient in PHP/MySQL/CSS LAMP I need someone with strong PHP/MySQL skills to put some filters/sort links on a few pages for me (max 4), so when a user clicks on a link, they get the relevant results from database. It's a Movie/Books site. I want 2 rows of clickable filters on the page(s) like so - Latest Releases | Highest Rated | Coming Soon | Recently Added then below that I will have some clickable image logos of - Netflix | Amazon | Apple tv Functionality wanted - Users of the site to be able to click any of the top row of links and get relevant results (e.g Latest releases) and also be able to click one of the bottom images (netflix, amazon etc) so they could choose to see - Highest Rated on Netflix etc. All data is stored in a MySQL ...
...Excel for a numeric data entry project. This job involves entering numerical data that will be provided in digital format (e.g., Excel, CSV files) into specified Excel spreadsheets accurately. **Ideal Skills and Experience:** - Proficiency in Microsoft Excel. - Strong attention to detail to ensure accuracy of data entry. - Ability to follow instructions precisely. - Experience with numeric data entry. - Good organizational skills to manage large datasets efficiently. **Project Requirements:** - Transfer numeric data from provided CSV files into Excel. - Organize data in the specified format within Excel spreadsheets. - Ensure zero errors in data entry for accuracy. - Meet project deadlines as agreed. I'm looking for ...
...deliverables) Exp: 12 YRS (Minimum) ü Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ü Must have ability to conceptualize ideas and data streams to schemas. ü Expert at ETL transformations using SSIS. ü Good kno...
...crucial. **Key Requirements:** - Perform a seamless installation of PHP 7.4, ensuring compatibility with Almalinux 9. - Configure all necessary PHP extensions including PDO MySQL, cURL, and GD to support the functionality of my web app. - Guarantee that the installation and configuration will not disrupt the current server environment and other hosted applications. **Ideal Skills and Experience:** - Proficient in server management, specifically with cPanel and Almalinux 9. - Experienced in PHP installations, with a focus on PHP 7.4, and understand its nuances. - Knowledgeable in configuring PHP extensions (PDO MySQL, cURL, GD) critical for web applications. - Demonstrated ability to troubleshoot potential issues during and after installation, ensuring smooth operation. ...
Additional Details: - The finalized documentation should be in open API (Swagger Interface) format. - Previous experience in creating API documentation for internal use is required. - Proficiency in Swagger, MySql, and NodeJS is mandatory. Ideal Skills: - Strong knowledge and experience in NodeJS - Demonstrable experience working with Swagger - Familiarity with API documentation for internal use
I'm seeking a skilled PHP developer to create a script tailored to my specific needs for managing XML data efficiently. This script will play a crucial role in the operation of my e-commerce platform, ensuring up-to-date product listings and accurate inventory management. **Key Requirements:** - Develop a PHP script to parse XML files. - The script must extract specific data elements: Product Names, Prices, Descriptions, and Stock Levels. - Import parsed data into a MySQL database. - This process needs to be automated to run on an hourly basis without fail. **Ideal Skills and Experience:** - Proficient in PHP with a strong understanding of XML file handling. - Experienced in writing SQL queries and database schema design. - Familiarity with cron jo...
...needs that can send API calls to find best matched product like PR number for VAG vehicles etc. The requirements for the project are: - Must have comprehensive knowledge about TecDoc or a similar database - Experience in e-commerce website development - Extensive understanding and skill in leveraging APIs - Expertise in integrating chatbots - suppliers warehouse integration and import every day based on CSV or other types of files. - possibility to integrate with Zapier or Ms Power Automate. - sending of orders to accounting system - sending of orders to Logistra - creating orders for suppliers Sites that er within my spec are I have access to the API documentation needed for integration with TecDoc or a similar equivalent. This resource should be appropriate...
I urgently require a Python expert capable of executing web scraping on Website A in a concise time frame. Here's what you need to know: - The specific data we are after from Website A encompasses restaurant details such as the name and contact information. - You will set up the system on my local machine with VPN and proxy configuration. - You will develop a way to organize and output the data in a user-friendly format neatly. - data save in csv or excel file. Ideal skills for this project include: - Proficiency in Python. - Extensive experience in web scraping. - Competency in using VPN and proxy setup. - Good understanding of data organizing and refining. Your experience in similar projects and promptness in delivery will be an added advantag...
...developer for an exciting one-month project aimed at enhancing our data management capabilities and user interaction. This role requires a keen eye for detail and a versatile skill set that encompasses database optimization **Key Tasks Include:** - **Database Development:** Create a robust MySQL database that caters to our specific data management needs. - **Web Interface Creation:** Develop an intuitive web-based interface that allows users to easily interact with the data stored in our database. **Ideal Skills and Experience:** - Proficient in Python programming, specifically with experience in using Python for database manipulation and web scraping. - Expertise in SQL with a strong preference for candidates well-versed in MySQL. - Demonstrated exp...
I'm seeking a freelancer with profound experience in setting up phpMyAdmin on a macOS environment on my MAC AIR. My setup already includes a functioning web server (Apache/Nginx), suggesting that a part of the environment is prepared for phpMyAdmin installation and configuration. Getting Forbidden error when trying to run setup on setup **Requirements:** - Strong background in PHP and MySQL - Previous experience setting up phpMyAdmin on macOS - Familiarity with macOS server configuration and security practices - Ability to troubleshoot potential installation and configuration issues
...facing a critical issue with my project that requires immediate attention from a skilled PHP developer with strong expertise in MySQL. The main problem involves database connection issues that prevent my website from functioning correctly. Due to the urgency of this matter, I'm looking for a professional who can dive into the problem and resolve it swiftly. Ideal Skills and Experience: - Proficient in PHP and MySQL. - Experienced in diagnosing and fixing database connection issues. - Ability to work under pressure and deliver quick solutions. - Excellent problem-solving skills and attention to detail. Requirements: - Quickly identify the root cause of the MySQL connection issue. - Implement a robust solution to ensure stable and reliable database connectivity...
I'm experiencing a problem requiring immediate attention concerning my CentOS 7 server. I've lost my database and need to restore it from MySQL files, specifically .frm and ibdata1 formats. If you are a specialist in CentOS 7 and have substantial knowledge and experience in MySQL database restoration tasks, I'd be grateful for your help. Key tasks include: - Restore the database from source files (.frm and ibdata1) - Swift problem resolution Required expertise and skills include: - Extensive knowledge of CentOS 7 server - Advanced experience in MySQL database restoration - Proficiency in handling .frm and ibdata1 database files. As this is a time-sensitive project, prompt and efficient responses are highly appreciated.
...background in Linux servers and MySQL database management to fix an issue where my server is experiencing problems specifically related to MySQL. My server has suddenly stopped responding correctly, and it seems to be an issue with MySQL, though I haven't made any recent changes to the MySQL configuration or database schema. Ideal Skills and Experience: - Proficiency in Linux server administration - Extensive experience with MySQL, including troubleshooting and optimization - Ability to diagnose and resolve issues remotely - Familiarity with common Linux server monitoring and management tools - Excellent problem-solving skills and attention to detail Requirements: - Quickly identify the root cause of the MySQL issue - Implement a fix with...
Hello everyone. I'm looking for the availability checker of Walmart products by links or products ID ( whatever simpler to do). It should be very simple. It only should give two options - Yes or No Yes - in stock / No - out of stock I will need to upload a csv file with url or product id (1 column) and after some time will download the same file with additional column added: Yes/No Example My uploaded file idxxxxx idxxxx1 idxxxx2 idxxxx3 downloaded file idxxxxx yes idxxxx1 yes idxxxx2 no idxxxx3 yes the id will be similar as walmart product ID of course The system should work in bulks... Let's say 1000 ids in one step. If you can do more than 1000 will be fine. But for sure not 15 or 45 or something like that. The generation for downloaded file should...
...Cost Loading Capabilities: Manage project budgets effectively with robust cost loading capabilities built into the system. Seamless Import/Export with Primavera: Easily migrate data to and from Primavera for enhanced interoperability and streamlined data management. Powerful Data Analysis Tools: Utilize Scrub and Histogram tools for in-depth data analysis and project planning. Automated Work Breakdown Structure: The system should automatically generate a Work Breakdown Structure (WBS) to simplify project organization. Real-time Location Tracking: Incorporate geotagging functionality within a comprehensive logs dashboard for real-time location tracking and data logging. Cloud-based Construction Project Management: Provide a comprehensive cloud-ba...
CHECK THE SCOPE OF WORK DOCUMENT FOR PROJECT DETAILS, BUDGET, PAYMENT TERMS AND DEADLINES We need developers for Development of 5 platforms Customer app Vendor app Rider app Website Admin panel UI design is already done on figma and ...Development of 5 platforms Customer app Vendor app Rider app Website Admin panel UI design is already done on figma and xd. We need freelancer for development, testing and tech support. Time duration - 2 months. Developer will also be responsible for later tech support. We want Hybrid apps that works on both ios and Android. Complete end to end support needed. Flutter apps/Hybrid apps needed. MySQL as database Budget is very low and tight, but negotiable. Send your resume having working apps in your portfolio. NDA and ...
...skills and experience to handle complex backend functionalities, ensuring the smooth running of our web application. - Database management: proficient command of MySQL is essential. You should be comfortable designing, implementing and managing this database system. - Speed optimization: a significant part of the job would be dedicated to enhancing the performance and responsiveness of our web application. If you've got proven experience in this area, you're the candidate we are searching for. - Security enhancements: we value the privacy and safety of our users, making this an area we're looking to solidify. Proficiency in securing MySQL databases and PHP-based applications is a must. - System Integration: experience in integrating various systems would...
Add records to single mysql table from multiple sources simultaneously. Example. there are multiple browsers targeting same table for insertion. There is cron job doing the same. We don't want congestion or deadlocks You may use any table with 4 or 5 columns for development
As an oracle sql, PL/SQL and MySQL user, I'm looking for a database expert to assist me with several tasks including, database design, data migration, and performance optimization. The main goals are to enhance data retrieval speed, ensure data integrity, and optimize overall database performance. Key Skills: - Expertise in Oracle SQL and PL/SQL - Strong Knowledge of MySQL - Proven experience in database design - Skilled in data migration techniques - Track record in improving database performance The perfect candidate would not only bring their experience to the project but also provide insights and recommendations to help achieve the project's primary goals.
...read all instructions before you bid R2) Freelances is to evaluate and write cost and time needed R3) according to written cost and execution time, freelancer will be selected R4) app should work on Android 10 and above R5) needed are 3 parts, send clearly separately: a) apk file that i can put on cell and install b) ZIP file with all project files to import in Android Studio c) needed clear instructions, clear communication what to click to import project in my Android Studio to run code and possibly edit R6) if project is successfully imported by buyer, no need for previous step "c" as requirement R8) should work in Android Studio Chipmunk 2021.2.1 Patch1 Buld May 18,2022 R8) should not use kotlin, but JAVA R9) no copyright anywhere, all unlimited rights are tr...
...efficiently. THis includes full automated email from date triggers pulled from Hubspot **Requirements:** - **Email Campaign Management:** You should be able to configure, launch, and monitor email campaigns, ensuring high deliverability and engagement rates. - **Subscriber List Management:** We need sophisticated management capabilities for handling our subscribers, including segmentation, import/export functions, and dynamic list updates. - **Custom Email Templates:** Development of unique email templates that align with our branding and conversion goals is essential. These should be easily customizable for different campaigns. - **Advanced Customization:** Our project demands integrating Mailwizz with other systems and adding complex features that should be available as...
I need a solution that will automatically import and categorize bookmarks from Google Chrome, Mozilla Firefox, and Safari into the user dashboard on my CodeIgniter application. Requirements: - Capture and import bookmarks from the specified web browsers - Organize imported bookmarks based on categories within the user dashboard. Ideal Skills for the Job: - Experience with PHP and Codeigniter - Familiarity with Google Chrome, Mozilla Firefox, and Safari's bookmark structures - Strong skillset in automated web scraping and data categorization. Please ensure your proposal includes relevant experience and a general approach to the project.
...seeking a detailed-oriented freelancer to develop a data crawler capable of collecting specific information from various e-commerce websites and social media platforms. The objective is to harvest both text and numerical data efficiently. Key Requirements: - Target Data: Retrieve product prices as efficiently as possible. - Sources: Focus on well-known e-commerce platforms and social media sites where product listings are prevalent. - Essential Skills: Proficiency in web scraping tools, data extraction techniques, and handling bot detection mechanisms. - Experience: Past projects involving e-commerce or social media data scraping are highly beneficial. - Output Expectation: The data should be organized and provided in a structured format such a...
...contain a csv, this csv itself contain data, which need to be converted into reasonable values. Afterwards this data is getting posted via an REST API to a different system. Both the csv and the converted data shall be accessible for debug purposes after being processed. A re-execution by an admin is also mandatory, if something went wrong during parsing or processing. This is a test simple test task to find the right candidate. We will assign you later more work, if this implementation works well. Key functionalities required: - read e-mails via connector (event source) - fetch the csv from the e-mail - import the data into kafka - convert/parse the data properly inside kafka - ensure both csv, and parsed ...
I'm looking for an adept freelancer to develop a user-friendly asset management system to keep track of various items within our conference rooms and classrooms. The simplicity of the system is crucial to accommodate volunteers of varying tech skill levels. Here is a concise breakdown of what the project entails: - **System Preferences**: The system could be designed in Excel, Access, or MySQL. The key consideration is ease of use for individuals with minimal technical background. - **Assets to Manage**: The primary focus will be on efficiently managing numerous assets including computers, printers, projectors, and various additional items detailed in an accompanying spreadsheet. - **Functionality Requirements**: + Track the quantity of each asset + Monitor the spec...
this is easy work for someone who knows how to import products through CVS. I tried importing the CVS file from another wordpress woocomerce to a new website but I get error due to the product images not importing so I have imported the product images into the server manually through ftp so what I need you to do is import the product cvs and connect them to my images that are already in the server.
...expact below things in detail which you need to full fill it with several aspects of this project: 1. Data Modeling and Database Design: • Identify key entities: List all the types of data you want to store, such as employees, customers, projects, inventory items, invoices, etc. • Define relationships: Determine how these entities relate to each other (e.g., employees can be assigned to projects, projects can have tasks, tasks can be assigned to delivery boys). • Design database schema: Based on the entities and relationships, create a well-structured database schema with tables, columns, data types, and constraints. I can help you with normalization techniques and best practices for efficient data storage and retrieval. 2. Feature Prioritizati...
I'm experiencing a problem requiring immediate attention concerning my CentOS 7 server. I've lost my database and need to restore it from MySQL files, specifically .frm and ibdata1 formats. If you are a specialist in CentOS 7 and have substantial knowledge and experience in MySQL database restoration tasks, I'd be grateful for your help. Key tasks include: - Restore the database from source files (.frm and ibdata1) - Swift problem resolution Required expertise and skills include: - Extensive knowledge of CentOS 7 server - Advanced experience in MySQL database restoration - Proficiency in handling .frm and ibdata1 database files. As this is a time-sensitive project, prompt and efficient responses are highly appreciated.