![]() ![]() For a benchmark, my database was about 500k records and took ~2mins. Allowing you to continue.Īnd naturally, the time to create the backup will vary based on the size of the database and the specs of the server. But once it is done, the terminal will drop back to the prompt. ![]() Unfortunately, you will not see any change in the terminal while the backup is in progress. ![]() This tells the command to send the mysql database records into the specified file.Īfter running the command, you will get prompted for your the password for the mysql_username account. > /path/to/the/new/backup/file.sql - pipes the output from the command into a local file on the same server.datbase_name - simply the name of the MySQL database you want to backup.-p - tells MySQL to prompt me to enter the user's password.-u mysql_username - connects to the MySQL database with the MySQL user account names ' mysql_username'.Enter fullscreen mode Exit fullscreen mode ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |