Sql MySql Dump Command for Dumping Data into a file

Mistakes to avoid when using MySQL dump command to dump data into a file

  1. Do not put mysql dump command inside a MySQL command prompt: Log in SSH and choose your folder you want to dump the data from the database then do; sudo mysqldump [databaseName] > [NameOfTheFileYouWantDataToBeDumpedIn].sql
  2. Vise-vesa if you want to restore the database with MySQL command in Ubuntu 18.04 MySql Client do; [In the Mysql Command Console] type show databased; (Database will  be shown), then type; use [DatabaseName]; and database will be changed. Then to restore the database, just type; source /var/www/(wherever you stored the sql dump file); (Make sure you include a (;))

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
Login to Continue

Community of Software Developers

Welcome, log in to continue reading. It's free and only takes a minute.




© 2020 - ErnesTech - Privacy