Page 1 of 1

Move database to a fresh install?

Posted: Wed Oct 02, 2019 6:01 pm
by Evilonion
Hi,

Due an ongoing number of errors within my logs I have considered creating a completely fresh install of opencart with a fresh database.
Is it possible to download and transfer all the relevant data such as products, images, orders, customers and customer passwords?

Installing fresh with no modifications may resolve some issues I'm having with website speed and database connections.

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 6:05 pm
by thekrotek
Use PHPMyAdmin for any interactions with the database.

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 6:21 pm
by Evilonion
Is it possible to also move customer passwords?

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 7:01 pm
by thekrotek
Evilonion wrote:
Wed Oct 02, 2019 6:21 pm
Is it possible to also move customer passwords?
They are saved in "customer" database, so yes, of course.

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 10:31 pm
by paulfeakins
thekrotek wrote:
Wed Oct 02, 2019 6:05 pm
Use PHPMyAdmin for any interactions with the database.
This is faster: https://www.adminer.org/

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 10:59 pm
by thekrotek
paulfeakins wrote:
Wed Oct 02, 2019 10:31 pm
This is faster: https://www.adminer.org/
But uglier :-)

Re: Move database to a fresh install?

Posted: Wed Oct 02, 2019 11:38 pm
by paulfeakins
thekrotek wrote:
Wed Oct 02, 2019 10:59 pm
paulfeakins wrote:
Wed Oct 02, 2019 10:31 pm
This is faster: https://www.adminer.org/
But uglier :-)
Well yes, but on a slow server, the speed difference is crazy!