problem import mysql backup in Plesk

Portal Home > Knowledgebase > Articles Database > problem import mysql backup in Plesk

Posted by NSlapper, 03-20-2014, 05:12 AM
Hello i Have Plesk Windows version, when i want import my backup mysql, i see below error: and format of backup is file.bak , is correct? and my my.ini value is below: how i can resolve? Thanks.
Posted by NSlapper, 03-20-2014, 11:34 AM
any help????????
Posted by Avesta-Aria, 03-20-2014, 11:37 AM
What version of Plesk are you using ? What version of sql was the backup of your database taken from ? What is the version (exact) of mysql server on the new plesk server ? What is the size of your backup ? - Aria Last edited by Avesta-Aria; 03-20-2014 at 11:40 AM. Reason: nevermind sql or mysql, got it
Posted by NSlapper, 03-20-2014, 11:58 AM
1- Plesk 11.5 2- i dont know, but really is important? 3- MySQL connector V3.51.25 | Microsoft SQL server 2012 V 11.1.3000 4- 18MB
Posted by fabin, 03-20-2014, 05:30 PM
Try setting wait_timeout to 600 and max_allowed_packet is 64M. Max allowed packet is way too high. Such a high value is not needed.
Posted by NSlapper, 03-20-2014, 05:33 PM
ok, but is not my solution, i looking for solution.
Posted by Isaac Newton, 03-21-2014, 02:27 AM
Normally you get this error when your session times out. Had to tried to import backup once again after you got this error message?
Posted by NSlapper, 03-21-2014, 07:39 AM
Yes, i tested 50 time, but still same issue. (
Posted by Isaac Newton, 03-21-2014, 07:43 AM
How big the backup/dump file? I see its hitting the error at line 1 itself. May be you can open that file and see what its trying to do at Line 1.
Posted by NSlapper, 03-21-2014, 07:50 AM
it have 18MB size at line 1 i see: = TAPE Œ ‡ صçƒ , ^ xن‹ùM i c r o s o f t S Q L S e r v e r RAID ;¶>ؤًنقہF**ûf‏|·** ً SPAD & 4 =====
Posted by Isaac Newton, 03-21-2014, 07:55 AM
Are you trying to import an Microsoft SQL backup to MySQL?
Posted by NSlapper, 03-21-2014, 08:04 AM
hmmmm, Yes, that is different? have problem? Microsoft SQL backup is differen with MySQL ? can you help me how i can ?
Posted by Isaac Newton, 03-21-2014, 08:12 AM
My experience with MSSQL is limited, but have extensive experience with MySQL. There is a tool that I use called 'MySQL Workbench'. It is provided by MySQL themselves and it is a widely used tool to run queries and to export results. There is a migration wizard in this tool and you can use it to import the MSSQL database to MySQL. It should be seamless. Let me know if you come across any issues while using it. I don't think you can use the general 'mysql' command to import database from MSSQL.
Posted by Avesta-Aria, 03-21-2014, 08:18 AM
If its a MSSQL backup file, then you have no reasons to restore it to mysql. Do you have powerpack on your plesk installation ? If you do, then you can simply login to your plesk panel, navigate to the target host and restore the .bak file using the GUI of plesk panel itself, but to MSSQL database NOT mysql. If you do not have powerpack, you need to obtain the license for it in order to be able to use mssql as a function in your plesk installation and offer it to your clients. If you did all the above and still couldn't get it done, I would be interested in taking a look at your server personally and troubleshoot your plesk installation since during my 8 years experience with windows hosting using plesk and WSP, this is the first time I see such an error. - Aria
Posted by NSlapper, 03-21-2014, 08:53 AM
i underestand, thanks but there is any tools for convert MSsql to mysql? or i can install in Plesk 11 MSsql? Thanks.
Posted by Isaac Newton, 03-21-2014, 09:10 AM
Yes. Just use the Migration Wizard available with MySQL Workbench. You can download it from http://dev.mysql.com/downloads/tools/workbench/ .
Posted by Avesta-Aria, 03-21-2014, 09:14 AM
Not sure what you mean by converting the SQL, I would recommend against it if you don't necessarily need a mySQL functionality that doesn't exists in MSSQL. Yes, that's what I initially pointed out when I mentioned "you need to obtain a powerpack license in order to allow mssql functionality to your clients" - Aria
Posted by NSlapper, 03-21-2014, 03:53 PM
i found solotion, that is very very easy, that is not Hard 1- login to administrator server, then from top menu, server, then click on "Updates and Upgrades" and then click on "Add/Remove Components" and then you can select " MSSQL 2008 server " for install. Have Enjoy and like me

Add to Favourites Print this Article