November 29th, 2004, 12:35 PM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Database Query
Hi 
I run an auction site under URL and I running forums under URL they are currently under two different databases.
I am trying to get the to share the 1 database but have followed these steps:
Part A: Exporting a Database
Code:
1. Log-in to phpMyAdmin. (It can be accessed from Your CPannel>MySQL Databases>phpMyAdmin)
2. Click on your old database you want to export, then wait for the right frame to load.
3. Click on the EXPORT tab at the top of the right frame.
4. Select Data & Structure, hit Select All (For whole database), check Save as File, then hit GO!
Part B: Importing a Database
1. Log-in to phpMyAdmin. (It can be accessed from Your CPannel>MySQL Databases>phpMyAdmin)
2. Click on the new database, that you want to import your old one into.
3. Click the SQL tab at the top of the right frame.
4. At the bottom, it'll say "Or Location of the textfile". Hit browse, and select the file you exported.
5. Hit GO, and wait for everything to upload.
it didnt work, and I spoke to the person who wrote that and they said "It IS possible to do what you're doing, but it's not as easy as joining the databases. my hope would be to ask a PHP coder
Any help at the moment is greatly appreciated!
Thanks, Mark
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
