What settings to use to export mysql table rows that I'll be importing to another table with data using phpmyadmin If I'm using phpmyadmin to manage mysql database, what settings should I use to export only two rows of data that I'll be importing to another table with the same name that contains many other rows? 

I used the quick option, but I'm getting an error that table already exists and nothing gets imported. 

If I use the default custom option with the default settings, I get the same error message.

So, what's the best settings to use to export settings that I'm going to import to another table?
You have two possibilities.


use the export at the botton of the table, after selecting you data with the correct data


see 


use SELECT INTO OUTfile


LIKE

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table WHERE n= 1;


Please check the limitations in the link for secure_file_priv

You can after import it via phpmyadmin or use LOAD DATA Statement