Difference between revisions of "MySQL"

MySQL (view source)

162 bytes added , 13:03, 19 April 2012

m

→‎Migrate Databases: Minor update - note on running on Windows

2,187

edits

@@ Line 228: / Line 228: @@
 There are a number of GUI tools provided to assist in migrating data from one server to another, and these are well worth a look (eg MySQL Migration Toolkit, MySQL Workbench).  However I have found that on occasion I can't get these to work (normally due to apparent permissioning issues, despite having full rights), and revert to the old fashioned manual way.
-This procedure works for Windows and Unix systems alike, the <code> mysql </code> and <code> mysqldump </code> commands need to be run from the normal Unix shell or Windows command line prompts, not from with the mysql software.
+This procedure works for Windows and Unix systems alike, the <code> mysql </code> and <code> mysqldump </code> commands need to be run from the normal Unix shell or Windows command line prompts, not from within the mysql software, though on Windows you'll probably need to change directory (<code>cd</code>) to where MySQL is installed (something like <code>C:\Program Files\MySQL</code>).
 # Export the database from the source machine (from either Unix shell / Windows command prompt as your sourec machine dictates), eg for database called <code> sourcedb </code>
 #* <code> mysqldump -u root -p sourcedb > sourcedb.sql </code>