Difference between revisions of "MySQL/migration"
< MySQL
Jump to navigation
Jump to search
m |
m (Woozle moved page MySQL/porting/data to MySQL/migration without leaving a redirect: reorganizing) |
||
(26 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | ==About== | |
− | + | This subpage is about migrating data between [[MySQL]] databases, i.e. backing up data to independent files, and restoring the data from those files back into a database | |
− | == | + | |
− | + | There is a choice of tools for doing this. | |
− | + | * [[Beekeeper Studio]], but only the paid versions | |
− | + | * [[mysqldump]] (command-line) | |
− | + | * [[MySQL Workbench]] (GUI utility) | |
− | + | * [[PHPMyAdmin]] (web-based) | |
− | + | * '''obsolete''': | |
− | + | ** [[MySQL Admin]] (GUI utility) - this has been replaced by [[MySQL Workbench]] | |
− | + | ==Related Resources== | |
− | + | * [https://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] ([https://web.archive.org/web/20081218005549/http://members.lycos.co.uk/wipe_out/automysqlbackup/ origin story]) | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | == | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 16:33, 4 November 2024
About
This subpage is about migrating data between MySQL databases, i.e. backing up data to independent files, and restoring the data from those files back into a database
There is a choice of tools for doing this.
- Beekeeper Studio, but only the paid versions
- mysqldump (command-line)
- MySQL Workbench (GUI utility)
- PHPMyAdmin (web-based)
- obsolete:
- MySQL Admin (GUI utility) - this has been replaced by MySQL Workbench