Changes between Version 3 and Version 4 of copy_mysql

Timestamp:

Jun 25, 2012, 5:03:44 PM (13 years ago)

Author:

Nat Meysenburg

Comment:

--

copy_mysql

@@ -32 +32 @@
 mysqldump name-of-source-database > name-of-source-database.sql
 }}}
+  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:
+{{{
+[client]
+username = DBUSERNAME
+password = DBPASSWORD
+[mysql]
+database = DBNAME
+}}}
+  You will want to make sure it's only readable by your user:
+{{{
+chmod 600 .my.cnf
+}}}
+
  * [wiki:sftp Secure FTP] into the source site server and download the file name-of-source-database.sql to your computer
  * [wiki:sftp Secure FTP] into the target site server and upload the file