Hello, If someone could please help me figure out how to fix an issue I am having in PhpMyAdmin it would be much appreciated. I created a database and am trying to import a .bak file up into the database, when I try to do so I get the message listed below which is a little over my head. Can anyone help me out please? There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNrtTjtOw0AQHRPSbEHBBZgipb3yOvEnS2UFK1iyE8drgkQBIuCAJeMYO0HQUCHRcBVKjsEFOA1r 00CHRMto3rzRm9HM8+J4GnMcMRwZGHgTjgM0cWDbRCRSB0LEXIo9/5JjfZuX51WdVjTPFrS8LpEx k/XR0HVHk2k4yCzObG72TzBPb4bYI+GDmAUcTapTy9by1RU5EjFOhYru2JskKs49+eY4K9D30KY6 iUKXo0EZo0PKSHQYNRvqVDQ3DGphkBWbexK4kzHHtNA266XmkPZH4kYeQAdeYEeBX8QWPHffX88e u7JXWnR+zFU4BdiG3b3Fx9uTEkIGF1DBCmqJJawBQcAMgpZTOblr61fErn/QMH67t/9v8K8GPwHY 6GS4 ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 4 5 477 STR: SVN: $Id: sqlparser.lib.php 11513 2008-08-28 16:17:53Z lem9 $ MySQL: 5.0.67-log USR OS, AGENT, VER: Win IE 7.0 PMA: 2.11.9.1 PHP VER,OS: 5.2.6 Linux LANG: en-utf-8 SQL: TAPE��Í_~,^ bڵ�Microsoft SQL ServerRAID ;TAPE��Í_~,^ bڵ�Microsoft SQL ServerRAID ;TAPE��Í_~,^ bڵ�Microsoft SQL ServerRAID ;----END RAW---- SQL query: TAPE��Í_~,^ bڵ�Microsoft SQL ServerRAID ; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TAPE' at line 1
True - have a look at the data you're trying to import (have you created your MySQL tables already?) then standardise the SQL. Or you could just remove all the SQL from the file and cust have a CSV file with your data in it - you could then use the MySQL LOAD command to import the data Good luck!
Thank you for everyone’s help, I took a second look at the file and did find it to be a MSSQL file which I had overlooked earlier, how can I go about "standardizing" this file so that I can upload it into MySQL, or is there a MS Database Server I can use instead? The reason for all of this is that I am in the process of transferring over my website from a Server Hosting Company over to my own server on Dreamhost / PhpMyadmin, they sent me all the files for the website and the database on a CD which is where the MSSQL.bak file is from that I am trying to load. My question is if I convert this file in anyway will I loose any compatibility / ties that has already been established between the website and the database?