If I use "innodb_file_per_table", how do I properly back-up that table so it could be imported to another server should something happen to my main server if I do not have the hot-back-up utility?
If I lock & then copy the table, can I simply use "ALTER TABLE tbl_name IMPORT TABLESPACE" for it to work with another mysql server? Thanks for any help. Best Regards, Andrew