
In Progress
Posted
Paid on delivery
Project Title: Moodle Database Recovery Specialist Needed – Corrupted mdlnb_files Table / InnoDB / Moodle File Records We are looking for an experienced Moodle specialist, DBA, or Linux/MySQL/MariaDB recovery expert to help recover an active Moodle site affected by database corruption. Background: The Moodle site is used by an active school. During preparation for a server OS upgrade/ELevate to AlmaLinux 8, hosting support found corruption in the Moodle database. The main affected database is: omapleacademyonl_867 The corrupted table appears to be: mdlnb_files Hosting support attempted InnoDB recovery up to level 3, but they were not able to fully recover/dump the table. They were able to dump the database without the mdlnb_files table and import it into a test database: omapleacademyonl_867_test However, because mdlnb_files is missing, the Moodle site will likely have serious issues with uploaded files, assignment submissions, course resources, feedback files, embedded PDFs, and other Moodle file references. Available recovery materials: Current live database: omapleacademyonl_867 Test database dumped without mdlnb_files: omapleacademyonl_867_test Partial dump of corrupted table: /home/omapleacademyonl/[login to view URL] Older database backup from July 4, 2024: /root/dbbackups/2024-07-04_1459/[login to view URL] Single-table backup from 2024: /root/dbbackups/[login to view URL] Important concern: The 2024 backup is very old. Restoring the full 2024 database to the live site is not acceptable because it would cause data from July 4, 2024 to now to be missing. The goal is to preserve as much current Moodle data as possible, especially files and file records from 2024 to now. Scope of Work: The specialist will be expected to: Review the current database corruption issue and available backups/dumps. Assess whether the current corrupted mdlnb_files table can be partially or fully recovered. Review the partial dump file: /home/omapleacademyonl/[login to view URL] Compare the partial dump with the 2024 version of mdlnb_files. Recreate or rebuild the mdlnb_files table structure if necessary. Import as much recoverable data as possible into the test database. Confirm whether the Moodle moodledata/filedir physical file storage is intact and whether files can still be linked back to Moodle. Advise on whether missing file records can be reconstructed using Moodle’s file storage, contenthash values, or other Moodle database references. Help produce a recovery plan that brings the Moodle site back online while minimizing loss of student submissions, course files, teacher feedback files, and file references. Clearly explain the risk before any destructive action is taken. Important Requirements: Do not overwrite the live database without approval. Do not restore the full July 2024 database over the current live database. Do not drop the current live database without approval. Work should be done on a test database first wherever possible. Must have experience with Moodle database structure, especially the mdl_files / mdlnb_files table. Must understand Moodle’s moodledata/filedir file storage system. Must have experience with MySQL/MariaDB, InnoDB recovery, corrupted tables, phpMyAdmin, cPanel/WHM, and Linux server environments. Experience with Moodle disaster recovery is strongly preferred. Deliverables: Initial assessment of whether the corrupted mdlnb_files table can be recovered. A safe recovery plan. Rebuilt or partially restored mdlnb_files table in a test database. Confirmation of what Moodle data/files are recoverable and what may be missing. Step-by-step recommendation for bringing the live Moodle site back online. Optional: Assistance implementing the final recovery on the live site after approval. Please apply only if you have direct experience with Moodle database recovery or MySQL/MariaDB InnoDB corruption recovery. General WordPress or basic cPanel experience is not enough for this project.
Project ID: 40460168
35 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, Recovering a corrupted mdlnb_files InnoDB table with partial dumps and a year-old backup while keeping newer data intact is exactly the kind of high-stakes Moodle work I've handled before — I've worked on Moodle setups at institutions like [login to view URL] and [login to view URL], including database-level recovery and filedir reconciliation work. My approach: First, I'll assess the partial dump at [login to view URL] to see how much post-July 2024 data is recoverable, then rebuild the table structure in your test database (_867_test). From there, I'll cross-reference Moodle's filedir using contenthash values to relink as many physical files as possible — even records missing from the dump can often be reconstructed this way. The 2024 backup will only be used to fill structural gaps, never to overwrite live data. Every step will be tested first with a clear risk explanation before any action on the live database. Let's discuss in chat so I can review your partial dump and give you a clearer picture before we begin.
$600 CAD in 4 days
5.6
5.6
35 freelancers are bidding on average $528 CAD for this job

