Unable To See A Db Created On Server , Why?

[Ron Wolpa]

I´ve created a db entitled test_692005 (cntl + D) on my ISP Mysql server but I cannot see it ;

(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 have test_69005 db as well on my local disc and can see the db and its tables on the object browser ;

My question is what is going wrong with ISP db ?

[Ritesh]

Does executing show databases list your database?

[peterlaursen]

Did you click the refresh-icon. (the recycler-symbol) ?

[vygi]

peterlaursen wrote on Oct 13 2005, 06:11 AM:

Did you click the refresh-icon. (the recycler-symbol) ?

[post=”7550″]<{POST_SNAPBACK}>[/post]

Additional note: SQLyog refreshes only the selected “subtree” of the object browser.

That means, you must click on the server and then refresh. It will not work if you eg. are pointing on some other database. The new one will not appear.

BTW I also got confused several times.

Does SQLyou not (or not always) refresh their lists after creating a new object????

<_<

[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

[Ritesh]

Which version of MySQL are you running at the remote server?

With v4.1 and above, a table type is called Engine. Prior to that, it was called Type. Thus with an old MySQL server, the following query will fail:

create table (….) Engine = MyISAM

but this will work:

create table (….) Type = MyISAM

Just open the sql file in a text editor and replace all Engine to Type and everything will work.

As for the database not visible issue, are you sure that the database exists? You can find out by executing show databases. Do you see your database?

[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

[peterlaursen]

Quote:

but I´ve got error 1044 which I suppose to be an already existing db with same title)

Wrong!

MySQL error messages:

http://dev.mysql.com/doc/refman/5.0/en/error-handling.html

Error: 1044 : Access denied for user '%s'@'%s' to database '%s'

Does the user have the CREATE privilege for instance ?

[Author]

Posts