Backup / restore - MySql

Posted on 2011-03-09
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. "

Question by:etm_wkl
  • 4
  • 3
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?!

Author Comment

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 ? "
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?
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.


Author Comment

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. "
LVL 143

Accepted Solution

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.
LVL 143

Expert Comment

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

Author Comment

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. "

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Trigger usage 2 75
updating table data with inner join 9 45
MySQL Grouping 2 48
sql_mode 1 30
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

840 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