» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2006, 05:26 AM
Vglobe Vglobe is offline
Junior Member
 
Join Date: Oct 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Vglobe is on a distinguished road
Default MySQL Error Nr.1051-Unknown table 'my_table?

My MySQL server is hosted by brinkster.com and butlooking in my tables in the QB, I found "Could not fetch columns" under all of my tables except for my MyISAM tables. When I use the MySQL command line utility and "show tables", I see my tables, but when I try to select, "SELECT * FROM My_Table", I get "ERROR 1146 (42S02): Table 'MyDatabase.My_Table' doesn't exist". I should restore my database from a backup. They have no explanation as to what happened.
Using MySQL Administrator, I tried restoring a table I had saved and got an error, "The MySQL Server returned this Error:
MySQL Error Nr.1051-Unknown table 'my_table'". how to proceed? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 10-26-2006, 05:29 AM
gilbert gilbert is offline
Senior Member
 
Join Date: Dec 2005
Posts: 110
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 22
gilbert is on a distinguished road
Default

You could tell the hosting provider for the mysqld error log. InnoDB prints diagnostic information there. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to add posts to a phpbb table after moving servers. tanny MySQL Forums 3 02-13-2007 03:44 PM
MySQL failing? Blinck MySQL Forums 1 01-04-2007 07:08 AM
storing hexadecimal data into mysql table??? wlinkon MySQL Forums 2 11-25-2006 05:05 AM
Getting MySQL & PHP to communicate JCH MySQL Forums 0 05-29-2006 02:52 PM
MySQL 5.1.3-alpha has been released gunet MySQL Forums 0 12-09-2005 04:55 AM


All times are GMT. The time now is 04:40 AM.