PDA

View Full Version : Database Tables uploading/downloading


gsh
2-15-04, 01:31 PM
I want to download and or upload table with data.
Can I do this with PHPMyAdmin
and if so, how. I want to be able to populate the tables on
my home pc, for its just much faster, then upload the table.
I also want to download some tables with their data to just
save them as back up on my own CD's.
Any and all help appreciated, and please be detailed with specifics on how to do so.
Thanks.
Steve

mjp
2-15-04, 03:13 PM
Click the "Export" link/tab in phpMyadmin to download data.

If you are backing up, you'll want to select the "Structure and data" option. If you are changing/adding data you don't need to download the table structure, so you would chose "Data only."

Check the "Complete inserts" and "Save as file" boxes, and hit the "Go" button. That will download a file to your machine with an .sql extension that you can open in a text editor.

gsh
2-15-04, 03:21 PM
Thanks for your reply.
Also, If I create the table on my pc with a structure, and up load it with the structure it will be in place then?
From my pc do I need to load the PHPmyAdmin inorder to upload the table?
Thanks
Steve

hos
2-15-04, 06:08 PM
you upload it with phpadmin on you're server. there you can choose the file you want to upload from you're pc ;)

see the import function in phpmyadmin