Month: May 2021

Height (in cm)

Weight (in kg)

Calculate

Export Database

One database

mysqldump -u root -p --opt [database name] > [database name].sql

Or all databases:

mysqldump -u root -p --opt --all-databases > [database name].sql

Import Database

mysql -u root -p newdatabase < /path/to/newdatabase.sql

# or to import multiple databases:
mysql -u root -p < /path/to/newdatabase.sql

# if root does not have a password:
mysql -u root newdatabase < /path/to/newdatabase.sql