1. Log in to Manage MySQL<\/strong> tool.<\/p>\n 2. From the Current MySQL Databases<\/strong> section, click on login<\/strong> name for a database to log into phpMyAdmin<\/p>\n 3. Go to the left-hand side of the phpMyAdmin program window, and click on the database<\/strong> in which the table is present.<\/p>\n 4. Click on the table<\/strong> that you want to edit in order to display the Structure page<\/strong> of the table.<\/p>\n 5. Now click on Import<\/strong>.<\/p>\n 6. In the section of File to import<\/strong>, click on Browse<\/strong> to select the file that you want to upload.<\/p>\n 7. Now select the character set<\/strong> of the file.<\/p>\n 8. Specify if you want to allow an interrupt of the import in case the script detects it is close to the time limit. This can be a good way to import large files, however, it can also break transactions.<\/p>\n 9. Select the format<\/strong> of the file to be imported as per your choice.<\/p>\n 10. If you are selecting a file with CSV format or CSV using LOAD DATA<\/strong>, then complete the options \u2022 Replace table data with file:<\/strong> Select this check box, if you want the content of the file to be replaced with the contents in the database.<\/p>\n \u2022 Ignore duplicate rows:<\/strong> Select this check box if you want to import script in order to ignore duplicate rows present in the file.<\/p>\n
\nfields :<\/p>\n