SMBadmin Posted April 23, 2007 Share Posted April 23, 2007 I am using version 4.0 and have accidentally dropped a table from my database. Unfortunately, it contained the entire user list for my phpbb board and now the darn thing is down for the count. I have tried reading the tutorials but didn't get very far as my knowledge of databases is very slim - hence the reason I could just delete a whole darn table accidentally! So I was hoping someone was willing to either give me some basic instructions on how to put the thing back in or point me toward a tutorial that addresses this specific situation (I do have a recent backup of my board, but it's just one big file, so I'm not sure how to isolate just that one table). Thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/48315-how-to-restore-a-dropped-table/ Share on other sites More sharing options...
Wildbug Posted April 23, 2007 Share Posted April 23, 2007 Open the file, find the part that pertains to your user table (table definition and values), save it in another file, and feed that file to MySQL: mysql db_name -u username -p < saved_table_file Quote Link to comment https://forums.phpfreaks.com/topic/48315-how-to-restore-a-dropped-table/#findComment-236229 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.