Hi Alex, I've used this method to start a replication slave without using MySQLdump to get the data from one machine to another. Option 1 works for sure, Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is changed while you are copying, you get a broken file on the other end). I'm not sure about option 2, but I think it should work.
Best regards, Michael > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Alex K > Verzonden: maandag 28 januari 2008 14:34 > Aan: MySQL General List > Onderwerp: backup questions > > Hi guys, > > Is it safe to perform a backup of a database by copying its mysql > files if the database is: > > 1) MyISAM and the database is not being used (mysql server turned off)? > > 2) InnoDB and and the database is not being used? > > 3) MyISAM and the database is being used? > > 4) InnoDB and and the database is being used? > > I know I can use mysqhotcopy or mysqldump but I'm just curious if it's > possible to perform a backup by simply copying the files over in the > conditions described above. > > Thank you so much, > > Alex > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
