![]() ![]() Restart MySQL service for the changes to take effect: Open the my.ini file in one of the text editors (e.g., Notepad ), find the secure-file-priv variable, and set a new location to export MySQL data: ![]() The my.ini file on Windows platform is usually located on this path: C:\ProgramData\MySQL\MySQL Server X.Y\ ![]() ![]() If you are not satisfied with the export location specified in the secure_file_priv variable, it can be changed by editing the my.ini configuration file. The file will be created in the location that is specified in the secure_file_priv variable: FROM location INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/locationNEW.csv' įinally, we managed to export MySQL data: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |