View Single Post
  #3  
Old 04-13-2004, 11:43 AM
smogo
Discordant
 
Join Date: Jan 2004
Location: 47
Posts: 339
Default

copy and restore work fine, EXCEPT :
- if u use other filesystem than InnoDB (Mysql storing to files)
- if u change version

Also, just a tip :
it's sometimes a good idea to use --complete-insert when dumping, especially if no table drop/create. This allows to reimport data to database when table column have been added/moved

np, that was just a good idea to point out backup question and provide scripts. Thanks Gonkers [/img]
Reply With Quote