Solved

Backup / restore - MySql

Posted on 2011-03-09
7
444 Views
Last Modified: 2012-05-11
translate from portuguese:

I use MySQL and the GUI for backup / restore. I have two databases, with similar size but with very different time to restore (one with 4 minutes and another with 50 minutes). The database that takes longer has many delete operations. I ask for help to solve this.

 Thank you.

"Eu uso o MySql e o GUI para fazer backup / restore. Tenho dois BDs, com tamanhos semelhantes, mas com tempo de restore muito diferentes ( um com 4 minutos e outro com 50 minutos ). O BD que demora mais tem muitas operações de exclusão. Peço ajuda para solucionar isso.

Grato. "

0
Comment
Question by:etm_wkl
[X]
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
  • 4
  • 3
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35082835
there is no "solution", except to stop the many deletes, eventually.
I presume you know that you shall stop all transactions to the database before you actually start restoring?!
0
 

Author Comment

by:etm_wkl
ID: 35086282
translate from portuguese:

The restoration is done on a PC that is not accessed by users. Thus, the current operations do not interfere in the restore operation.
 I hoped there was something like 'shrink database' of mssql or 'pack' of dbf tables.
 Recreate the tables and move data could improve?

"A restauração é feita em um micro que não é acessado pelos usuários. Assim, as operações correntes não interferem na operação de restore.
Eu esperava que existisse algo como 'shrink database' do mssql ou o 'pack' das tabelas dbf.
Recriar as tabelas e migrar os dados poderia melhorar ? "
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35100721
ok, can you please show how exactly you perform the backup and restore?
how big are the backup files?
0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 

Author Comment

by:etm_wkl
ID: 35107835
translate from portuguese:

I use MySQL Administrator Version 1.2.8., and only the default options for backup and restore.
For a file of 215 mb, the restore time is 6 minutes. And, incredibly, to another file, 180 mb, the time is 1 hour (this is the file with many delete operations).
Thank you for your attention.

"Eu utilizo o MySql Administrator Version 1.2.8., e apenas as opções padrão para backup e restore.
Para um arquivo de 215 mb, o tempo de restore é de 6 minutos. E, incrível, para outro arquivo, de 180 mb, o tempo é de 1 hora ( esse é o arquivo com muitas operações de delete ).
Obrigado pela atenção. "
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35169030
I have been checking around, and could not find any options/bug/feature that matches this behavior.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35169033
you might want to submit your problem on mysql.com site directly?!
0
 

Author Comment

by:etm_wkl
ID: 35218414
translate from portuguese:

Because it is a strange case (unknown even by experts), I decided to uninstall everything ( MySql and GUI ) and make a new clean installation. It worked
Grateful for the attention.

"Por tratar-se de um caso estranho ( desconhecido até pelos especialistas ), resolví desinstalar tudo ( MySql e GUI ) e começar do zero. Funcionou.
Grato pelo atenção. "
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
possible to record changes (trigger I think) msql 11 43
Where on a calculated field 1 31
Group By Function Required in PDF Output 21 37
php hashing methods 3 16
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 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