Import SQL File into existing DB-Table (phpmyadmin)

Question

I have an SQL-File defining a table with 2 columns - product-id and product-reference. I need to import that file into an existing table that has the same structure (plus some extra columns), where product-id corresponds to the product-id from the backup file. Is there a simple way to do that via phpmyadmin?

Gordon Linoff · Accepted Answer · 2014-12-06 13:37:27Z

2

One approach is to use load data infile (see here) with the set option to assign column values. Columns that are not being set will be given their default values, which is typically NULL.

Personally, I would load the data into a staging table with two columns and then insert the data from the staging table into the final table. This makes it easier to validate the data before putting it into the "real" table.

answered Dec 6, 2014 at 13:37

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Đinh Carabus Over a year ago

I went with the latter option, after doing a test locally. Worked like a charm, thanks!

Collectives™ on Stack Overflow

Import SQL File into existing DB-Table (phpmyadmin)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related