4 ms·
# mysqldump -u (user) -p (database name) > (destination filename) mysqldump -u root -p some_project > some_project.sql # to import: # mysql -u (user) -p
by thomasmallen 18y ago
# mysqldump -u (user) -p (database name) > (destination filename)
mysqldump -u root -p some_project > some_project.sql
# to import:
# mysql -u (user) -p (database name) < (backup file)
mysql -u root -p some_project < some_project.sql