I'm trying to back up and restore a MySQL database using mysqldump. With my commands I am making a back up file and then restoring that file, but where I'm restoring the database shows no change.
This creates the backup folder in the same directory as the mysqldump.exe file:
In the windows cmd: mysqldump -u root -pxxxxxx test2 > test2backup.sql
Restoring with that file: mysqldump -u root -pxxxxxx test < test2backup.sql
test is an empty database. test2 is a database with tables and data. Running this should fill test with test2's data using the test2backup.sql file, should it not?
For importing you do not need
mysqldumprather