mysql error

[yhi]

query :

 

select * into dumpfile '/var/www/filename.txt' from calendar

 

 

Error : https://i.imgsafe.org/06af15f31f.png

 

i am not sure what the problem is..

i want to dump file in a public accessible directory but i am not able to understand the sql error please help me with solving the error

please help

 

PS

i am executing commands from phpmyadmin

 

[requinix]

query :

 

select * into dumpfile '/var/www/filename.txt' from calendar

No, your query was

select * LIMIT 0, 25 into dumpfile '/var/www/filename.txt' from calendar

Spend a moment to familiarize yourself with the syntax for a SELECT query.

[yhi]

no m 100% sure my query was

 

select * into dumpfile '/var/www/filename.txt' from calendar

 

& i executed that phpmyadmin to maybe it added that limit :/

as i told i want to dump that table data to a file in a public accessible directory

please help me with correct syntax

[requinix]

If your database server is running on the same machine as your web server then that dumpfile thing is certainly a way to do it. But you won't be able to execute it from phpMyAdmin unless you can find a way to stop it from adding the LIMIT clause.

 

What about phpMyAdmin's Export tab?

[Barand]

How about putting a FROM clause in your query to tell it which table the data is to come from.

[yhi]

If your database server is running on the same machine as your web server then that dumpfile thing is certainly a way to do it. But you won't be able to execute it from phpMyAdmin unless you can find a way to stop it from adding the LIMIT clause.

 

What about phpMyAdmin's Export tab?

export option didnt allow me to export in file extension i want & in directory i want

[yhi]

How about putting a FROM clause in your query to tell it which table the data is to come from.

m not totally sure what you are saying

can you please explain or post the query

thanks

[Barand]

Spend a moment to familiarize yourself with the syntax for a SELECT query.