MySQL Forums
Forum List  »  General

Data Export and Import
Posted by: Jim Sawyer
Date: June 01, 2021 10:13AM

0


I need some details on importing and exporting MySQL 8 database.

If the entire database is backed up in one dump, is it possible to restore a single table, or should the individual tables be exported?

When setting FOREIGN_KEY_cHECKS, UNIQUE_CHECKS, AND aUTOCOMIT to 0, is this done to the database that you are importing to from MySQL? If so, it seems to have no effect for me. If not, please provide the details on how to do these settings.

Should the settings in 2) be done to the database prior to exporting in order to get faster importing?

I just need a good tutorial on exporting and importing. This 12 hour import of one table with 5M records and several indexes is for the birds.

Thank you, Jim Sawyer

Options: ReplyQuote


Subject
Written By
Posted
Data Export and Import
June 01, 2021 10:13AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.