Re: regularly mysql db web update ?

I can't use daemon on providers server, I don't know any programming language other than PHP and littlebit of JavaScript. Ok stop crying, I think I can do something like this: ON LOCAL MACHINE: 1) running PHP Script in browser window with refresh time made in JavaScript 2) this script will create dumpfile from local MySQL database and save this file to local drive 3) after creation of dumpfile this script will redirect to PHP script on our web server ON WEB SERVER: 1) this script will execute query with that dumpfile from local hard drive (same as PHPMyAdmin do) 2) return back to local "refreshable" script running on local machine An the circle is finished.... Very ugly but should it work... problem is: 1) I don't know how to create and save dump file from MySQL using PHP 2) I don't know how PHPMyAdmin is doing that "dumping" and file handling Can anyone help me with this? I think that more people not just me must have very similar problems with updating their databases on their web servers... how they do that???!!! Thanks a lot Vojtech > Hi, > > If the hosting company allow you to place a daemon on bkground > that will be a solution. But your situation even worse - you cannot > access shell. However you can still have an alternative solution: > > 1. On your local side you setup a regular ftp to send the updating > file to the remote host on a certain time interval. > > 2. Also on your local side you can setup a regular web page > acccessing-bot, this bot will access a certain page. You can use > Visual C to write one, but i think there will be easier solution > for regular accessing a certain web page. This page-loading will > activate a php script to handle the mysql database updadting with > the updating file. > > Hope this can be a solution for you. > > Alex > > > Hi, > > I came to one very specific problem... > > we are paying for domain and web space on server with MySQL and PHP. > > For administering MySQL database we can use PHP scripts only (no telnet > nor > > SSH). > > We have intercompany MySQL database on our Intranet that is connected to > > Internet through Proxi/Firewall. This allows only Internet browsing (port > > 80). > > And now comes my problem... How we can regularly update MySQL database on > > our web server from our intercompany DB , lets say every hour? > > What we do now, someone must make dump file from our database and than use > > PHPMyAdmin on our web site to upload data into MySql database on our web > > site. > > This is very uncomfortable (worst than that on our slow connection to > > internet). > > > > Please help. > > Thanks > > Vojtech > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >