So I'm switching VPSs, and have already done a backup of all the data files and moved them over. However I still need to move all the old databases over. I've been searching the internet for the best way of doing so, but am undecided. I attempted to use the mysqldump command, then use scp to transfer the file, and import the database on the new server, however I was getting an error from doing that, and it would be more preferable if I could transfer all databases at once. If that isn't possible, then I would do them 1 at a time but I'll need to get this error fixed.mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '                                                                                                                                                          /var/lib/mysql/mysql.sock' (2) when trying to connectThank you <3
Best way to migrate many SQL databases
linux;centos;mysql;database