Question: Im trying to create a database with MySQL and when trying to transfer in the data from the file, it is giving me an error.

Im trying to create a database with MySQL and when trying to transfer in the data from the file, it is giving me an error. * See the code and error below*

How do I correct this?

mysql> LOAD DATA INFILE 'C:\wamp64\www\PHP_Projects\PHP_Projects\Chapter.07\Projects\team_stats.txt'

-> INTO TABLE teamstats;

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement mysql>

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please, this assignment is about Database integration, we have worked on html web page creation where we create html web pages, then we move on to the MVC application with servlet and JSP, then...

Please let me know what other information is needed for my question to be answered. Thank You. I'm trying to create a PHP file for a program that will connect building schematics, and panoramic...

Assignment 4 JSP, Servlet, and MVC - Database Integration This assignment is to be completed individually. No group work is allowed. This assignment is intended to familiarize you with using...

i'm trying to create login/registration form using python flask(where the user able to register successfully and then login with the username and password he register with , saved in sql database...

Please let me know what other information is needed for my question to be answered. Thank You. I'm trying to create a PHP file for a program that will connect building schematics, and panoramic...

Constructors |Assignment 2 Each class should have one default constructor and another constructor with required parameters. In this project you will be developing a class library for account classes...

I need help fixing my code and finishing it. I'm trying to use the Try and accept and else. It's missing the some of the file configuration. The files basic_config.json and config_override was alredy...

Hello. I need help understanding how to create a 2D array based upon a text file. I'm reading in from a text file full of ints. The text file is called TempInFile. I'm trying to understand how to...

- 1190 S (m) Date ) 30. of varies Dutes formal de transactie 20. 120 L 12 91 2) imary 4rary art.pl 95 05.data-rawcales streeport Publishers orth America, data frameworth americane 100 ruutpretro.al...

How would you code this out? Can you also add in comments to explain your logic at each part. Thank you. In this project you will be developing a class library for account classes that can be used to...

"Mutiny is the act of lower authority rebelling against any form of higher authority." Consider the theme of organizational change and resistance, and group conflict and resolution. When is a mutiny...

Specialized ratios are sometimes used in specific industries. For example, the so-called book-to-bill ratio is closely watched for semiconductor manufacturers. A ratio of .93 indicates that for every...

Jada wants to transfer some assets to a trust this year; the income beneficiaries will be her two grandchildren. The trust income and assets will be used to pay the grandchildren's tuition to private...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What tends to skew and distort Average Salaries in most Gender Pay Equity Studies?

The FedScope employment database has a number of Dimension Tables and a Single Fact Table, as shown in Table 7.1. Which columns/data elements in the Fact Table would be most useful in Pay Equity...

After Defining and Building a Multidimensional OLAP Cube, what is stored in the Cube?