MySQL/Backup and restore databases: Difference between revisions
< MySQL
Jump to navigation
Jump to search
mNo edit summary |
|||
Line 29: | Line 29: | ||
Make sure to have the correct database(s) selected | Make sure to have the correct database(s) selected | ||
[[File:Phpmyadmin export 1 method.png|phpMyAdmin - Export - Selection]] | [[File:Phpmyadmin-export-1-method.png|phpMyAdmin - Export - Selection]] | ||
'''Output:''' | |||
Create your output filename in case you do not want the default created output filename. | Create your output filename in case you do not want the default created output filename. | ||
[[File:Phpmyadmin export 2 output.png|phpMyAdmin - Export - Output]] | [[File:Phpmyadmin-export-2-output.png|phpMyAdmin - Export - Output]] | ||
Object creation options: | '''Object creation options:''' | ||
* include Add DROP DATABASE IF EXISTS statement | * include Add DROP DATABASE IF EXISTS statement | ||
* include Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement | * include Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement | ||
[[File:Phpmyadmin export 3 object creation.png|phpMyAdmin - Export - Object creation]] | |||
[[File:Phpmyadmin-export-3-object-creation.png|phpMyAdmin - Export - Object creation]] | |||
Press on the Go button in the bottom left corner, and the export will start. A download link of the export file will be presented to you when the database export has completed. | Press on the Go button in the bottom left corner, and the export will start. A download link of the export file will be presented to you when the database export has completed. | ||
Line 80: | Line 85: | ||
Copy the script below into your favorite text-editor and save it as a .sh (bash) file into the location+filename of your chosing, and make the file executable with: | Copy the script below into your favorite text-editor and save it as a .sh (bash) file into the location+filename of your chosing, and make the file executable with: | ||
<syntaxhighlight lang="bash">chmod +x filename.sh</syntaxhighlight> | <syntaxhighlight lang="bash">chmod +x filename.sh</syntaxhighlight> | ||
Revision as of 10:27, 25 January 2022
Incomplete: This page/section is under construction |