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


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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL ( and MongoDB (…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

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