
Tamamlandı
İlan edilme:
Teslimde ödenir
I’m running a MySQL-based application and two things need urgent attention: 1. Something in the database layer is malfunctioning. I’m seeing symptoms typical of collation or connection hiccups, but I haven’t pinpointed whether it’s a bad query, a latent connection failure, or straight-up data inconsistency—so I need a full check-up of tables, indexes, and server settings to isolate and resolve the root cause. error -- Broken table smb_componentUpdates: Corrupt failed Repairing table 'smb_componentUpdates' Try to restore automatic daily dumps stored in /var/lib/psa/dumps error Broken table smb_productUpgrades: Corrupt failed Repairing table 'smb_productUpgrades' Try to restore automatic daily dumps stored in /var/lib/psa/dumps warning - Checking the structure of the Plesk database package_id last_notification - this has may be corrupted or deleted. need to fix this. 2. When I export data to .csv, certain characters appear garbled. (£) is not fetching on values in shell that requires. it is missing. that need to fix. & add £ sign before value. as per columns title. some columns do not require £ so. only apply £ sign where value £ is shown in title column & remove some random character before A'£ 3. you must work only on remotely. i need to see what has changed to fix these issues. i will not provide access to our live server. if you cannot work remotely connection, this task is not for u. Deliverables I expect: • Clean, repeatable steps (or script) that repairs the database issue and prevents its return. • A patched export routine that produces a flawless .csv file—even when the data contains accents, symbols, or multi-byte text. • A detail notes explaining what you were wrong and how fixed it so I can maintain it going forward. Skill, you need --- MySQL, Plesk, CodeIgniter, PHP If you’re comfortable digging into MySQL configuration, character sets/collations, and CSV generation logic, I’m ready to get this wrapped up quickly.
Proje No: 40035933
48 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 ay önce
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir

As a seasoned web developer with over 10 years of expertise, I am no stranger to database malfunctions, particularly in MySQL. My analytical prowess and deep understanding of the MySQL core will enable me to locate and resolve any collation or connection hiccups swiftly and efficiently. Additionally, my comprehensive background in computer science will empower me to fully sanitize and patch your database, making it resistant to similar issues in the future. Regarding your issues with CSV encoding, I have acquired a nuanced proficiency in handling such data sets throughout my career. Not just that, I've perfected the art of generating .csv files without even a hint of discrepancy - even when the dataset consists of accents, symbols or multi-byte text. I will not only fix the issue but map out the precise steps (or script) you can employ on your own for exporting flawless .csv files. Moreover, given your requirement for remote work only,I believe my familiarity with AWS deployment and Linux System Administration would make me a perfect match for this task. You can count on my ability to deliver clarity in my notes about what went wrong with your system and how I fixed it for easy maintenance in the future. Trust me to not only complete this task diligently but exceed your expectations in every possible way. Let's get started!
£20 GBP 1 gün içinde
6,9
6,9
48 freelancer bu proje için ortalama £19 GBP teklif veriyor

Hi there, I'm available to get started on this right now and i can gurantee i'll solve it correctly. Please send me a message so I can get this wrapped for you.
£15 GBP 1 gün içinde
7,3
7,3

Hi, I am available to fix it quickly. Message me.I am looking forward to an early and positive response. Regards, Shalu
£24 GBP 2 gün içinde
6,9
6,9

Hello, I’d be glad to assist with your project. I have experience handling similar work and will make sure everything runs smoothly from start to finish. My goal is to deliver quality results on time and ensure you’re completely satisfied with the outcome. Let’s connect to discuss your project details — I’m ready to get started right away. Best regards, Pallvi Gupta
£20 GBP 2 gün içinde
6,2
6,2

