Advanced MySQL configuration to import huge SQL files

Our nonprofit, WiderNet, provides off-line access to thousands of Web sites for people who lack Internet connectivity. ([login to view URL]) Over 2,000 universities, schools, health care sites, and libraries in the developing world have adopted this solution, providing a bounty of educational information to millions of users.

We receive large SQL files (100GB+) that we need to import into our Windows-based MySQL server. It's a standalone server dedicated just to this process, with 24GB of RAM and a 2TB NVMe drive.

By addressing obvious hardware and software configuration issues, we've trimmed the import time from days to hours, but need someone with SIGNIFICANT MySQL server setup experience to advise us on our current configuration and suggest how we might improve the process.

We do not have control over how the files are dumped, so we need to everything in our power to speed things up.

More critically, once imported, we need to compress the tables to save space. They will be read-only in production.

Please, only bid if you have advanced experience with this rare environment.

Навички: MySQL, Адміністрування баз даних, Робочій стіл Windows

Деталі: import huge xml mysql, mysql sql files, mysql import large sql php, mysql import large sql file windows, mysql import compressed sql file, how to import large sql file in mysql with command line, how to import large sql file in phpmyadmin xampp, mysql import large sql file phpmyadmin, mysql file too large, sql file compressor, xampp import sql file, import gzip sql mysql, mysql import huge sql, mysql import gzipped sql, import wizard sql server 2005 cvs files, mysql import gzipped sql file, mysql import database sql, import export csv files sql express 2005, import data sql server mysql, mysql import huge

Про роботодавця:
( 60 відгуки(-ів) ) Chapel Hill, United States

ID Проекту: #24268543

13 фрілансерів(-и) у середньому готові виконати цю роботу за $142


Hi i am expert at , Windows Desktop , MySQL , Database Administration So send me Private message at PMB so we can discuss more about it Thanks

$140 USD за 7 дні(-в)
(238 відгуків(и))

Hello, I have good expertise on importing large database (https://www.freelancer.com/projects/sql/SQL-DATABASE-Formatting/?w=f) and i am interested to do this project. Did you mean MySQL or MSSQL? Let's discuss more. Більше

$200 USD за 4 дні(-в)
(94 відгуків(и))

Hello Hope you are doing well. I have 7 years of experience in Windows and Mysql Server Management. I can tune mysql to achieve good import speed

$250 USD за 3 дні(-в)
(105 відгуків(и))

I'll do Advanced MySQL configuration to import huge SQL files as per your requirements and with full satisfaction In order to any delay we'll refund your money.

$40 USD за 1 день
(4 відгуків(и))

I can do this work, database administraton, i aam expert o f mysql. i have advanced experience with rare

$140 USD за 7 дні(-в)
(2 відгуків(и))

I have 20 years of experience with MySQL and two MySQL certifications from Oracle. I regularly work on exactly these kinds of problems and would be happy to throw my bag of tricks at your problem. I can think of severa Більше

$250 USD за 1 день
(1 відгук)

I JUST READ YOUR DESCRIPTION AND I CAN DO THE PROJECT!! Hello I am a senior developer. I want to do it for you if you want. we can discuss more about this project. if you can send a reply. I waiting for you best respo Більше

$140 USD за 7 дні(-в)
(0 відгуків(и))

Hello !!! I can finish your project wonderfully with rich experiences for 9 years. I have a special skills in MySQL fields and I have made a lot of these kinds of projects for my developing period. [login to view URL] Vitali Більше

$150 USD за 2 дні(-в)
(0 відгуків(и))

Hi, Nice to meet you! I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional mysql expert with over 7 years of experience. Seems to be an inte Більше

$140 USD за 2 дні(-в)
(0 відгуків(и))

Hello Sir. I can't sure but before, i succeed with 32GB sql file into the server. If you can send me your file then i can try on my self. after that i will give you perfect answer. But i think it is possible. First of Більше

$100 USD за 7 дні(-в)
(0 відгуків(и))

Hello! According to your job requirements, I have done many projects like yours. For more details you can check profiles I specialize in website design and development and am excited for this opportunity to work with Більше

$100 USD за 5 дні(-в)
(0 відгуків(и))
(0 відгуків(и))

Hi, I'm a Data Warehouse and Database professional with over 11 years of experience in Data related fields. I want to say upfront that I do not have specific experience with this kind of a problem. However, I'm super Більше

$30 USD за 7 дні(-в)
(0 відгуків(и))