MySQL Forums
Forum List  »  Microsoft Access

import: from MySQL Workbanch to phpMyAdmin
Posted by: andrea feduzzi
Date: August 31, 2011 08:26AM

I've export same table, from phpMyAdmin, in .sql file.
Then I've imported that table in MYSQL Workbench and everything work fine.
Now, I try, without to modify nothing, to export the tables in .sql and import again in phpMyAdmin and I receive back an error below.

Why?

I need to import to phpMyAdmin many manypulated tables.... what can I do?



Query SQL:

-- ----------------------------------------------------- -- Table `mydb`.`jos_categories` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`jos_categories` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `asset_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.' , `parent_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `lft` INT(11) NOT NULL DEFAULT '0' , `rgt` INT(11) NOT NULL DEFAULT '0' , `level` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `path` VARCHAR(255) NOT NULL DEFAULT '' , `extension` VARCHAR(50) NOT NULL DEFAULT '' , `title` VARCHAR(255) NOT NULL , `alias` VARCHAR(255) NOT NULL DEFAULT '' , `note` VARCHAR(255) NOT NULL DEFAULT '' , `description` VARCHAR(5120) NOT NULL DEFAULT '' , `published` TINYINT(1) NOT NULL DEFAULT '0' , `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0' , `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `access` TINYINT(3) UNSIGNED NOT NULL DE[...]

Message MySQL:

#1067 - Invalid default value for 'checked_out_time'

Options: ReplyQuote


Subject
Views
Written By
Posted
import: from MySQL Workbanch to phpMyAdmin
4663
August 31, 2011 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.