Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Backup / restore - MySql

Posted on 2011-03-09
Medium Priority
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?
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.


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 2000 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 mysql.com 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

618 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