PDA

View Full Version : dowloading info from one db table


Night Owl
11-20-2002, 10:39 AM
I need to take one database table nuke_seccont, from my test board and transfer it to my live board, as I messed up that table (and a few others) on the live board.

I need step-by-step instructions on how to backup the one table and then upload it to the live board, without destroying anything (again...)

I do not have shell access, just phpmyadmin and ftp.

Thank you!

N!ck
11-20-2002, 01:03 PM
assuming you have the latest (or close to it) version of phpmyadmin, do the following:

go into phpmyadmin and click the name of your database
click on the "Export" tab
click on the name of the table in the select list
click the radio box next to "Structure and Data"
check the checkbox next to "Save As File"
click the "Go" button and save the file
open phpmyadmin in your new location
click the database name
click the "SQL" tab
click "Browse" and choose the location of the file
click "Open"
click "Go"


that should do it