MySQL/Backup and restore databases: Difference between revisions
< MySQL
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 80: | Line 80: | ||
{{MySQLdump_Linux}} | {{MySQLdump_Linux}} | ||
</tab> | </tab> | ||
</ | <tab name="Importing data"> | ||
===GUI applications=== | |||
All the tools mentioned on this wiki page for exporting data, are also capable (of courses) of importing those exported databases. The positive thing about of importing/restoring the databases and their contents, is that there are not specific settings to set beforehand. All details are in the previously exported .sql files. | |||
Thus, choose the GUI tool you wish to use, select import function and the .sql file you want to import, and let the tool do its job. | |||
===Command line=== | |||
From the command line in a terminal session, things are just as easy. Enter the following: | |||
<syntaxhighlight lang="dos"> | |||
mysqldump -u -p < /path/to/your/exportfile.sql | |||
</syntaxhighlight> | |||
Enter the database user and the appropriate password when asked for, and the import will commence. Depending on the size of the import, it can take a couple of minutes. Should there be errors during the import process, then those will be displayed promptly. | |||
</tab> | |||
</tabs> | |||
<headertabs/> | <headertabs/> |
Revision as of 09:45, 26 January 2022
Incomplete: This page/section is under construction |