phpmyadmin import & overwrite table

  database, mysql, php, phpmyadmin

this has been annoying me for weeks and i cant find a proper solution.
im running a VPS
centos 7 (and aapanel which has no relevance)
php 7.4
mysql 5.7
phpmyadmin 5.0

ive gone into phpmyadmin, exported a table, updated 5000 rows, and i want to import and overwrite the old data into the same table.
the ‘browse’ and import is not an option(as vps error 503/low ram to load) and so ive tried to add it by SQL tab:

LOAD DATA LOCAL INFILE '/database/links.csv' 
INTO TABLE links 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY 'n';

with permission denied

*yes, ive added

[MySQLi]
mysqli.allow_local_infile = On 

to my.conf and even tried to add to php.ini
and restarted apache and even tried removing LOCAL(Saw that on stack too) with no avail*

does anyone have an updated version, or know of a solid solution to this annoying, but should be easy solution?

Source: Ask PHP

LEAVE A COMMENT