[Ron Wolpa]

Quote:

(in order to test if it has been actually created I´ve tried to create a db with same title but I´ve got error 1044 which I suppose to be an already existing db with same title)

I suppose the db has been created succesfully , don´t know what error 1044 means ;

I´ve seeked for “show databases” but haven´t found it (??);

I wil try to change engine by type and see what happens , than you very much

[Ron Wolpa]

Just to describe you guys my status , let me tell you my whole story :

I am having a hard time , it is about a couple of months that I´ve been picking my brain and am not succesfull at importing a very simple database created on phpmyadmin ; it is a test db with two small tables just for learning ;

I´ve tried first to import db by means phpmyadmin , I´ve configured it , but cannot connect the ISP DB for some reason ; then ISP administer recommended me mysql front , this time connected isp db but occurred error messages during the importing process ; finally sql yog , I´ve tried to import the mysql dump and got an error

…………….

Query:

CREATE TABLE `table_001` (

`a1` varchar(25) NOT NULL default '',

`a2` varchar(25) NOT NULL default '',

`a3` varchar(25) NOT NULL default '',

`a4` varchar(25) NOT NULL default '',

PRIMARY KEY (`a1`)

) ENGINE=MyISAM

Line no.:7

Error Code: 1064 – You have an error in your SQL syntax near 'ENGINE=MyISAM ' at line 7

Query:

CREATE TABLE `table_001` (

`a1` varchar(25) NOT NULL default '',

`a2` varchar(25) NOT NULL default '',

`a3` varchar(25) NOT NULL default '',

`a4` varchar(25) NOT NULL default '',

PRIMARY KEY (`a1`)

) ENGINE=MyISAM

Line no.:7

Error Code: 1064 – You have an error in your SQL syntax near 'ENGINE=MyISAM ' at line 7

Query:

CREATE TABLE `table_001` (

`a1` varchar(25) NOT NULL default '',

`a2` varchar(25) NOT NULL default '',

`a3` varchar(25) NOT NULL default '',

`a4` varchar(25) NOT NULL default ''

) ENGINE=MyISAM

Line no.:6

Error Code: 1064 – You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 6

………….

As I could not import that already existing on my local disc DB , I made up my mind to create it with sqlyog what I did ; if I connect to test_69005 on my local host , I can see the two tables , but the same does not occurr as I connect to DB ISP ;

I´ve refreshed it ( F 9 ? ? ) , ´have not found show databases as Ritesh suggested me, and don´t have idea what do next ;

In the tree I can see the server address , eg. [email protected] and below the db created by ISP adm. , ronwolpa_cons ;

Can someone help me out ,. please ?

Cheers

[Author]

Posts