Changes between Version 1 and Version 2 of copy_mysql


Ignore:
Timestamp:
Jan 13, 2010, 3:05:09 PM (14 years ago)
Author:
Jamie McClelland
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • copy_mysql

    v1 v2  
    11= How do I copy my MySQL database from one site to another? =
    22
    3 There are two methods you can use.
     3There are two methods you can use. If both your source database and the target database are on May First/People Link servers, then both methods are available to you. If either the source or the target are on other servers, then they may or may not work depending on the software and access provided by the other provider.
    44
    55== Using phpMyAdmin ==
    66
    7 If your database is relatively small (less than 5 or 10 MB), you can use [wiki:phpmyadmin_link phpMyAdmin] to export your database from one site and then import it into another. You will need the ''database'' username and password for each site.
     7If your database is relatively small (less than 5 or 10 MB), you can use [wiki:phpmyadmin_link phpMyAdmin] to export your database from one site and then import it into another. For this method to work, both the source and target database servers must have the phpMyAdmin program installed. All May First/People Link servers have phpMyAdmin installed (see our [wiki:phpmyadmin_link our phpMyAdmin FAQ to learn how to access it]).
    88
    9  * Login with the the source database username and password.
     9You will need the ''database'' username and password for each site (this may be different from the ssh/sftp/ftp username and password for the site). Please see our [wiki:database_password faq on retrieving your database password] if you don't know it.
     10
     11 * Login to phpMyAdmin with the the source database username and password.
    1012 * Click the export button
    1113 * Select the database you want to export