Restore Magento 2 attribute and related products

[apetrail_RAJ]

I am going to restore database I have just one question should I delete the old database tables the restore the whole database again? I am new to Magento  2 so i am asking the process of restoring database

[Sunil Patel]

Hello,

You need to create new db and restore there.

Then after thing setup you need to remove current db.

[Manthan Dave]

@apetrail_RAJ - First take a backup of your existing database or make a clone of existing database.

then and then remove existing database and import the database which you get from backup.

so you restoring process would be a smoother and not cause any issues

[Rakesh Jesadiya]

You need to take backup of latest databases because the possibility to there are some new orders are placed after you were deleted attribute set so latest DB backup will useful for getting order details and sales related stuff to compare with previous.

Export Database which was given by hosting provider and check order, invoice and shipping status with latest database.

[apetrail_RAJ]

Thanks for the reply, the database is too big and it's not going to install on the local server I have increased the memory limits and upload file size, execution time etc but not going to install any other way to install database?

[Manthan Dave · Accepted solution]

@apetrail_RAJ - You need to import that database using command line.

open your terminal then run below command :

mysql -u username -p database_name < /path/to/file.sql

where database_name = your database name

path = where you have puted the sql file of the database. 

After running this command It will ask you for password - so add your mysql password.

Or if you are logged in mysql command line then below is the alternative option :

From within mysql:

mysql> use db_name;
mysql> source backup-file.sql;

[Rakesh Jesadiya · Accepted solution]

You can install database using SSH, Using command line tools to import database is fast and reliable way for database.

You can import using command line to below way,

mysql -u {username} -p {databasename} < {path of sql file to import}

after hit above command ask for password and just type password,