I have a mysql adatabase on my local machin and want to have same database on internet in other word i want always update my tables on internet by my tables that is on my local machine
if you go to the mysql admin section(phpMyadmin) , you can use the function export or save files or dump tables etc. choose only data and the tables you wish to upgrade and you get the code you have to run on your server a bunch of insert into commands normally
hope my explanation is clear
dear Psycho Mossel: my mean is my program work in local machin alldaylong and work with many data in a table at end i want to move this table to internet.
Im Talking About replication technic please help me
Well you could also write a synchronizing script in PHP.
when moving I basically do a dump
mysqldump DB_name>dumpfile.sql
then I upload the file dubmfile.sql to the host (empty the curretn db) and then do:
mysql DB_in_host_name < dumpfile.sql
dear anam i dont access to my host i want update my table automatically from local to my host with a script can you help me????????
You do not have access to your host ... ?
I would write a PHP script that connects to your local machine (If your ISP uses DHCP, you can use a dynamic domain name) and the fetch all the information and put it in the database on the server. If you are able, you can make a cronjob for this so the php script is parsed every day for example (so that the database is updated every day) maybe there are better non-php ways to do this but they will probably be useless for you if you don't have shell access to your host
