Exporting Customer data and sales from SQL Database

Hi Guys, I had my whole website go down and the backups were corrupt which is another story...

So I started fresh with new install etc....But I want to import all the old customer data and sales information. How do I export that from the SQL Database so I can import it into the new one?

Sounds like you should get some decent hosting with backups and then probably pay a developer to sort this one.

You will need to access your database through phpmyadmin
You mentioned corrupt backups, which doesn't sound too good!

I would recommend exporting your most important tables individuals and inserting them into your new database.
You could set up a local database, to get the hang of exporting/importing - XAMPP or similar.

oc_order, oc_customer etc

CrazyDomains are doing the hosting. They tried to setup SSL for Opencart 2.2 for me and you can guess the result...

paulfeakins wrote:Sounds like you should get some decent hosting with backups and then probably pay a developer to sort this one.

The Database isn't corrupt just the site......I wasn't 100% sure whether or not I could export certain tables and insert them. If you can then that is no issue. I can use phpmyadmin to do so but just wanted to check before I went and did anything.

Pooleyy wrote:You will need to access your database through phpmyadmin
You mentioned corrupt backups, which doesn't sound too good!

I would recommend exporting your most important tables individuals and inserting them into your new database.
You could set up a local database, to get the hang of exporting/importing - XAMPP or similar.

oc_order, oc_customer etc

If the database is intact, why not simply reupload the site files from default download of same version?