Re: Import issues again...

Will do, but then you will have to recommend me the right web software, because it looks like my http://mysqldumper.net does have that option... a step by step guide through will be really nice! Best regards Hans

On Monday, October 7, 2013 11:01:08 PM UTC+2, Amit Mondal wrote:

Could you please use the following for generating the dump?

mysqldump --databases database_name [-u username -p password] --hex-blob > database_file.sql

On Mon, Oct 7, 2013 at 1:30 PM, Hans Simtanda Caspersen <ad...@simtanda.com> wrote:

Hi, im a the following error when  try to import an sql file...

EFailed to import gs://abcategories-com/sql-dumps/by-hand/book/authorbooksdata_2013_10_07_17_04_part_1.sql: mysql_query 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 'USE abc' at line 1 (USE abc) An unknown problem occurred (ERROR_RDBMS)

I am using the USE statement correctly at the top of my sql file plus i do have a database called "abc", with tables etc. in it from successful imports. 

My instance ID is "abcategories-com:authorbooksdatabase.com" and my database name is "abc".

The beginning of my sql file looks like this:

---------------------------------------------------

USE abc; 

-- Status:1:8288277:MP_1:authorbooksdata:php:1.24.4::5.1.66-0+squeeze1:1:::utf8:EXTINFO

--

-- TABLE-INFO

-- TABLE|book|8288277|4122800696|2013-10-05 13:58:47|MyISAM

-- EOF TABLE-INFO

--

-- Dump by MySQLDumper 1.24.4 (http://mysqldumper.net)

/*!40101 SET NAMES 'utf8' */;

SET FOREIGN_KEY_CHECKS=0;

-- Dump created: 2013-10-07 17:04

--

-- Create Table `book`

--

DROP TABLE IF EXISTS `book`;

CREATE TABLE `book` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` text NOT NULL,

  `author` varchar(255) NOT NULL,

  `author_bio` text NOT NULL,

  `authors` varchar(255) NOT NULL,

  `title_slug` varchar(255) NOT NULL,

  `author_slug` varchar(255) NOT NULL,

  `isbn13` varchar(255) NOT NULL,

  `isbn10` varchar(255) NOT NULL,

  `physical` varchar(255) NOT NULL,

  `publisher` varchar(255) NOT NULL,

  `pubdate` varchar(255) NOT NULL,

  `edition` varchar(255) NOT NULL,

  `synopsis` text NOT NULL,

  `toc` text NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `isbn13` (`isbn13`),

  UNIQUE KEY `isbn10` (`isbn10`),

  KEY `title_slug` (`title_slug`),

  KEY `author_slug` (`author_slug`)

) ENGINE=MyISAM AUTO_INCREMENT=12772622 DEFAULT CHARSET=utf8;

--

-- Data for Table `book`

--

/*!40000 ALTER TABLE `book` DISABLE KEYS */;

INSERT INTO `book` (`id`,`title`,`author`,`author_bio`,`authors`,`title_slug`,`author_slug`,`isbn13`,`isbn10`,`physical`,`publisher`,`pubdate`,`edition`,`synopsis`,`toc`) VALUES ('1','Opening Spaces: An Anthology of Contemporary African Women\'s Writing','Yvonne Vera','<p><P>EDITOR<p>Yvonne Vera was born and raised in Bulawayo, Zimbabwe, gained her Ph.D. from York University in Canada, and was the Director of the National Gallery of Zimbabwe in Bulawayo. Yvonne Vera died at age 40 in 2005<p>Yvonne Vera&rsquo;s Without a Name and Under the Tongue both won first prize in the Zimbabwe Publishers Literary Awards of 1995 and 1997 respectively. Under the Tongue won the 1997 Commonwealth Writers Prize (Africa Region). Yvonne Vera won the Swedish literary award The Voice of Africa 1999.</p>...

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/44e6bff7-1474-4713-b65b-f611f8199c0a%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/093182d2-3956-4696-9de3-55f82cc03b52%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.