Hello, As a highly experienced Moodle specialist and database expert, I am confident in my ability to help recover and restore your corrupted mdlnb_files table. With a deep understanding of Moodle's file storage system and its intricate database structure, I bring an expertise that few can rival. My extensive experience with MySQL/MariaDB and InnoDB recovery will prove instrumental in reconstructing the missing table structure and successfully importing as much recoverable data as possible into the test database. I understand the profound impact this issue has on your active school's daily operations. Focusing on preserving your current Moodle data, my approach will be to carefully compare the partial dump file with the 2024 version of mdlnb_files. Additionally, I am skilled at utilizing all available tools, like Moodle's file storage and contenthash values, to recover missing file records. Above all, I prioritize transparent communication and risk management during the entire process. Provided with a detailed safe recovery plan and step-by-step recommendations for bringing your live Moodle site back online, you can rest assured that I will avoid any destructive action without proper approval. At Yassi Software Group, we believe that delivering projects of exceptional quality and ensuring client satisfaction are at the core of our success - and we aim to replicate that in our partnership with you. Thanks!
$450 CAD in 3 days
7.8
7.8

Hello, I will assess the corrupted mdlnb_files table, merge recoverable rows from the partial dump with the 2024 backup, and rebuild a working files table in your test database — preserving as much current data as possible. One key step: I will cross-reference the contenthash column from your partial dump against the physical files in moodledata/filedir. Since Moodle stores files by SHA1 hash, any file still on disk can be re-linked even if its database record was lost — by scanning filedir and reconstructing missing rows from the hash paths and related context tables like mdlnb_files_reference and mdlnb_context. Questions: 1) Is the moodledata/filedir directory fully intact, and roughly how large is it? 2) Does the partial dump file load at all, or does it error out mid-import? Looking forward to talking through the details. Kamran
$281 CAD in 10 days
7.8
7.8

Hi there, I can help you with recovering the corrupted mdlnb_files table. I've dealt with InnoDB corruption on Moodle before and understand the file storage system. The key is to compare the partial dump with the 2024 backup to salvage recent records, then cross-reference contenthash values with the moodledata directory to reconstruct missing links. I'll work entirely on the test database first and never touch the live one without your OK. I'm Edward, 10+ years deep in MySQL recovery and Moodle specifically. Let me know if you want to discuss next steps.
$750 CAD in 7 days
7.5
7.5

I can assist with this recovery work. I have experience with Linux server administration, MySQL/MariaDB troubleshooting, corrupted InnoDB table recovery, backup restoration strategies, Moodle/PHP application database structures, and safe disaster-recovery workflows. This requires a cautious DBA-style recovery approach—not a generic site fix—and I’m comfortable working test-first, analyzing corrupted table dumps, comparing historical backups, validating moodledata/filedir integrity, reconstructing file metadata where possible, and producing a low-risk recovery plan before any live intervention.
$300 CAD in 3 days
5.7
5.7

Hello, I can help you safely assess and recover the corrupted Moodle mdlnb_files table without touching the live database unless you approve it. I have experience with Moodle file records, moodledata/filedir, MySQL/MariaDB InnoDB corruption, cPanel/WHM, and Linux recovery work, so I can review the partial dump, compare it with the 2024 backup, rebuild the table structure if needed, and restore as much recoverable file data as possible into the test database. I will keep the process careful and clear, explain the risks before any action, and focus on preserving student submissions, course files, teacher feedback, embedded files, and Moodle file references from 2024 to now. I am ready to begin immediately and would be happy to discuss the project in further detail. Thanks, Teo
$500 CAD in 3 days
5.6
5.6

I understand the urgency of your Moodle database issue, specifically the corruption within the mdlnb_files table. Dealing with database-level file storage errors requires a precise approach to ensure no file references are lost during the repair process while restoring site functionality. With over 15 years of experience managing Linux environments, MySQL databases, and complex CMS structures, I am well-versed in phpMyAdmin operations and manual SQL recovery. I frequently handle site troubleshooting and performance restoration, meaning I can diagnose the root of this corruption and implement a fix that stabilizes your Moodle instance without relying on guesswork. I can complete this recovery within 1 day for a total of $447.81. If you are ready to get your Moodle site back online, send over the server access details and I will start the investigation immediately.
$447.81 CAD in 1 day
4.8
4.8

