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! 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 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
Archived
This topic is now archived and is closed to further replies.