Hi there, I’m a senior developer with 5+ years building dynamic apps and data workflows. I’ve reviewed your MySQL/Plesk context and the CSV encoding issue, and I can fix the corrupted tables, optimize server settings, and deliver a remote-only, repeatable fix plan that you can verify before applying to live. Plan: 1) remote DB health check (CHECK TABLE, status analysis, charset/collation review, index integrity); 2) safe repair of smb_componentUpdates and smb_productUpgrades with verified dumps and post-repair integrity checks; 3) a robust CSV export routine that preserves multi-byte text, fixes currency formatting (apply £ where appropriate and only on designated columns), and avoids stray characters; 4) a repeatable script or playbook to reproduce the fix and prevent regression, plus a detailed notes document with root-cause and improvements; 5) transparent remote progress updates and a test plan so you can verify changes before live deployment. Deliverables: repair script, patched CSV exporter, and a notes document explaining fixes and how to maintain them going forward. To scope the remote fix precisely, would you prefer the DB repair and the CSV export adjustments to be implemented as a single reproducible script with rollback steps, or as separate, testable modules? Best regards, Denis
£30 GBP 1 gün içinde
5,7
5,7

I can help you quickly diagnose and repair your MySQL/Plesk issues and fix the CSV export character problems — all working remotely, as required. I’ll audit and repair the corrupted tables, verify collation/connection settings, and provide a clean, repeatable fix to prevent future breakage. I’ll also correct the CSV export so characters like £ display properly and apply the £ sign only to the appropriate columns. Clear documentation and step-by-step notes will be provided so you can maintain everything going forward. Let’s get this resolved efficiently.
£50 GBP 7 gün içinde
5,4
5,4

hello i am available to work on this task, and i have 6+ years experience in it and web devloppment contact me for more details on the task in chat am available to work on it. best regards
£15 GBP 7 gün içinde
5,6
5,6

Hello sir, I have 10 years experience on PHP web application.i will fix the MySQL issue .... Thanks
£20 GBP 1 gün içinde
5,4
5,4

Hello there, I can help you diagnose and fix the MySQL database corruption issues, repair broken tables, and address the CSV export problems with proper handling of special characters like £. I will work remotely as requested, providing full visibility into the changes I make. My solution will include a clean, repeatable script to repair and prevent future database issues, a patched CSV export routine that handles multi-byte text correctly, and detailed notes explaining all steps taken so you can maintain it confidently. I am available to start immediately and can ensure this task is resolved efficiently. For further discussion and to go over your requirements in detail, let’s connect via chat. Best regards, Aliza.
£20 GBP 1 gün içinde
4,9
4,9

Hello Kartik , hope you're doing well. We came across your project Fix MySQL & CSV Encoding and I am very interested in working with you. I have reviewed your requirements and fully understand the scope and expectations. I specialize in PHP, Linux, Data Processing, Software Architecture, Codeigniter, MySQL, Database Development, Database Design, Data Management and have successfully delivered similar projects before. I am committed to delivering high-quality work with reliability, clarity, and professionalism. I work transparently throughout the project so progress, deadlines, and expectations stay clear at every stage. I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Regards, ANUZAICER
£20 GBP 1 gün içinde
4,5
4,5

As an experienced web developer, I'm fully equipped to fix the MySQL and CSV encoding issues your application is facing. I have a profound understanding of MySQL configuration, character sets/collations, and CSV generation logic - skills that are pivotal to resolving your database layer malfunction. With my expertise in PHP, Laravel, and CodeIgniter - languages indispensable to database handling, I can ensure a thorough check-up of tables, indexes, and server settings to isolate and fix the root cause of the issue, guaranteeing clean and repeatable steps preventing a reoccurrence. In addition to resolving the primary problem, I am also well-versed in rectifying encoding mismatches in exports. The missing (£) character you mentioned is likely a result of such mismatches, and I'm confident in my ability to add the (£) sign where required while removing any random characters before it as requested. My communication style is transparent and timely, enabling me to maintain effective progress while working remotely. Offering long-term value is another forte of mine; thus, I will provide detailed notes explaining what went wrong with your database layer and how it was fixed so that you can maintain it going forward confidently. Choose me for a smoothest experience while fixing these MySQL and CSV related issues.
£50 GBP 1 gün içinde
3,7
3,7

