> My ISP provides me with a MySQL database. I have installed MyODBC and MySQL
> on my Windows2000 machine. Can you tell me if its possible to replicate the
> database to my own computer, make changes and these be replicated back to
> the database hosted by my ISP ?
You will have to do it manually, I guess. This is how I do it: If
it is a one time operation, I use mysqldump, i.e. in Win it is
\path_to_mysqlbin\mysqldump \path_to_datadir\db_name > \your_path\update.sql
on the local machine, I upload the sql file via ftp, then feed it
into mysql like this
/path_to_mysqlbin/mysql -hlocalhost -uuser_name -p
/path_to_datadir/db_name < /your_path/update.sql
If I have a large db and little changes, this would be
overkill. What I do is get a dump from the table I changed with
phpMyAdmin (just a click), copy the row(s) added to an instance
of phpMyAdmin pointing to my web site to a new file (a snap with
my editor), paste it to the sql textarea and click the go button.
If it is more than a few records, this is not feasible either, so
I upload that file via ftp and feed it like above into mysql.
If somebody knows an easier way, I'd be glad to learn.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
