Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Backup / restore - MySql

Posted on 2011-03-09
7
Medium Priority
?
476 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
  • 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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 

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 2000 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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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…
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
Course of the Month15 days, 15 hours left to enroll

580 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