Bain Posted January 25, 2002 Share Posted January 25, 2002 Hey you all, I really need to know how to back up and restore one table in a database through PHPMyAdmin. If anyone know's how to do this through PHPMyAdmin please contact me on either MSN at dabain24@msn.com or VIA E-Mail bain@synergypaintball.com Thanks, much appreciated! Link to comment Share on other sites More sharing options...
0 PM5K Posted January 25, 2002 Share Posted January 25, 2002 Why would you want to backup and restore only one table ? I could understand restoring one table, but backup and restore ? Link to comment Share on other sites More sharing options...
0 Bain Posted January 25, 2002 Author Share Posted January 25, 2002 Backup certain tables before applying a vBulletin hack that will potentially cause problems to that table being edited. Restoring tables that have been edited because of a vBulletin hack and didn't go right so now I need to restore. Link to comment Share on other sites More sharing options...
0 gregor Posted January 25, 2002 Share Posted January 25, 2002 1. download newest version of phpmyadmin 2. use "dump" function and select table you want to backup (with or without the text in it).. it's your decision. copy and paste the dumped sql query code in an text file such as sql.txt 3. to restore the table, click the browse button under the "sql query textbox" and click ok, that's it Link to comment Share on other sites More sharing options...
0 Bain Posted January 25, 2002 Author Share Posted January 25, 2002 Thanks Gregor! :) Link to comment Share on other sites More sharing options...
0 gregor Posted January 25, 2002 Share Posted January 25, 2002 no problem :p Link to comment Share on other sites More sharing options...
Question
Bain
Hey you all,
I really need to know how to back up and restore one table in a database through PHPMyAdmin. If anyone know's how to do this through PHPMyAdmin please contact me on either MSN at dabain24@msn.com or VIA E-Mail bain@synergypaintball.com
Thanks, much appreciated!
Link to comment
Share on other sites
5 answers to this question
Recommended Posts