exporting_importing_database_tips
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
exporting_importing_database_tips [2008/08/08 14:54] – created juckins | exporting_importing_database_tips [2008/08/08 14:56] – juckins | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | Use phpMyAdmin to export databases. | + | Use phpMyAdmin to export databases. |
- | On new machine, make sure database does not exist. | + | On new machine, make sure database does not exist. |
- | On original machine, select database which you wish to export. | + | On original machine, select database which you wish to export. |
+ | |||
+ | 1. First export just the " | ||
+ | 2. Then export just the " | ||
+ | 3. On target machine, import Structure file first. | ||
+ | 4. You might need to restart the mysql database server with this command (note max_allowed_packet setting): | ||
+ | < | ||
+ | su - mysql | ||
+ | / | ||
+ | </ | ||
- | 1. First export just the " | ||
- | 2. Then export just the " | ||
- | 3. On target machine, import Structure file first. |
exporting_importing_database_tips.txt · Last modified: 2008/08/09 18:10 by juckins