Difference between revisions of "MySQL/migration"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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 porting data into and out of [[MySQL]] databases.
+
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.
* [[/phpmyadmin]] (web-based)
+
* [[Beekeeper Studio]], but only the paid versions
* [[/mysqldump]] (command-line)
+
* [[mysqldump]] (command-line)
* [[/mysql-admin]] (GUI utility) - obsolete; this has been replaced by MySQL Workbench
+
* [[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.

Related Resources