I was wondering maybe someone can help me solving this little(or maybe not) problem, I just recently bought a new comp and I had a large MySQL DB stored on the old one, now when I moved all I had little time so I did copy create like insert to all the table(instead of exporting the tables) now the table are not small, and I get memory exceptions when I try to run the queries, I tried to cut the queries but its a lot of tables.... also not so wisely I format the old computer before I checked it was alright.
thank you all, in advance
I am using TOAD but I get a similar error at the workbench,
the error message is:
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(Char value, Int32 startIndex, Int32 charCount)
at Quest.Toad.ImportExport.ExportWizard.GetSql(String SqlScript)
at Quest.Toad.ImportExport.ImportWizard.simpleButtonO penQueryFile_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArg s e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseE ventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Mess age& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Hey and thanks again,
Well I did tried it and it didn't work, in the smaller files (until 15M), but lets for the 100+ it didnt(although I extended the max allowed higher than 100, like 150 for example)any idea why?
I am not sure I follow what you are saying. Are you saying that it worked for tables < 15M but over 15M there are still issues? What I would do is try to do a dump of the database and get all the information out. Then I would cleanup the database and insert the data back in. I suspect there is a corruption of the InnoDB tablespace which is caused by you using different versions of MySQL.
Hey again, I worked it out, for anyone having trouble in the future, first i tried extending the size of the max_alowed_packet through the command prompt and it didnt worked from some reason(still not realizing why exactly), then i just ran the query "SHOW VARIABLES LIKE 'max_allowed_packet'" and and saw which number was there(it was set for around 1.6m I think), then I ran "SET GLOBAL max_allowed_packet=32000000;" ran the query that I wanted(the size of the query was smaller than the 32 mega I set it to) and it worked when I finished i set the globals back to their original values.... not the best and mostelegant but worked for me! also thanks again to Ronan