Error
consulta SQL:
-- ToWebs MySQL dumper 10.243
--
-- Host: localhost Database: uv0060_jos
------------------------------------------------------- --
-- Server version 4.1.14-log
--
-- Table structure for table 'customer'
--
CREATE TABLE customer(
First_Namechar( 50 ) default NULL ,
Last_Namechar( 50 ) default NULL ,
Addresschar( 50 ) default NULL ,
Citychar( 50 ) default NULL ,
Countrychar( 25 ) default NULL ,
Birth_Date date default NULL
) TYPE = MYISAM ;
MySQL ha dicho:
#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 '---------------------------------------------------------
-- Server version 4.1.' at line 4
Intente hacerlo mediante comandos My Sql asi:
mysqldump -u sourceDbUser -pPassword sourceDbName > db.dmp
pero me sale el siguiente error
#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 'mysqldump -u ambliopi_usuario -p02454140 ambliopi_jos > uv0060_jos.sql' at line 1
el archivo.sql comienza asi:
-- ToWebs MySQL dumper 10.243
--
-- Host: localhost Database: uv0060_jos
---------------------------------------------------------
-- Server version 4.1.14-log
--
-- Table structure for table 'customer'
--
CREATE TABLE customer (
First_Name char(50) default NULL,
Last_Name char(50) default NULL,
Address char(50) default NULL,
City char(50) default NULL,
Country char(25) default NULL,
Birth_Date date default NULL
) TYPE=MyISAM;
--
-- Dumping data for table 'customer'
--
-- Table structure for table 'jos_acfilepayments_currencies'
--
CREATE TABLE jos_acfilepayments_currencies (
code varchar(3) NOT NULL default '',
name varchar(255) NOT NULL default '',
symbol varchar(255) NOT NULL default '',
rate varchar(255) NOT NULL default '',
last_check date NOT NULL default '0000-00-00',
PRIMARY KEY (code)
) TYPE=MyISAM;
Alguien me podria decir que estare haciendo mal?