MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Out of memory error during remote backup, is this my servers memory? Options · View
Guest
#1 Posted : Friday, December 9, 2011 12:22:41 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
So I got an error during a remote backup and it was something to do with insufficient memory. I was curious if I need to have enough memory to hold the entire database or if it simply scripts it a certain amount of lines at a time?

Any help or advice would be appreciated. It's running on a cloud so I can simply increase the memory if needed but I'd like to be sure thats the issue.
Guest
#2 Posted : Friday, December 9, 2011 7:57:47 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Database scripting failed: An error occured while getting table data. >> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at e.a.a(Byte[] A_0)
at d.l.c(String A_0, Stream A_1)
mikeshilov
#3 Posted : Monday, December 12, 2011 1:25:17 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Probably you try to backup a very large amount of data. We didn't test this feature on very big data amount that's why it's still in beta. I suggest you to find another backup method in your case.
Guest
#4 Posted : Wednesday, June 6, 2012 10:39:16 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
I have this error also. The backup works fine on a larger database and the second database is a very small database. If fails on the small one. So I doubt the issue is to do with size.
Guest
#5 Posted : Tuesday, July 3, 2012 5:23:50 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Message was deleted by Moderator.
Alexander Omelchenko
#6 Posted : Monday, August 15, 2016 4:49:47 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Please try to install the latest available for your SQLBackupAndFTP version and check it again.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com