As an experienced MySQL I'm confident in my ability to identify and resolve the issues with your database. I have a strong understanding of collation, character sets, and server configurations which will come in handy for troubleshooting the root cause of your problem. With your permission, I can remotely access your server and thoroughly analyze the tables, indexes, and server settings to pinpoint the precise issue, whether it's a bad query, connection failure or data inconsistency. Moreover, I've had extensive experience with CSV exports in my past projects, ensuring that all characters are preserved correctly. Your specific requirement of adding the £ sign only when it's present on title column is an interesting challenge that I am ready to tackle. Rest assured, I will document every step of my solution clearly so you can maintain it beyond our engagement. In conclusion, choosing me means choosing a diligent and experienced hand who will handle this task swiftly without disrupting your operation. Together we can resolve the hiccups in your MySQL-based application and deliver clean, repeatable steps while improving data integrity on export. Let me put my expertise to work for you today!
£10 GBP 1 gün içinde
3,4
3,4

Hi, there! Thanks for your post. I've read your proposal very carefully and I am very excited and confident about it. I understand that you need urgent assistance with your MySQL application, specifically to troubleshoot and resolve database malfunctions, fix character encoding issues in CSV exports, and perform all tasks remotely. I have full experience in MySQL, Plesk, CodeIgniter, and PHP. Please look at my approach: - Conduct a comprehensive check-up of your database tables and indexes to identify and fix the root cause of the corruption issues. - Develop a clean and efficient export routine that ensures your .csv files are free of garbled characters, applying the £ sign accurately where needed. - Provide detailed documentation outlining the issues found, the steps taken to resolve them, and preventative measures to avoid future complications. I can start immediately and deliver excellent results in your timeline. I'm eager to help you get everything back on track! Looking forward to your response. Best Regards.
£10 GBP 7 gün içinde
3,5
3,5

Hi Kartik, I understand the urgency of addressing the issues within your MySQL application. With my extensive experience in MySQL configuration, I can swiftly diagnose the database layer malfunctions you're experiencing, whether it's related to collation, connection failures, or data inconsistency. I'll perform a thorough check of your tables, indexes, and server settings to determine the root cause and repair the corrupted tables. Additionally, I will create an export routine for your CSV files that properly handles characters like the £ symbol, ensuring it appears correctly based on your column titles and removing unnecessary characters. Following the troubleshooting, I will document every step taken to fix these issues so you can maintain the solution moving forward. My approach is fully remote, allowing you to observe the changes being made without needing to access your live server. I can have this wrapped up in just a few days. Thanks, Jhonrel Alvero
£20 GBP 5 gün içinde
3,2
3,2

Dear Client! I have a lot of experience in web development. If you give me the assignment, I will satisfy you with good results. because I am a full-time developer, you can contact with any time. I am focusing on Trust & Credit to build a good relationship with customers. If you want to collaborate with me let’s discuss it in more detail over the chat. Kind regards, Karl.
£15 GBP 1 gün içinde
3,2
3,2

As an accomplished software engineer with deep expertise in database development and Linux, I'm well-equipped to tackle the pressing MySQL issues you're experiencing. Having worked extensively with Plesk, I understand how important it is to maintain a streamlined and error-free database, ensuring all processes work smoothly. My strong background in PHP allows me to navigate encoding and collation hiccups seamlessly. One of my standout skills is my ability to diagnose complex issues and provide clean, repeatable solutions that prevent their recurrence. For your project, this means undertaking a thorough check-up of your MySQL tables, indexes, and server settings to single out the root cause of the failure and deliver reliable steps or scripts that fix them. I'll explain what went wrong and how I fixed it in detail — giving you the knowledge to maintain it moving forward. I must underscore my comfort working remotely. Rest assured, I can deliver your required results while offering the necessary transparency through every stage of the process. Let me use my passion for building robust, user-focused solutions combined with agile methodology skills to get your system back on track swiftly and effectively. Choose me for this project and experience the difference firsthand!
£15 GBP 7 gün içinde
2,4
2,4

Hey Kartik P., I just finished reading the job description and I see you are looking for someone experienced in PHP, Data Processing, Codeigniter, Database Design, Data Management, Software Architecture, Database Development, MySQL and Linux. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback since the last 5-6 years. 3. You will find 5 star feedback on the last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Syed.
£10 GBP 5 gün içinde
2,4
2,4

