Error No 1016

ProdukteKontoeinstellungenMeine VerlängerungenAbmeldenAnmeldenMenüHilfeSystemstatusZurück|Start Gesamte WebsiteHilfeWebhosting und StandardhostingWebhosting und Standardhosting HilfeWhy do I get a MySQL "error: 1016 Can't open file: ..."?Errors such as: ..."Got error: 1016: Can't open file: 'YOUR_TABLE_NAME.MYI'. (error:145) when using LOCK TABLES"... (as well as numerous other noted below) are caused by MySQL table corruption. Table corruption can be caused by a variety of events, and will make some or all of a table unavailable. Table corruption can also significantly decrease the performance of queries on effected tables. Table corruption can be be repaired by using the the REPAIR TABLE command. For more information about the REPAIR TABLE command see: MySQL 4.0, 4.1 http://dev.mysql.com/doc/refman/4.1/en/repair-table.html MySQL5.0 http://dev.mysql.com/doc/refman/5.0/en/repair-table.html Run REPAIR TABLE on an affected table Enter phpMyAdmin for the database you want to use. For more information, see Log in to phpMyAdmin. Click on the table name of the affected table. If phpMyAdmin is unable to display the table information, or encounters errors loading the table details page, another option would be to use the SQL button at the top of the left frame to enter your own query. You can repair the table manually by issuing the command REPAIR TABLE in this SQL window. Click on the Operations tab at the top of the right panel. Click Repair table at the bottom of the right panel. This command can take some time and will block some queries, such as inserts, to the table. WARNING:It is possible that the phpMyAdmin Web server will time out waiting for a response from this command. If this happens, do not issue it again. Use the processlist feature, and you'll likely see the REPAIR command still running. Wait for it to complete. On large tables, this can take hours. Some other errors that may be caused by table corruption include: Can't find file table.MYI. Duplicate unique key or constraint on write or update. Got error ERR from table handler. (ERR being a number). Index file is crashed / Wrong file format. No more room in index file.

Home Forum vBulletin Legacy Versions & Products Legacy vBulletin Versions vBulletin 3.0 How Do I and Troubleshooting Forum Join us on Facebook, Twitter and YouTube. This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're https://www.godaddy.com/help/why-do-i-get-a-mysql-error-1016-cant-open-file-5116 planning to use. We are sorry for any inconvenience this may cause. Welcome to the vBulletin support forums! In the forums you can receive professional support and assistance with any issues you might have with your vBulletin Products. If you are having problems posting in the relevant areas for your software, please see this topic. Announcement Collapse No http://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-3-0-how-do-i-and-troubleshooting-forum/101904-mysql-error-number-1016-can-t-open-file-user-myi announcement yet. mysql error number: 1016; Can't open file: 'user.MYI' Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts Previous Next Phillip Chapman Senior Member Join Date: Jul 2001 Posts: 103 #1 mysql error number: 1016; Can't open file: 'user.MYI' Fri 26th Mar '04, 6:04pm Our server temporarily reached full capacity on the hard drive. It's now down by 50% after the Apache logs were deleted. However, we are getting the following vBulletin error. Please provide step-by-step instructions on how to get the forum up and running again.