Results 1 to 6 of 6
  1. #1

    MDB2 Error: database error

    An error has occurred

    Error when executing: MDB2 Error: no such table

    _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM accounts] [Native code: 1146] [Native message: Table 'abcd.accounts' doesn't exist]
    using linux centos and have only ssh access.

    how to check that database is sucessfully imported or what is the above error. i can't resolve it.

  2. #2
    Join Date
    Sep 2007


    Please check this on ssh

    1. type command and press enter and provide correct username and password

    mysql -u username -p

    2. check database

    use database; [where database is your desire database name]

    3. show tables; [you will see list of all tables which are part of that database.

    4. type -> exit and press enter key to logout from mysql.

  3. #3
    Join Date
    Jun 2003
    World Wide Web
    This type of error occurs even though the mentioned table exist . If you still have issues please provide us with more details . What exactly are you doing to get to the problem . Any softwares that you are trying to install? - the name says it all!
    Managed Cloud Servers
    Server Management and Monitoring
    24x7 outsourced customer support

  4. #4
    When i type

    the use command

    it says" Database changed"

    and show tables give me

    "Empty set (0.00 sec)"

    This mean it have no table inserted or what ?

  5. #5
    Join Date
    Apr 2005
    Quote Originally Posted by nura235 View Post
    This mean it have no table inserted or what ?
    yes , it means two things

    1. That you have not created a table
    2. You have not copied your tables files in mysql recognized format , probably due to import issues. This usually happens when you simply copy the files over to a new mysql host or due to permissions issues
    Sam - Expertise in Windows/Linux server support, IaaS and PaaS Management - Custom Software Development
    Email: exec @ | Skype: unni_active

  6. #6
    Join Date
    Sep 2007

Similar Threads

  1. Database error
    By racked_solutions in forum WHT Announcements, Feedback and Questions
    Replies: 9
    Last Post: 03-26-2009, 06:09 PM
  2. MySQL Error : Got error -1 from storage engine Error Number : 1030
    By Linkdatacenter in forum Programming Discussion
    Replies: 2
    Last Post: 05-25-2008, 04:16 AM
  3. Database Error?
    By Kerry Jones in forum WHT Announcements, Feedback and Questions
    Replies: 2
    Last Post: 02-10-2005, 07:28 PM
  4. HELP! XMB Error Database No Database Selected!
    By dallassmith in forum Reseller Hosting
    Replies: 1
    Last Post: 08-20-2002, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts