Difference between revisions of "MySQL/migration"
< MySQL
Jump to navigation
Jump to search
(Replaced content with "==About== This subpage is about porting data into and out of MySQL databases. There is a choice of tools for doing this. * /phpmyadmin (web-based) * [[/mysqldump]...") Tag: Replaced |
|||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | This subpage is 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. | 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== | ==Related Resources== | ||
* [https://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] ([https://web.archive.org/web/20081218005549/http://members.lycos.co.uk/wipe_out/automysqlbackup/ origin story]) | * [https://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] ([https://web.archive.org/web/20081218005549/http://members.lycos.co.uk/wipe_out/automysqlbackup/ origin story]) | ||
Revision as of 16:32, 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