MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:August 3 1999 1:06pm
Subject:Best way to move database
View as plain text  
Wayne Spivak writes:
 > We're running a Mysql 3.22 database on computer 1.
 > 
 > We're going to move it to a bigger better computer, computer 2.
 > 
 > What's the best way to move the database.  We can, if needed turn the Mysql
 > off.
 > 
 > Thanks.
 > 

Hello Wayne,

You don't need to shutdown the MySQL server.
Use mysqldump --tab=/path/to/new/database_dir --lock-tables --opt
Please see manual for more information.

Regards,

- Jani

-- 
+-------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen     |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       jani@stripped   |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki         |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland          |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                   |
|             /*/             \*\            Developers Team  |
+-------------------------------------------------------------+
Thread
How to use the value from a query?Silicon Ghost3 Aug
  • Re: How to use the value from a query?Paul DuBois3 Aug
  • Best way to move databaseWayne Spivak3 Aug
    • Best way to move databaseJani Tolonen3 Aug
    • Re: Best way to move databaseRalph Graulich4 Aug
    • Re: Best way to move databasetonu-mysql4 Aug