Hi, I can resolve all three issues quickly and transparently while working 100% through remote session, as requested. I specialize in MySQL/Plesk diagnostics, CodeIgniter/PHP debugging, and character-set repairs. Database corruption fix I will fully inspect the affected Plesk system tables (smb_componentUpdates, smb_productUpgrades, package_id, last_notification) and run safe repair routines. If corruption exceeds repair limits, I will recover the affected tables from Plesk’s internal dumps without touching production data. I’ll also check engine types, indexes, collations, and server settings to ensure the issue does not return. CSV export fix I’ll fix the encoding issue causing garbled symbols and ensure the CSV exports as proper UTF-8. I’ll add the £ symbol only where column headers require it, remove unwanted characters, and ensure multibyte characters display correctly across Excel, shell, and editors. Full transparency (remote-only) You will see every step while I work. No direct access needed. Deliverables • Repaired Plesk/MySQL tables + prevention steps • Corrected CSV export routine with clean encoding + correct £ formatting • Clear notes on what was wrong and how to maintain the fix I can start immediately. Let me know when you’re ready to begin the remote session.
£15 GBP 7 gün içinde
2,3
2,3

Hello, how are you? I've reviewed the description carefully and I am sure I can deliver this task on time because I have rich experience. I understand that you need urgent assistance with your MySQL-based application to fix database malfunctions and CSV export issues. I have hands-on experience in MySQL, Plesk, CodeIgniter, and PHP, which makes me a great fit for this job. Here is my approach as follows: - Conduct a comprehensive check-up of your database tables, indexes, and server settings to identify the root cause of the corruption. - Develop a reliable script that repairs the database issues and prevents future occurrences, ensuring your system runs smoothly. - Patch the export routine to produce flawless .csv files, adding the £ sign where necessary while eliminating any garbled characters. I am ready to start immediately and can deliver the result fast, working remotely as per your request. I'd love to discuss this in more detail and help get your database back on track. Best Regards.
£10 GBP 7 gün içinde
1,8
1,8

Hi, I’m a senior software engineer experienced with MySQL, Plesk, CodeIgniter, and character-set debugging. I can fix your corrupted tables, check indexes/settings, and repair the Plesk DB issues while working 100% remotely so you can see every step. I’ll also correct the CSV export so symbols like £ display properly and are added only to the correct columns, removing any stray characters. You’ll receive clean steps/scripts for repairs and a clear note of what was broken and how it was fixed. I can start right away.
£15 GBP 7 gün içinde
1,6
1,6

Hi, I can remotely troubleshoot and fix your MySQL/Plesk issues. I’ll first audit and repair the corrupted tables (smb_componentUpdates, smb_productUpgrades) and verify the Plesk database structure, ensuring indexes, collation, and connections are fully healthy. Then I’ll update your CSV export logic to correctly handle multi-byte characters and accents, and automatically prepend the £ symbol where required while removing any unwanted characters. You’ll receive: A repeatable script or documented steps to repair and prevent table corruption. A patched export routine producing clean, accurate CSV files. Detailed notes explaining what went wrong and exactly how it was fixed. Quick question: Are there test copies of the database I can use for validation, or should I work with a staging snapshot you provide? Best, Adil Ali
£15 GBP 7 gün içinde
1,6
1,6

London, United Kingdom
Ödeme yöntemi onaylandı
Mar 9, 2022 tarihinden bu yana üye
£10-20 GBP
$750-1500 USD
£10-20 GBP
£10-20 GBP
$250-750 USD
$30-250 USD
$10-60 USD
€30-250 EUR
₹100-400 INR / saat
$30-250 AUD
₹600-1500 INR
$10-30 USD
$2-8 USD / saat
₹750-1250 INR / saat
₹12500-37500 INR
$250-750 USD
₹600-3000 INR
$10-30 USD
$200-500 USD
$8-15 AUD / saat
$10-30 USD
$10-30 USD
₹600-1500 INR
₹600-1500 INR
€12-18 EUR / saat