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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL With Squid Proxy Server
I have a number of allowed web sites that I want squid to be able to access, but by default Squid doesn't support MySQL and I'm having difficulty finding sources with information on how to enable access. I know it's possible because the current (soon to be deprecated) proxy has this functionality. The only other solution I can think of is to write the database to a file every so often, as the list of allowed sites is constantly being updated. Is there a way in MySQL to write the contents of a database to a text file say every 5 minutes?
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)
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?
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)
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.
Mysql Dumps And Flushes
We currently perform nightly dumps of around 600 mysql databases. The databases are pulled from the mysql server to a backup server using mysqldump. we use the following script on the backup server: #!/bin/bash DBS=`/usr/bin/mysql -h <IP Remote mysql Server> -u <user> --password=<password> -B -N -e "show databases;"` for db in $DBS do `mysqldump -v -h <IP Remote mysql Server> -u <user> --password=<password> $db > localbackuppath/$db.sql` done /usr/bin/mysqladmin -h <IP Remote mysql Server> -u <user> --password=<password> flush-logs Backup seems to be working, although the flush is throwing out errors.......a couple of questions from this (and I will research further myself)..... 1) Are the mysqldump switches optimal....should there be any more, less, better way of doing it.....thinking about ease of restores. 2) Is the flush writting transactional data back to the databases. Does this affect the .BIN file 3) Do I need to copy any other files at backup such as BIN files 4) Are the number of BIN files controlled by flush? Can housekeeping be performed to get rid of redundant files?
Programmatic Table Dumps
The tables are updated weekly with about 7K - 9K new records. I plan on keeping two generations of the tables in the system. The flow model is to dump or archive the oldest version of the tables, copy the newest version of the tables to the older tables, then apply the updates to the newest version of the tables. The dumped older version will eventually find its way to an archive tape. The tables right now contain about 7 million records each, and are added to each week. Right now, the tables are myisam, although I am considering moving to innodb. I want to accomplish this versioning programmatically (C++) and am looking for an efficient way to dump the tables. Should I use the std::system command to invoke a shell script that uses either mysqldump or mysqlhotcopy, or can I do this efficiently with mysql commands in my program? Does anyone have experience with this.
Cannot Log In To Remote Server
I am trying to set up a replication server and cannot get past an error trying to log on to the master from the slave. I have tried everything I can think of and am at a loss as to what else I can check/do. The error on the slave server is: Error: 'Host 'myslave.mydomain.com' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400 The error itself is confusing. Since this is the slave log, the reference to "this MySQL server" does not make sense. I am not (should not be) trying to connect to "this MySQL server" but rather the remote master server. I am guessing that the error is just poorly worded. I have a user on the master with the host name 'myslave.mydomain.com'. What else is needed to allow that user to connect from the slave host? I tried changing the host name to '%' but that didn't help either. Can someone point me in the right direction?
Remote Server
How I can connect my aplication in delphi with database mysql in remote server?
Remote Sql Server
I am using PHP on my site and I wanted to play around with myqsql. Rather than just going ahead and upgrading my account @ a monthly cost for testing, I thought that I would just add mysql on my pc and connect to it from my remotely hosted site. I opened port 3306 on my firewall. I can connect to the database but it will not allow me to select the database
Remote Connection To Sql Server
I've set the remote website, dotbooks.org (207.44.234.74) as an "Access Host" in cPanel. I'm trying to connect to wiishare.org (70.86.206.218) The connection string I'm trying is: <?php $user = "username"; $password = "password"; $database = "database"; $link = mysql_connect("70.86.206.218", $user, $password); mysql_select_db($database, $link); echo mysql_errno($link) . ": " . mysql_error($link). " "; ?> The string works with localhost, but not like this. It just times out Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in connect.php on line 7 Any suggestions?
MySQLimport To Remote Server
I am running mysql on my windows machine, and I am trying to use mysqlimport to import a text file onto a remote server into an existing table. The error I am getting is that access is denied for user 'Robert_Davis'@'%' (using password=yes), when using table: mytable
Connect To Remote Server
I am very new at this. I installed MySQL and PHP on my Hard drive. I can connect to MySQL through localhost on my hard drive. We have a server at work at a remote location. He just installed MySQL and gave me a password on root. As far as I know there are no databases created. I need to connect to the remote server and create a new user and database. I've downloaded Secure CRT but don't understand how to use it. I entered my ip addresss in a new session and it seems to connect but then it says session fails. I put a test script up and just get an error message. Should this script at least not give me an error message. Should I contact the person in charge of the server? <? /** * Connect to the mysql database. */ $conn = mysql_connect("localhost", "root", "password") or die(mysql_error()); ?> Client does not support authentication protocol requested by server; consider upgrading MySQL client
Connecting To A Remote Server
not 100% sure which forum this should go in.. if it is in the wrong forum i am sorry. i have just got my ubuntu box working as a server at home with dynamic dns. i have still got my website on another server. i have taken all my DB;s across to my server and want the old server to update my new one so there is only one set of data to deal with. my issue is how do i do this? so i started with started with a simple file that connects to ponywars.com with user name and password. Then realized that i should add the user in with external hosts. i did this in phpmyadmin with user name, host being *.* and setting the password and giving it ALL access to make sure i not missed something. but when i ran this from the old server it just hang for ages then said: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/ghoxmfjz/public_html/test.php on line 7 cant conect to ponywars.com so i tried it the other way around to connect to happygolucky.me.uk and get the script to run. this worked fine. so i can only think its a number of things. i tested to see if my ubuntu box was listening on 3306 which it seemed to be. i think i have added the user in correctly but not 100% sure on that one, seemed to have. is the php page understanding how to connect to dynamic dns, cant see why not as the rest of the site works, ssh works, vpn works. as i understand it i have set up a dmz which forwards it everything to the server. sorry i have not given more examples etc not sure what people need to help, so any all helps suggestions, flames etc are all welcome.
Connect To Remote Server
I have created a database in a remote host using MySQL 5.0. I created tables using the control panel of the host. I accessed the tables several times using the same procedure. Recently, I downloaded MySQL Admin and tried to connect to the remote server. Nothing happens. It just froze there without any message or what. Is there a secret way of doing this? I can connect to a remote host in a local network but when it comes to using the internet via a router I always encounter this same kind of problem.
Connecting To A Remote MySQL Server
I havn't done this before and i'm not sure how to do it. I have another computer on a LAN that is running a mysql server and is the machine that is also running the intranet server which i am working on. What i want to know is how to connect to this server from my MySQL console so i can administer the databases without having to be in the main machine. I thought it would be as simple as using the IP address but this doesn't seem to do it. Can i connect annonymously like i can from the host or do i have to have a user account setup?
Remote Access To My Mysql Server
I ran grant all privileges on *.* to 'root'@'%'; I've got two questions... firstly, when I try to get to it from another machine on the local network it tells me access denied... secondly, I'm on a soho network with a NAT router... what port/ports do I set up to access the mysql server from the outside?
Connecting Remote Server In Mysql
Waht is the way to connect the remote database in mysql? right now i am connecting it with localhost as server name but if i want to connect other datasource it showing the error datasource not found.
Connect To A Remote MySQL Server On The LAN
The MySQL setup on my WinXP machine runs fine with host localhost, username root, and my password. But I can't seem to access my databases from a different machine on my LAN. When I try to connect from another network PC , I always get: MySQL Error No 2003 Cannot connect to MySQL server on 'remotehost' (10060) All the settings in my ini seem correct. I've allowed TCP/IP connections. I know which port to specify. Did I forget to do something on the LAN to allow remote access? I've tried sharing the basedir and datadir folders. That didn't work. I also tried using IPs instead of hostnames. Didn't work either. When I try to ping the remote host (using MySQL Administrator), I just get a timeout error.
Connecting To Remote MYSql Server
I want to connect to a remote mysql server from command line. I don't have a mysql client installed on my local machine from which i want to connect to my Data base server.
Can't Connect To Remote MySQL Server
I am developing a site on a remote cPanel system and I am not able to connect to the MySQL database from my location. My application can connect to the server using localhost just fine. I have ensured that the correct port is open in the firewall (the server responds to telnet on that port) and I have added our IP address as an access host in the MySQL area of the client's cPanel but I am still unable to connect. The exact error message when I try to connect is: Access denied for user: 'user@<my IP>' to database 'user_database'
Connect To A Remote MySQL Server
I need to connect to a remote mySQL server. I have the IP address, userID, and password. When I try using these from another computer I get an "access restricted" error. How do I get to this remote mySQL server?
Remote Connect To Mysql Server
My host says that I don't need to login to my server in order to connect to my mysql server. They say all I need to do is enter this command into a mysql client: mysql -h xxx.xxx.131.240 -u User -p Database Password However, they don't want to mention any client to use to connect with. What client can I use? Putty? Where do I enter that command?
Problem Selecting DB On Remote Server (I Use Cpanel)
I'm having problems connecting to my a mysql db on a remote server. Essentially, when I try to select the db.. mysql_select_db ("db_music") or die(mysql_error()); .. I get the "Access denied for user.." line. However, I am sure all my info is correct. I've also added my ISP into the list of allowed mysql hosts. Could this be a problem w/ my ISP or a local firewall?
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.
Insert Records To Remote Mysql Server
for a insert statement, there are two packets on the network between the client and the server. so, the packet's number will be double of the number of insert statement. that is rough. I want there will be a few packet used for many many insert statement. Is there any way to make that true.
Remote Access To MYSQL Server Host
I am trying to access a mysql database on my old host (I'm doing a CMS migration to something on a different server.) My hosting company doesn't have a CLUE what I'm talking about when I say MYSQL server host (I'm not even sure I do). They keep telling me it's 'localhost'. I can access both dbs through their prospective phpmyadmins. Is there any way I can find out what the host server is? I would just export the db and then import it into the other one, but all attempts at that have failed.
MySQL Proxy
Does anyone know if it is possible to connect to a MySQL database via a local connection to an external server? For example: I have a MySQL database located on the local machine, so I can connect via my PHP scripts to localhost. However, I have multiple users on this server who do the same thing and I need to move the databases to an external and dedicated DB server. But I don't want to have to tell my users that they now have to change their scripts to connect to the new DB server instead of localhost. So is it possible to configure some sort of proxy so as to allow my users to continue to use localhost, but actually connecting to the new external DB server, without them realizing it?
Creating A Data Dump & Uploading To Remote Server
I've just taken an intro class on PHP and MySQL. I've got the technolgies running on my local machine. I can't seem to get a detailed, easy to understand, step by step guidance on how to transfer what I've got locally to my remote web host who is running MySQL and phpMyadmin. I'm running MySQL Server 4.1. Need to know how to copy my SQL tables and database to a sql file and then upload.
Mysql Proxy/filter?
I am looking for something that will proxy/filter mysql connections. The aim being that it will parse the incoming query and decide if its a write or read transaction and send it to a single master or set of slaves. I have investigated such things as SQLRelay but this appears to be based around API rather than a drop in replacement. Is anyone aware of any project or product that will achieve what I am looking for?
MySql Client 3.51 Through Proxy
OK I am working with an external company that has opened a DB for us to attach to. There documentation has you install My Sql 3.51 driver. I have all the login info and server address correct but it fails to connect. We do have a firewall here but I see no place in the System DSN to reference it. Do I need something else to make the work with a firewall?
Remote Access Not Working: Error 1251 Client Does Not Support Authentication Protocol Requested By Server
I'm trying to set up my MySQL database for remote access. I've never been a DB admin so this is all mostly new to me. I am binding to my public IP address, and I have created a new user with the following grant commands run from the mysql command line on the server: mysql> grant all privileges on prs_data.* to 'username'@'%' identified by 'change'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on prs_data.* to 'username'@'localhost' identified by 'change'; Query OK, 0 rows affected (0.01 sec) When I try to connect remotely from another host, here's what happens:
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.
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?
|
TRACKER
