This is a discussion on server disconnects on 7MB script within the MySQL forums, part of the Database Server Software category; --> I am attempting to do a restore from a 7MB sql script generated from MySQL Administrator Backup. includes BLOBs ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am attempting to do a restore from a 7MB sql script generated from MySQL Administrator Backup. includes BLOBs and multiple databases. server has locked out mysql.exe from access by root@localhost, probably because of trying to use it to execute the script and server disconnecting. 3/4 way through. (how is that possible, and how can I unlock it?) query browser is useable, but it gives errors well, now I try mysql.exe and it has locked up hard. won't die. |
| |||
| "Jim Michaels" <NOSPAMFORjmichae3@yahoo.com> wrote in message news:lomdncZ4MPvek7fZnZ2dnUVZ_t2dnZ2d@comcast.com. .. >I am attempting to do a restore from a 7MB sql script generated from MySQL >Administrator Backup. includes BLOBs and multiple databases. > server has locked out mysql.exe from access by root@localhost, probably > because of trying to use it to execute the script and server > disconnecting. 3/4 way through. > (how is that possible, and how can I unlock it?) > query browser is useable, but it gives errors > > well, now I try mysql.exe and it has locked up hard. won't die. > Why don't you just ask to your hosting company? Why do you want to *unlock* while you know that it's not permitted? Just find a solution with your hosting company without thinking about things that can lead you to useless problems. The hosting company can close your account if you try to break thing because it's illegal. Regards -- Leonardo Armando Iarrusso - J2Be www: http://www.J2be.com - e-mail: info[at]J2Be.com |
| ||||
| "J2be" <info@nospamj2be.com> wrote in message news:442a6749$0$36929$4fafbaef@reader3.news.tin.it ... > > "Jim Michaels" <NOSPAMFORjmichae3@yahoo.com> wrote in message > news:lomdncZ4MPvek7fZnZ2dnUVZ_t2dnZ2d@comcast.com. .. >>I am attempting to do a restore from a 7MB sql script generated from MySQL >>Administrator Backup. includes BLOBs and multiple databases. >> server has locked out mysql.exe from access by root@localhost, probably >> because of trying to use it to execute the script and server >> disconnecting. 3/4 way through. >> (how is that possible, and how can I unlock it?) >> query browser is useable, but it gives errors >> >> well, now I try mysql.exe and it has locked up hard. won't die. >> > > Why don't you just ask to your hosting company? local install of 5.0.19 essential > Why do you want to *unlock* while you know that it's not permitted? reboot fixed it. > Just find a solution with your hosting company without thinking about > things that can lead you to useless problems. > The hosting company can close your account if you try to break thing > because it's illegal. good reminder... > > > Regards > > > -- > Leonardo Armando Iarrusso - J2Be > www: http://www.J2be.com - e-mail: info[at]J2Be.com > |