As an experienced Full-Stack Developer and Moodle specialist with a deep understanding of PHP, MySQL, and Moodle database structure, I am confident that I am the right fit for your project. Over 14 years, I have delivered 416 successful projects and amassed a strong skillset in database administration, especially in recovering corrupt tables like mdlnb_files in InnoDB. My approach to a problem like this hinges on a comprehensive assessment of the current state of your database, review of available recovery materials, possible reconstruction options, and comparison between versions to determine the missing data. My goal would be to preserve as much current Moodle data as possible while minimizing risks. I have worked extensively with Moodle's moodledata/filedir file storage system and can assist in linking files back to Moodle using contenthash values or other references available in the database. When you engage my services, you can expect not just a safe recovery plan, but also step-by-step recommendations to bring your live site back online without overwriting or dropping the current live database. I assure you of full commitment to preserving your invaluable Moodle data from 2024 till now! Reach out today!
$700 CAD in 14 days
4.1
4.1

Hello there, We will recover your corrupted mdlnb_files table and rebuild the missing file records in your test database before touching anything live. Our approach: merge the partial dump with the 2024 backup, then cross-reference contenthash values against your moodledata/filedir to relink orphaned files. Records created after July 2024 that exist in the partial dump get priority. Any file physically present in filedir but missing from the table can be reconstructed using Moodle's contenthash naming convention. A couple of quick things to confirm: 1) Is the moodledata/filedir directory fully intact, or has it also shown signs of corruption? 2) Do you have SSH root access available, or will work be limited to cPanel/WHM? The number quoted here is a starting estimate. Looking forward to potentially working together. Thanks, Faizan
$282 CAD in 10 days
3.6
3.6

Hi there, Thank you for sharing such a detailed overview of your Moodle database recovery needs. We understand how critical this situation is for your school’s operations, particularly given the importance of preserving student submissions, course resources, and file integrity. As DemiVision LLC, we specialize in complex Moodle database recovery and have extensive hands-on experience with MySQL/MariaDB InnoDB corruption, Moodle’s file management architecture, and disaster recovery scenarios in educational environments. Our team has successfully restored corrupted mdl_files/mdlnb_files tables and rebuilt database records to restore functionality for active Moodle sites without significant data loss. We have reviewed your outlined scope and are confident we can provide a thorough assessment and a structured recovery plan. Our approach would begin by evaluating the extent of corruption in the mdlnb_files table, analyzing your available partial dumps and backups, and mapping the differences between current and historic file records. We will prioritize non-destructive methods, working exclusively on the test database until we have a secure and validated solution. Additionally, we will examine your moodledata/filedir storage for physical file integrity and explore the potential to reconstruct missing file records using contenthash values and related database tables. Throughout this process, we will communicate risks clearly and only recommend live site changes once data integrity is assured. Our goal is to help you recover as much recent and essential data as possible, minimizing disruption for your staff and students. We look forward to collaborating closely and guiding you safely through the recovery process. Please let us know if you have any initial questions or specific concerns you’d like us to address first.
$500 CAD in 10 days
0.0
0.0

⚠️ If you're not happy, you don’t pay. ⚠️ Hi there, Thank you for sharing the detailed project brief. I can build a robust Moodle database recovery solution using MySQL/MariaDB with a customized disaster recovery plan. I will deliver: • Assessment of corrupted mdlnb_files table recovery • Safe recovery plan implementation • Rebuilt mdlnb_files table in a test database • Confirmation of recoverable Moodle data and missing elements analysis • Detailed step-by-step guide for bringing live Moodle site back online You will also receive: • Expert guidance on recovery execution • Thorough documentation for future reference I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag.
$550 CAD in 7 days
0.0
0.0

Lets chat, a free consultation and no obligation. I understand you need a clean, professional, and user-friendly solution for your "Moodle Database Recovery: mdlnb_files Corruption" project. My skills in PHP, Java, JavaScript are a perfect fit for this project. While I am new to freelancer.com, my extensive experience delivers integrated, automated solutions. Regards, Jason McLachlan
$560 CAD in 3 days
0.0
0.0

Richmond Hill, Canada
Payment method verified
Member since Dec 26, 2020
$10-30 CAD
$250-750 CAD
$10-30 CAD
$10-30 CAD
₹600-1500 INR
€30-250 EUR
₹12500-37500 INR
$250-750 USD
₹100-400 INR / hour
₹1250-2500 INR / hour
$15-25 USD / hour
₹37500-75000 INR
$30-250 USD
$250-750 USD
€8-30 EUR
$8-15 USD / hour
$30-100 USD / hour
$250-750 USD
$15-25 USD / hour
$10-30 AUD
$250-750 USD
$10-20 USD
$25-50 USD / hour
$250-750 USD