Changes between Version 3 and Version 4 of copy_mysql


Ignore:
Timestamp:
Jun 25, 2012, 1:03:44 PM (7 years ago)
Author:
Nat Meysenburg
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • copy_mysql

    v3 v4  
    3232mysqldump name-of-source-database > name-of-source-database.sql
    3333}}}
     34  If you get an error like "{{{Access denied for user 'DBUSER'@'localhost' (using password: NO) when trying to connect}}}", you may need to create a `~/.my.cnf` file. On Mayfirst servers, for many web apps, you may be able to automatically create one using the command `mf-generate-my-cnf`. If that does no work, you can create one manually. The format is simple. In a text file in your home directory called .my.cnf place something like:
     35{{{
     36[client]
     37username = DBUSERNAME
     38password = DBPASSWORD
     39[mysql]
     40database = DBNAME
     41}}}
     42  You will want to make sure it's only readable by your user:
     43{{{
     44chmod 600 .my.cnf
     45}}}
     46
    3447 * [wiki:sftp Secure FTP] into the source site server and download the file name-of-source-database.sql to your computer
    3548 * [wiki:sftp Secure FTP] into the target site server and upload the file