I plan to dump all databases on one computer and restore them on another using the following 2 commands:-
mysqldump -u username -p --all-databases > dump.sql mysql -u username -p < dump.sql
My query is : will the second command overwrite an existing table with the same name as on the first computer ? Also, will the second command delete all tables which are NOT there on the first computer?
Can someone please clarify?