I have root access to all my mysql databases. how can i export/import all the databases at once? -

All mysql databases have root access. How can I export / import all databases at a time?

mysqldump can do this.

  mysqldump --all-database & gt; Backupfile  

to import

  mysql & lt; Backup file  

You can also close the server and copy / copy / RCIN to mysql data directory, but it is probably hard to restore and I do not recommend it.