SQL Newbie: .. How should this be corrected, thank you!?

Hello Everyone!

If anyone can help sort the following out; I'd appreciate it, .. thank you!

Sincerely,

*JstWc9~
........................................................................................................................................
Details:
* SQL Newbie, here. ... Lol :v
* Tried a couple of suggestions, but NO resolve.
* Basically, .. am trying to relocate a sql database from a server with older sql sftwr, to
one with more recent updates.
===
* Receiving Error on INSERT/UPDATE/REPLACE import, (fresh install no database)
* Sql file Exported Configs -
... Output: Character Set of the file: utf-8
... Format: SQL

... Format-specific options:
......... xxx--- Display comments (includes info such as export timestamp, PHP version, and server
version)
......... xxx--- Include a timestamp of when databases were created, last updated, and last checked
......... xxx--- Enclose export in a transactionDocumentation
......... xxx--- Disable foreign key checks
......... xxx--- Database system or older MySQL server to maximize output compatibility with: MSSQL

Dump Table:
... structure and data
... Object creation options
......... Add statements:
......... xxx--- Add CREATE PROCEDURE / FUNCTION / EVENT statement
.................. xxx--- CREATE TABLE options:
.................. xxx--- IF NOT EXISTS
.................. xxx--- AUTO_INCREMENT
......... xxx--- Enclose table and column names with backquotes (Protects column and table names
formed with special characters or keywords)

Data Dump Options
... Instead of INSERT statements, use:
......... xxx--- INSERT IGNORE statementsDocumentation

... Function to use when dumping data: INSERT

... Syntax to use when inserting data
... include column names in every INSERT statement
Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
... insert multiple rows in every INSERT statement
Example: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
......... xxx--- both of the above
Example: INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)

... Maximal length of created query 5000000000

......... xxx--- Dump binary columns in hexadecimal notation (for example, "abc" becomes 0x616263)
......... xxx---Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and
reloaded between servers in different time zones)
=======================================================================
NOTE - When attempting to import to another server, or re-import to same server; get the following
error message. ... (Utilized the export configs above.)
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Error

SQL query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
Error

SQL query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*
/*!40101 SET NAMES utf8 */;

--
-- Database: nameof_current_database
--
-- --------------------------------------------------------
--
-- Table structure for table jos_ak_profiles
--
-- Creation: Oct 08, 2013 at 11:42 AM
-- Last update: Oct 10, 2013 at 11:36 AM
--
CREATE TABLE IF NOT EXISTS "jos_ak_profiles"(
"id"int( 10 ) unsigned NOT NULL ,
"description"varchar( 255 ) NOT NULL ,
"configuration"longtext,
"filters"longtext,
PRIMARY KEY ( "id" )
) AUTO_INCREMENT =2;

MySQL said: Documentation
#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 '"jos_ak_profiles" (
"id" int(10) unsigned NOT NULL,
"description" varchar(25' at line 1
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
______________________________________________________________________________

 

I think you need to remove the quotes on everything, try:

CREATE TABLE IF NOT EXISTS jos_ak_profiles(
id int( 10 ) unsigned NOT NULL ,
description varchar( 255 ) NOT NULL ,
configuration longtext,
filters longtext,
PRIMARY KEY ( id )
) AUTO_INCREMENT =2;

Code (markup):

 

completely lost with your concern, can you rewrite this cleanly and briefly