MySQL Forums
Forum List  »  Newbie

Re: Updating a Prestashop SQL Database
Posted by: Joe Germann
Date: December 29, 2016 03:19PM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: Updating a Prestashop SQL Database
December 29, 2016 03:19PM


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.