| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
drop table if exists t1;
create table t1 (`a` blob);
insert into t1 values("hello world"),("Hello mars"),(NULL);
select load_file(concat(@tmpdir,"/outfile-test.1"));
load_file(concat(@tmpdir,"/outfile-test.1"))
hello world
Hello mars
\N
select load_file(concat(@tmpdir,"/outfile-test.2"));
load_file(concat(@tmpdir,"/outfile-test.2"))
hello world
select load_file(concat(@tmpdir,"/outfile-test.3"));
load_file(concat(@tmpdir,"/outfile-test.3"))
ERROR HY000: File '../../tmp/outfile-test.1' already exists
ERROR HY000: File '../../tmp/outfile-test.2' already exists
ERROR HY000: File '../../tmp/outfile-test.3' already exists
select load_file(concat(@tmpdir,"/outfile-test.not-exist"));
load_file(concat(@tmpdir,"/outfile-test.not-exist"))
NULL
drop table t1;
select load_file(concat(@tmpdir,"/outfile-test.4"));
load_file(concat(@tmpdir,"/outfile-test.4"))
1
CREATE TABLE t1 (a INT);
EXPLAIN
SELECT *
INTO OUTFILE '/tmp/t1.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
FROM t1;
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL NULL no matching row in const table
Warnings:
Note 1003 /* select#1 */ select NULL AS `a` from `test`.`t1`
DROP TABLE t1;
use test;
create table t1(a int);
select * into outfile "MYSQL_TEST_DIR/outfile-test1" from t1;
ERROR HY000: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
drop table t1;
create database mysqltest;
create user user_1@localhost;
grant all on mysqltest.* to user_1@localhost;
select schema_name
into outfile "../../tmp/outfile-test.4"
fields terminated by ',' optionally enclosed by '"'
lines terminated by '\n'
from information_schema.schemata
where schema_name like 'mysqltest';
ERROR 28000: Access denied for user 'user_1'@'localhost' (using password: NO)
grant file on *.* to user_1@localhost;
select schema_name
into outfile "../../tmp/outfile-test.4"
fields terminated by ',' optionally enclosed by '"'
lines terminated by '\n'
from information_schema.schemata
where schema_name like 'mysqltest';
use test;
revoke all privileges on *.* from user_1@localhost;
drop user user_1@localhost;
drop database mysqltest;