Importing Data into MySQL:

Using LOAD DATA INFILE:

MySQL provides the LOAD DATA INFILE statement to import data from external files such as CSV files into database tables.

Specify the file path, table name, and optionally, column mappings.

                        
LOAD DATA INFILE '/path/to/file.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
                        
                    

Using MySQL Workbench:

MySQL Workbench is a graphical tool that can be used as a bridge to MySQL and a great feature is the Import/Export function that enable you to import data from different formats. One of them is the ability to import CSV files.

CSV file is one of the options, and after the selection, you can mention the destination table for import.

Exporting Data from MySQL:

Using SELECT INTO OUTFILE:

MySQL provides the SELECT INTO OUTFILE statement to export query results directly into an external file.

Specify the file path, optionally customize the field and line terminators, and execute the query.

                        
SELECT * INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;

                        
                    

Using MySQL Workbench:

MySQL Workbench additionally offers a wizard service which helps to transform data to various formats like CSV, SQL and JSON, among others.

You can configure these parameters manually to make sure everything is right regarding file format, encoding, and destination place.

Tips for Data Import and Export:

• Secure that the MySQL server is capable of opening the file paths of your database.
• Make sure that the file mode and type have understood well with MySQL.
• Verify data mapping & terminator edits to avoid errors in data loading/unloading.
• Think critically in regards to employing more advanced tools or scripts for the more complex data transformation processes.