Databases Export and Import

Export all databases via terminal 🙂

  • ssh root@address
  • user password ********

cd Saving path

  • mysqldump -u root -p --all-databases > all_dbs.sql
  • databases Password ***********

Export single databases via terminal 🙂

  • ssh root@address
  • user password ********

cd Saving path

  • mysqldump -u root -p databases_name > databases_name.sql
  • databases Password ***********

IMPOrt single & All databases via terminal 🙂 only one change

(> Or <)

( > This symbol is Export Databases & < this symbol Import databases ) 🙂

Example :-

Like Import Database

mysqldump -u root -p databases_name < databases_name.sql

Like Export Database

mysqldump -u root -p databases_name > databases_name.sql

Leave a Reply

Your email address will not be published. Required fields are marked *