#3485 Table and data is not visible when created via MySQL WB

3.4.7
invalid
nobody
5
2013-06-11
2011-11-30
Anonymous
No

The table was created, and data inserted via MySQL Workbench v.5.2.35. I see everything perfectly doing SELECT * FROM db.table. The same is true when working directly from mysql console on the server (v.5.1.52).

However, I can not see the table in the table list, and can not do a select from this table using phpMyAdmin (latest at the moment of posting this, 3.4.7.1). #1146 - Table 'db.table doesn't exist. This is true for any user, including root.

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-11-30

    Some additional info:

    When the table structure is created with phpMyAdmin, I see it in all 3 cases (phpMyAdmin, MySQL WB, console).
    The data inserted with phpMyAdmin is visible everywhere.
    The data inserted with MySQL Workbench is visible only in console and MySQL Workbench.

     
  • Marc Delisle

    Marc Delisle - 2011-11-30

    This is difficult to believe. Did you try refreshing your phpMyAdmin Browse page afterwards?

    I have seen other situations, for example another web application creating tables and populating them; everything was visible via phpMyAdmin after.

    Maybe it's a case of using two different servers (one in phpMyAdmin, one in WB), and one of them partially replicating to the other one?

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-11-30

    Sounds strange, I know.

    You are right, it is a master-slave cluster, however everything described in the ticket is done on the master.

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-11-30

    Wrong DNS record, master-slave were mixed. Thank you for giving a good idea.

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-11-30
    • status: open --> closed-invalid
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-invalid --> invalid
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks