Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

resynchronize tables between  two db mysql mariadb

Posted on 2014-01-27
1
382 Views
Last Modified: 2014-02-06
Hello,

I have to resynchronize tables between  two db mysql mariadb innodb. The tables contain million rows.
How can do it because it can take several hours?
Is it possible to do a cold backup and copy the file tables?

Thanks
0
Comment
Question by:bibi92
1 Comment
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 39812670
If you were using innodb_file_per_table, and MySQL 5.6, you could copy the .ibd file from one server to another and import the tablespace. I don't know if mariadb has implemented that.

http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connect MySql database to wordpress site 3 79
Instering to MySQL table 5 66
MySQL Query Using Up Memory 6 43
Complex MySQL Query 2 33
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question