|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
MySQL question
A question regarding MySQL dB move before I take the leap..
I have two dB's, one old, one new, I need to move the info from 2 tables in the first (old) dB into the 2nd (new) dB. It's an Album dB that has Catagories and photos listed under each Catagory. I'm doing this via phpMyAdmin. If my thinkng is correct (hold all jokes on that comment) I have the table structure already created in the new dB, same naming convention. Does this sound correct ?? |
|
#2
|
|||
|
|||
|
SOLVED RE: MySQL question
OK, I figured it out. My initial problem was the way I was exporting the data. I extracted just the "data: and got
:: INSERT INTO php_album_cat VALUES (1, 'Family Photos 2000 and earlier', 'General family photos', :: tables (didn't need the data and structure) and inserted the data values into the new dB and then moved the directories over to the new directory on the server to show the photos. Pretty easy with phpMyAdmin actually.... Yes I just patted myself on the back |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MySQL question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|