List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 12 1999 10:05am
Subject:backup from a database
View as plain text  
Ruprecht Helms writes:
 > Hi,
 > 
 > how can I make a Backup from a mysql-database
 > 
 > Thanks
 > 
 > Ruprecht
 > 

Hi!

shell> mysqldump --tab=/path/to/some/dir --lock-tables --quick

Or shut down mysqld and just cp the *.frm, *.ISD, *.ISM files
where you want to.

Please consult the MySQL manual about this.

Regards,

- Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
Thread
backup from a databaseRuprecht Helms12 May
  • backup from a databaseJani Tolonen12 May