MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 

How to take data back up for InnoDB tables like copy paste?

I want to copy and paste the data files of InnoDB database, is it possible? I mean can I just copy the data files like that we do for MyISAM tables.

Answer No: 1

To take data back up for InnoDB tables like copy paste can be unsafe by some ways.  If you mean for a daily backup while the server is running then it is impossible! You often end up with corrupted tables doing that with MyISAM, too. Use mysqlhotcopy or mysqldump for that. If you stop the server, then copy the files and make sure that you have the same innodb_data_file_path statements at the target host, it may work.

Related MySQL FAQs to the Above FAQ

When-should-we-use-innodb-engine When should we use innodb engine?

How-to-create-innodb-table-in-MySQL How to create innodb table in MySQL?

How-to-install-Innodb-Engine How to install Innodb Engine?

How-to-uninstall-Innodb-Engine How to uninstall Innodb Engine?

How-to-rename-a-database-with-full-Innodb-Tables How to rename a database with full Innodb Tables?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.