sjb
|
| Posted: 04/06/2002, 2:51 AM |
|
Hi
I want to connect remote database from My PC to server of my site & I want to synchronize between DB on my Pc and another on server
How to ????????
thanks
|
|
|
 |
sjb
|
| Posted: 04/06/2002, 3:11 AM |
|
sorry
I'm using php and mysql
|
|
|
|
catalyse
|
| Posted: 04/06/2002, 12:45 PM |
|
It depends if you really mean synchronize (as in automatically mirror on a regular basis) or just copy it periodically? If you mean "copy" because you do development and testing on your PC and want to copy the database to the live server, the way I do it is with phpMyAdmin (assuming your live server provider has it installed and they almost certainly will).
First run it on you PC and do a "View dump" to a file (with "Structure & Data" and "add Drop table"), then run the version on your server and select the "Run SQL query" using Browse to upload the saved SQL dump. This will recreate all the required tables and insert the data as per your PC.
If you mean a proper sync, good luck and let me know when you manage!
Neil.
|
|
|
|
|
