Re: Updating a Prestashop SQL Database
MySQL 5.6.33
Linux Server
I think I can just run a shell script to do this
>mysql < script table_1
where script contains the logic to open the old DB, extract the table data, open the new DB, clear the existing table data, and import the table data from the old DB
I have about 30 tables to process. I know I can do this in cPanel but it is a pain to click off the extract tables, extract them, and click on the import table entries. I want to avoid any possible human errors by automating the process with a script.
Thank you,
Joe
Subject
Written By
Posted
December 28, 2016 12:01PM
December 28, 2016 12:42PM
Re: Updating a Prestashop SQL Database
December 29, 2016 03:19PM
December 29, 2016 04:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.