<div>
I have versions 4.0.10 and 4.7.0 and I can see what you mean. &nbsp;However, I have never checked that option when I have uploaded CSV files. &nbsp;If you are unsure, you can make a copy of the original table, do the CSV upload to the copy, and then rename the copy back to the original name if the upload succeeds.
</div>


<div>
@Dave thanks for reply. I have done what you suggested but what ever I try no data is entered. I have tried with 
<pre><code class="code-1 nolinks" id="code-20-42123997-1"><span>'Update data when duplicate keys found on import' </span>
</code></pre>
ticked and unticked. Can I then ask how you perform an update using CSV file? Thanks
</div>


<div>
I even tried the following and does nothing. Think it may be something on the server.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42124008-1"><span>LOAD DATA INFILE '/var/www/csv/MORE-destruction.csv' REPLACE INTO TABLE `boxes` FIELDS TERMINATED BY ',' ENCLOSED BY '&quot;' ESCAPED BY '&quot;' LINES TERMINATED BY '\r\n';</span>
</code></pre>
</div>


<div>
Please see <a href="https://media.readthedocs.org/pdf/phpmyadmin/latest/phpmyadmin.pdf" rel="ugc">https://media.readthedocs.org/pdf/phpmyadmin/latest/phpmyadmin.pdf</a><br />
<br />
I have never used this, but I found relevant-looking information on page 62, 94-96, 102, 115. &nbsp;Maybe worth a quick look.
</div>


<div>
@Ray Thanks for that. Nothing there though that I wasn't aware of. Makes no mention of what replaced the replace data option of previous versions. I am now getting an error in phpmyadmin below which is strange because I have setup peter as a mysql user with password. Think I may need to ring 1and1 bloody 1.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42124016-1"><span>#1045 - Access denied for user 'peter'@'%' (using password: YES)</span>
</code></pre>
</div>


<div>
When I open phpmyadmin there is no option to set priviliges. Guess it must pick it up from plesk. But it isn't. Guess something may have broken on update. Time to get digging lol
</div>


<div>
There are several things about uploading CSV files. &nbsp;1. &nbsp;The columns in the CSV file either must match exactly the columns in the table or 2. You must enter the list of the columns in the CSV file in the correct order at the bottom of the import page. &nbsp;If you have a AUTOINCREMENT id in a column, you will have to enter the column names. &nbsp;If your CSV file has a 'header' row, you must enter the number of rows to skip which is usually 1. &nbsp;I usually copy the table to a new name and then TRUNCATE the table. &nbsp;That keeps the structure but deletes all the previous data. &nbsp;Then import the CSV data.<br />
<br />
If you are on Shared Hosting, it is unlikely that you can add another user. &nbsp;The hosting company normally sets the only privileges that you have.
</div>


<div>
@Dave What I normally do is export from MySql as CSV for Excel with column headers. Make my changes to data, remove the header and save as comma delimited CSV. But, on this occassion, I am dealing with unknown id, so that field is blank. So I need to find a way to import using some other clause such as in the where clause. Thanks
</div>


<div>
Thank you dave for your help
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
Probably a very simple answer to my question but here goes.<br />
<br />
Plesk has updated phpmyadmin to V4.5.1 and when I try to import a CSV file there is no option to 'Replace table data with file'. I have searched the docs but cannot find any reference to why this is missing or what has replaced it.<br />
<br />
How do I update using CSV and replace the table data with new data via CSV.<br />
<br />
I just want confirmation from experts before I start the process to avoid mistakes.<br />
<br />
Thanks
</div>
</div>


Hello

Probably a very simple answer to my question but here goes.

Plesk has updated phpmyadmin to V4.5.1 and when I try to import a CSV file there is no option to 'Replace table data with file'. I have searched the docs but cannot find any reference to why this is missing or what has replaced it.

How do I update using CSV and replace the table data with new data via CSV.

I just want confirmation from experts before I start the process to avoid mistakes.

Thanks

No option to replace table data in phpmyadmin using CSV file import

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.