Skip navigation links

MySQL Forums :: Microsoft Access :: import: from MySQL Workbanch to phpMyAdmin


Advanced Search

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 2235 andrea feduzzi 08/31/2011 08:26AM
Re: import: from MySQL Workbanch to phpMyAdmin 1075 jack albente 09/01/2011 10:11AM


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.