Exporting & Importing a SQL Dump

September 7, 2024

This is not a tutorial, it is simply a quick help on exporting and importing mysql database dumps. I hope you enjoy!

Exporting a SQL Dump

To export a mysql database dump:

							
							
					mysql -u <username> -p <db_name> > /path/to/dump.sql

Importing a SQL Dump

To import a mysql database dump:

							
							
					mysql -u <new_db_username> -p new_database_name < /path/to/dump.sql

That’s a wrap!

Walter Miely is a tech entrepreneur and CEO of Phoenix Ignited Tech You can find him on Linkedin. This material is licensed under the CC BY 4.0 License LEGAL DISCLAIMER: The content provided here is provided AS IS, and part of, or the entirety of this content may be incorrect. Please read the entireLegal Disclaimer here.

Legal Disclaimer This website and all content on this website including but not limited to educational content, tutorials, software tutorials, cyber security tutorials, server management tutorials, application tutorials, is provided "AS IS" with absolutely no warranty including absolutely no warranty of Usability or Merchantability, not even implied warranty. Read the full disclaimer here: PHOENIX IGNITED DISCLAIMER
All Logos and Copywritten material is the trademark and / or copyright of the respective owners / companies. The respective owners / companies hold all rights to the respective trademarks / copy written material and is displayed on this site strictly in accordance with any agreements between Phoenix Ignited LLC and the respective owners / companies.

+ Ave Maria +

Exporting & Importing a SQL Dump