Remote Database Updating
I am working on an internet enabled sensor device project. I have a small microcontroller device that is connected to a sensor device. I want this device to dial the ISP and post its readings each day. I would like to know if anyone might have any suggestions on how this could be done.
Once the unit logs onto the server how might I code it to access the data area and post its reading. Also can this even be done. I mean does the microcontroller have to have a special database driver to access the remote database?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Updating And Then Restoring Backup From Remote Server
I have backed up a mysql db on a remote server (PHPBB) and want to delete some entries from it and then restore it. The file is .sql. what is the best way to do this - i am a bit lost - there is some strange bug happening on the message board and i think this is the only way to correct it for now.
Updating Database
I'm fairly new to mySQL and php and seeking some input. I created a database to hold a member directory. It is a single table. The client uses some contact management software we're they keep track of their members. Therefore, the client does not want to enter the information through a form on the website. Instead the client wants to export a comma delimited file from the program and then use that exported file to update the database. What would be the best approach to do this??? MySQL's LOAD DATA works fine as long as the original data does not change. If a member is removed or a primary key is changed, new rows are added but the old ones (that should of been updated) remain. I figured whenever the client goes to update the db, a script deletes all data from the db, then imports the text file. This doesn't seem like a very efficient approach to me though. Maybe importing the data into a temporary table and then comparing it to the actual table would work, though I am not sure how to go about doing this.
Updating A Database
I am able to create my database and populate it manually, but I want a web page that is tied to the database for updating fields. For example, I have a database that has an inventory of golf balls and with a starting inventory and a field of sales. I want the field of sales to update from a web page. So I have a page with a menu that says sales and then I select golf balls and select 1, how will my sales field update, say from the current 10 to 11 after selecting 1 sale? I know I can do it manually like update golf_table set golf_ball_sales = 11 where golf_ball_manufacturer = callaway; Also, if I want to query a profit list on my golf balls and I have a field that has a percentage of what I paid for the ball and a cost, how would that query look? I have a field of golf_ball_cost, another with my_cost_percentage and another with the golf_ball_sales from above (i.e $45.00 / 50% or $22.50 / 10 which gives me a profit of $225.00.
Forms Updating Database
tblVital is part of the db "test" in MySQL, on "C:" via the usual mysqlin mysql route. How would I say COPY tblVital - or even BACK-UP tblVital.
Inserting / Updating Database
I am using ASP with MySQL. This is code for a calendar application that saves info to the database based on date. It is not giving an error when processed. Nothing is being inserted into the database and nothing is being updated either. Code:
Self Updating Database Scripts
I need to create a server side script that will up date a database with data that will be taken from another website. Is there a way to create something like this on the server so that it runs about every half hour?
Problem Updating Database From Form
I am trying to code a page that allows the user to edit the content that is drawn from the database. The fields show the correct data, drawn from the database, and you can type in the fields, but the database does not update when the "submit" button is clicked. It jumps to the events list page, as it should, but the information has not been changed. My code is as follows: Code:
Updating Database In WinXP From Unix
I'm currently volunteering my services for a non-profit organization and their current website is being hosted on Apache and on Unix. I'm totally new to PHP and MYSQL and learning as I go... my question is am I able to download the current database on the UNIX OS and make changes locally on WinXP and then deploy the changed database back to the remote server on UNIX? If so, are there special configs I must do?
Trouble Updating Mysql Database
I am trying to update my Mysql database with a dataset. The dataset is created and filled on a handheld device running the SqlCE server. I then call the dataset from the handheld via a web service. Running the mysql data adapter and executing the Update method does not seem to work, (I think its because the dataset does not recognise any changes made to it). Can anybody please help me in this regard, or just send me some links with GOOD examples of where somebody is getting it to work.
Connecting To Remote Database
I'm using MAMP on a MacBook Pro. The only database connection I've been able to write that doesn't return an error message is on the database "test" that's installed by default: $link = mysql_connect ("localhost" , "USERNAME", "") or die(mysql_error()); mysql_select_db ("test", $link) or die(mysql_error()); ...where USERNAME is a username I created and accidentally applied to all my databases. Anyway, I assumed I could use the database "test," since I can at least connect to it. But my queries all display error messages, even after I copy the tables they reference into the database test. Finally, I wrote a very simple query: $Geog = mysql_fetch_assoc(mysql_query("SELECT * FROM gw_geog_gw")); But I still get the following error message: Quote: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Users/MyName/Sites/Geobop/Files/World.php on line 7 Does that mean I'm not even connected to the database "test"?
Connecting To A Remote Database....please Help
I'm trying to connect to a remote database, but am not sure how to do that (ie what command I should use in the Terminal). I have a php file that gives me all of the details: <? Database Details ----# $host = "**.**.**.***"; $dbname = "**************"; $dbuser = "**************"; $dbpass = "**************"; Paths Used in Codeing ---# $root_path = "/home/software/public_html/**************/"; $http_path = "http://www.webaddress.com/**************/"; ?>
Triggers To A Remote Database
We make use of a PACS (Picture Archiving and Communication System) and system to store DICOM (Digital Imaging and Communication in Medicine) images (like CT scans, MR images etc.) in our Oncology Center. This PACS system uses mysql as it's native database, in which it stores certain data as date and time of the examination, it uses InnoDB tables. We are building another application around it, which will use data from the PACS tables and will hold additional data in a seperate database in it's own tables. Every study has it's own unique identifier which is stored in the PACS database. Additional data is stored in the additional database, under the same unique identifier to be able to keep track of the data and link it to each other. Now I would like to know if it is possible to add a trigger to the PACS database which will delete the related information in the additional database if a record in the PACS database is dropped. This trigger will have to delete the records in the additional tables before dropping the data in it's own database, so we can maintain a more compact database and don't store data which we cannot link to the PACS system anymore.
Remote Database Issue
I am trying to setup Joomla with the following setup. Web server 192.168.99.80-82 Joomla is specifically at 192.168.99.82 MySQL server 192.168.99.90 I used MySQL Administrator to setup user account which I will call test. Then I right clicked the user and selected Add host from which user can connect. I then typed in 192.168.99.82. I had issues so I also added .80. I then created a database called Joomla and then gave user test full rights to this database. I also opened port 3306 on software firewall. Then I shut off firewall. Tried to install Joomla, but I get error when connecting to database. I loaded MySQL Administrator on web server and I am able to connect to MySQL.
Connecting To Remote Database
I'm passing in the ip address of the server, my userid and password, but I get back my userid appended with my local machine name (or maybe it's the local domain, not sure) and it fails to authenticate? Is there any way to override this appending of domain?
Remote Table In A Database
is it possible to create remote virtual tables in mysql? By that I mean if it is possible to define a table, which actually resides on a remote mysql server, but which can be accessed and addressed as if the table would be on the local database. My intention is to move one table to a remote host, but to be able to address the table as if it was still on the same machine. So for example: SELECT m.header, m.body, m.from, m.to FROM users u, messages m WHERE u.login=m.login; would still work, even though the table "users" resides in the database "moon" on a different host, than the table "message", which resides on the localhost in the database "alltables". The problem I'm trying to solve is: I have to webapplications, which both have a table, which stores login information. Those tables have to be combined into one and have to be put on one of the hosts only. One of the application will access the remote user table for logins. Since many of the SELECTS of this application contain joins like the example above I'm looking for a way in which I do not have to modify the selects but can move the login table to a different machine.
Administrate A Remote Database
How is it possible to administrate a database placed on a remote server, without having access to it's desktop ?When i use the MySql adminstrator program it disables some of the setting, and says it has to bee a localhost connection.I would like to install the dataabase on a server, and afterward just use clients to administrate through.hope someone can explane the setup.
Remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server from another windows box using ODBC?
Updating A Database Field Based On A String Or Filename
I am using MySQL to store images that I serve up with Coppermine photo gallery. Each image is shown in low resolution format. I also store medium and high resolution versions of these files for download. There is a caption field where I put these links using BBcode. It looks something like this: Code:
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
Connect To Remote Database(MySQL)
is there some sort of setting I need to turn on where I can access the database from another server. So instead of using "localhost" I can use the actual server IP address. And just for future reference, is this how you set up a application server connecting to a database server?
Database Synchronisation On Two Remote Sites
I am considering the possibility of trying to keep a user table synchronised on two different sites. This is not something i've done before so i'm looking for any tips that might help me on my way. Basically I was thinking of: - scheduling php script to connect to both databases via cron to update the table at regular intervals - generating an xml feed and doing the same thing Both methods would potentially involve storing a pointer to only read and write the new rows, although perhaps I could use DATETIME to also copy accounts that have been updated since last run. Probably biggest concern is: - security... operating in a way that the data is private. The most sensitive data is hashed passwords and postal addresses, I don't think it would be appropriate to not somehow protect this info during transfers. I'm not sure whether SSL is an option (should be) but possibly I was thinking of creating some kind of token system. - bandwidth. both sites should be fine resource wise but due to my lack of experience in these matters I don't really know what the performance hit will be, and I would like to run the script very often As far as I know alot of big sites (for example hotel booking engines) use xml in the background to share info but I really have no idea how it all works.
Query Database From Remote Location.
I have a database sitting on my db server, which is part of my office network (which has a domain controller). Access to the outside world is via a router, which is well locked down. Currently, remote users access the database front end via Terminal Services but this is only a method of accessing an application stored and running on the Database Server. What I want to do is allow access to the database from a server, which is located in another building (another part of the country). This is essentially an inter/intranet server. What is the best way for me to get this external server to be able to query my database server?
Downloading A Database From Remote Server Using Ssh?
I need to copy a database from a remote server where I have ssh access to my local computer. Can anyone tell me how to do this? I was thinking something like this: - login to ssh $mysql_admin database_name | local_pc (very simplified)
Connect To Database From A Remote Source
I own a website and plan on running multiple message boards on it...the problem is that I would like a database per board...however my host only gives 1 database....unless I want to pay an extaordinary amount of money for more. So I have used my PC as a webserver before without any problems and in fact ran a pretty big board off it with php, mysql, phpmyadmin installed. So my thought was to use a couple of databases off my PC to help run the new boards. I have created the database...but I'm having trouble with the board connecting. I'm sure that it's some kind of permission that needs to be inserted for the remote host to connect to my databases.
Configuring A Database On A Remote Server
i have an aplication on .net for web, with mysql db, in my local server i have no problems, but recently i upload the aplication into a bougt host; when i open the page on the internet explorer or firefox, the page loads well, except for one simple grid. in another part of the aplication i try to insert a record, the app gave the me no error message, but when i check the table, there's nothing new. i don't if i configuring something wrone, on the web.config. and the worse of all if that i dont get any error?
VB6 Controls Not Populating From Remote MySQL Database
I have created a VB6 app that connects to a web hosted MySQL database. I have created the connection string in my app and used the Port number required by the Web Host. All my data comes back to my VB forms when I run my app from my Win XP development machine, but here is my problem... I have installed the app using InnoSetup wizard on a Win2K pc at SP4, and it connects successfully to the databases, but my textboxes, labels, comboboxes and datagrids show no data. For example, one of my forms has textboxes and a datagrid, and a statusbar. The textboxes and datagrid are bound to ADO controls which pass SQL statements to MySQL to create the recordset. The statusbar shows the RecordCount from the resulting recordset. The statusbar shows the correct recordset count, but the textboxes and datagrid are empty. This doesn't happen on my development machine. In my installer, I have installed all the VB Runtime files to the target machines WindowsSystem32 directory, and have installed the OCX files the app uses to the application's directory. I am at a complete loss to know why I can connect to the database, successfully open a recordset but not populate my forms' controls with the resulting data.
Method - Remote Databases To Central Database
I am looking for the best approach to move data from four remote MySQL database applications back to a central MySQL database in near real time. Each remote database has a low number of transactions up to 15 per second of large data sets (12,000 items). The central database will be replicated across two servers for redundancy.
Database Dumps From Remote Server Via Proxy
How to copy a MYSQL database placed on a remote server using 'mysqldump' where there is a proxy server involved? This proxy server requires user name and password. I have Win XP.
Connecting To Remote Database Via MySQL Administrator
I have used Sql Server and other databases extensively. I have the following questions. 1. I need to connect / manage a SQL database located on a remote web server runnin Linux. My workstation is running Windows XP. I understand that this is what MySQL Administrator is for. Is this correct? 2. Can I run both MySQL and SQL Server on my Windows XP machine? 3. What one book would be the most helpful to help me get a basic table setup?
MySQL Slow To Connect To Remote Database
I was running a PHP/MySQL web site with the database on the local web server. I needed to move the database off the webserver (located in the firewall DMZ) and onto its own machine (behind the firewall on our private network) Now when I run my web site it goes really slow. I ran mysql from the command line on the web server and connected through to the database machine behind the firewall using webserver:/# mysql -h 192.168.1.7 -u www-data -p After I enter the password, it takes around 5-7s before I see the mysql> prompt. Is mysql trying to do reverse dns on the IP address and timing out? I added the machine details to /etc/hosts so it would be recognized but no improvement. Or do I have something wrong with my mysql configuration?
Remote Connection To Mysql Database Using JDBC?
I am trying to set up OpenOffice Base to connect to a remote os x server with mysql on it. It has the default mySQL JDBC driver class set to com.mysql.jdbc.Driver It also asks for server URL, should this be the ip address? Port number? Default is set to 3306. When I set the class it says that the JDBC driver could not be loaded.
Copy Records From Tables To Remote Database
there ara two mysql server server1 and server2. server1 ip adress is 192.168.1.2 and server2 ip adress is 192.168.1.3. both servers have same database. i want to copy records server1 to server2 have can i do this?
Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0. I have my jsp files on the remote server Z:. I have my local computer 'A' connected to this server. I have my MySQL database on my 'A' computer. I want to know how to connect the remote JSP files with the database? Currently I am using jdbc.odbc drivers on 'A' computer. But my server computer has Linux and uses org.gjt.mm.mysql drivers. Which drivers and Where should be the drivers?
Connect Remote JSP Files With Local MySQL Database?
I use dreamweaver 8.0. I have my jsp files on the remote server. I have my local computer connected to this server. I have my MySQL database on my computer. I want to know how to connect the remote JSP files with the database? Where should be the ODBC-drivers?
Forcing Remote Reload Of PHP Page After Database Change
I'm developing a mysql database and have users access the data via homemade PHP pages that query data. When the user(s) open the PHP page or query on it, it fetches the data from the database and then refreshes the page showing the new data. If something in the database changes, like if a user adjusts some value, is it possible for mySql to send out some sort of "autorefresh" signal/trigger to all open connections to the database, which could be used to automatically refresh the user(s) PHP page, thus giving them the most up to date information without them having to manually click refresh?
Backup/Restore Mysql Database From Remote Server To Local Pc
Im trying to download mysql database "dbproducts1" which is residing in my webhost's server (Linux). From telnet i backed up using "mysqldump -u -p dbproducts1 > dbproducts1.sql" Then i downloaded this file via ftp to my local pc(WinXP). Now on my local pc to restore database i went to command prompt and i did following: mysql -u -p dbproducts1 < dbproducts1.sql I got following error: ERROR 1064 (42000) at line 380: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-workshop ( title varchar(250) NOT NULL default '', decription longtext NOT ' at line 1 I opened the phpmyadmin and found that dbproducts1 database was restored but with only few tables i.e. not all tables in the db was restored. Can somebody please help me to backup/restore this database. I checked the mysql server version and found following: server version: 5.0.24a-community in my local winxp pc server version: 3.23.36 in my webhost's server (Linux)
MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would like to schedule a task on my local Windows computer to retrieve a backup/dump of this remote database. I have contacted my host, and they indicated that the server is only open to the Internet via mySQL. Therefore, even if I did have access to that server's command line (which I don't) to create dumps via mysqldump, I would not be able to retrieve via FTP. Does anybody have any ideas as to how I can generate backup files from my local computer through a local command-line interface? I have done it through a GUI (DBTools), but I would like to have it done via DOS batch, so that I can schedule it. Does anyone know of any mysql backup GUIs with command line switches? Or can somebody recommend an alternate means of getting a local backup?
How Can I "see" A Table In A Database On A Remote MySQL Server After Creating It
I used the following SQL to create a new table in a database on a remote MySQL server by copying one already there. I know the table exists SOMEWHERE in cyberspace. I can read its data, write to it, delete from it. But I cannot see it. The only way I know it exists is by running this SQL from Access 97 pass through query: SELECT ALL new_tbl.name FROM new_tbl The database resides on a MySQL server that was created with a single table (named test) in it for testing purposes. I ran the following SQL to create another copy of the table in the same database named: new_tbl CREATE TABLE new_tbl SELECT * FROM test; I cannot see the new table in the Access 97 database window under the Tables Tab. Anybody know how to overcome this? Its a severe drawback to programming efforts not to KNOW what tables are in your database.
Updating From 4.0 To 4.1
My web host will update the server to MySQL 4.1 this week. What's the difference? Should I look for something special in my code that might not work after that? They will probably update to ver 5 later as well. But not yet.
Updating
If I have a bunch of cells that say: ,4, and i want to update them with another number (5, and 6, -> $var) so that I would get results like ,4,5, and ,4,6, how would I go about updating that? I notice, if I defined $var, and just use a normal update command, it just replaces it, but I want to keep the 4 in there (not necessarily always 4, but this is an example, as that too is a different number each time). I tried using variables as well, but if I did anything within the while method, I couldn't bring it to the query. Any suggestions?
Updating A Row ....
I have an application for employee punch in/out. My table structure is, ID,Date,Employee Name,In-time,Out-time. Now when on the first punch in of the day, it will add a new record for that employee for that date only in in-time field. Next time, when same employee punches out, it should update the same existing record and put time value in out-time field. Next time when again, same employee tries to punch in, a new record gets added with value in only in-time field and so on.. Now, a totally weird thing happens. Whenever employee tries to punch out (so there is a value in in-time field), it updates that record as well as it adds a new record with same out-time value in in-time field. So in nutshell, it updates the existing record and adds a new record. I checked my script 50 times and put debugging code, but i don't find any errors.
Updating In SQL
UPDATE phpbb_auth_access SET auth_cal = auth_sticky; UPDATE phpbb_forums SET auth_cal = auth_sticky; How do I do this in MySQL?
Updating
Is it possible to do an update with load data infile? We need to load a load of csv files into our database but the tables have additional fields over the ones in the csv files that we need to preserve as they contain the margins and profits for each item.
Updating
like...is it supposed to make only sense if you update the content of your database NOT via a standard rdbms ?and second...do i have to worry about what i ask mysql cause it is so slow?like...i have a query of 17 lines...does it matter at all? and better ask 2 small queries or 1 large?
Can Updating
###### I am trying to update data in a vehicle_fuel column where the conditions match up to the costpergallon column. I need to know if I am doing this right and if this is possible, because at the moment it is not working for me. sql = "UPDATE vehicle_fuel,costpergallon SET vehicle_fuel.fuel_value=costpergallon.costper WHERE vehicle_fuel.fuel_value='0' AND vehicle_fuel.fuel_type_pumped=costpergallon.cost_type"; #### There should be about four different match ups with four different data values and I need it to loop through the entire table and update the data in the different rows.
|
TRACKER
