-1

I built a Drupal 8 site using SQLite. Performance is awful, so I'd like to use MySQL instead. What's the best way to go about this?

A step-by-step guide would be nice, but any advice and tips are appreciated.

Thanks in advance

3
  • See also: Transfer a site from SQLite to MySQL
    – unor
    Mar 15, 2017 at 2:02
  • @unor that link is for Drupal 7
    – pmagunia
    Mar 21, 2018 at 23:39
  • @ParagMagunia: Yes, that’s why it’s just a "see also" and not suggested as duplicate.
    – unor
    Mar 22, 2018 at 8:39

1 Answer 1

0

It has been a while since I've used their product (MSSQL to MySQL) but a place to start might be here:

https://dbconvert.com/sqlite/mysql/

For me it worked flawlessly converting a MSSQL database with 10 years of data into MySQL so I could import it to Drupal 7. I would expect the same quality in this sister product, it's worth a look.

4
  • Thanks. This appears to be a $150 product. There is a trial version, but it has limitations and watermarks database records. I assume Drupal configuration files would need to be modified as well to use a new database driver.
    – Jim U
    Mar 1, 2017 at 0:53
  • For MySQL? I figured if you converted the database to MySQL, you could import it and set a database connecting to it in settings.php and specify the driver as MySQL. If it works, Drupal wouldn't know the difference. And yeah I paid the $100 for a license because the trial result was promising.
    – Kevin
    Mar 1, 2017 at 0:57
  • Which is exactly what I did, I converted, imported to MySQL as a new database, created another connection key in settings.php and voila, it worked. You can try that same approach and see what happens.
    – Kevin
    Mar 1, 2017 at 1:06
  • Get the trial version of navicat premium installed, it's free for 14 days and you can literally drag tables from a MSSQL database to a mysql one. Drupal won't know or care
    – Clive
    Mar 1, 2017 at 7:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.