prenreg
asked on
MySQL import issue
Needing to import SQL file into existing DB, Using MyPHPAdmin.
Need to over write existing data tbls from the import tab.
Also, found " mysqlimport --delete database_name file.sql " but not sure where i would place that during import
Big Thx
Need to over write existing data tbls from the import tab.
Also, found " mysqlimport --delete database_name file.sql " but not sure where i would place that during import
Big Thx
" mysqlimport --delete database_name file.sql " that refers to a separate utility program that is not part of phpMyAdmin. I have attached a pic of the main screen for a database in phpMYAdmin. If you click on 'Drop', it will remove the table entirely. If you click on Empty, it will remove the data but keep the table definition.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ooops, I was wrong: I said Rob instead of Dave... Sorry, Dave.
@prenreg, I think you should split points between me and Dave: half of the answer is in his comment.
@prenreg, I think you should split points between me and Dave: half of the answer is in his comment.