Importing/Exporting SQL

Okay, finding it hard to transfer the sql to a client...

here are my options



Please tell me the options I should choose and once its done..and we import it on another server...what options should i choose from the below




THIS IS URGENT...PLEASE HELP

 

First image, I'd keep everything the same but also check " Save as file " and " zipped " and click Go.

Second image, browse for the zip file and click Go.

 

so nothing to select from the above options...because when we upload it on a different server...it gives the following error

Erreur
requête SQL:

--
-- Database: `database NAME`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_comments`
--
CREATE TABLE `wp_comments` (

`comment_ID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`comment_post_ID` int( 11 ) NOT NULL default '0',
`comment_author` tinytext NOT NULL ,
`comment_author_email` varchar( 100 ) NOT NULL def


We dont need to create a new data base the import it...right?

 

Try checking the box for " Add IF NOT EXISTS " under Structure.

I just did this earlier actually for a site I bought from someone.

I can do it for you if you want to give me the un/pwd info and I'll charge $5 .

 

You must have to create database before importing data into it if you CREATE DATABASE command does not exit in your SQL.

Let me know if you want me to do it for you.