Useful Snippets

Welcome!


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at Unwanted.cloud

RSS Latest posts from my personal blog


Subscribe to RSS feed


Dump and import a single MySQL database via command line

Stanislav KhromovStanislav Khromov

To dump, run;

mysqldump --opt --user=root -p --host=localhost --databases mydb > mydb.sql

Where mydb is your database name.

To import it, run:

mysql -u root -p < mydb.sql

Full-stack impostor syndrome sufferer & Software Engineer at Schibsted Media Group

Comments 0
There are currently no comments.