Try to create a tunnel SSH to remote DB server, but with error Number 2013
hi As the DB server is behind bastion host, each time I have to connect to this host and then connect the DB server In order to connect the server from my pc windows, I use PuTTY to create a tunnel SSH, mapping 'remotserver:port' to 'localhost:6001' thought the bastion host After the configuration , the localhost is suceed listening port 6001 but when I try to connect the server in my pc , it shows MySQL error Number 2013 lost connection to Mysql server during query' Should I have to change some configuration in server to support this kind of connenction? Regards, -- - Lin Chun http://www.brainyquote.com/quotes/authors/f/fred_allen.html
How to load a remote db with lots of data?
I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or any other tool as long as I upload it. I'm not a command-line guy and don't have a clue about that.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
hi, do you have SSH access to the server ? Peter Brian Dunning wrote: I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or any other tool as long as I upload it. I'm not a command-line guy and don't have a clue about that.) -- Best regards, Peter http://AboutSupport.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
You might want to try BigDump http://www.ozerov.de/bigdump.php I can't tell how it will cope with 1 GB of data though. David Brian Dunning wrote: I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or any other tool as long as I upload it. I'm not a command-line guy and don't have a clue about that.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
At 10:00 AM 6/13/05, Brian Dunning wrote: I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? Can phpMyAdmin load a file that is *already* on the server? FTP the 1G CSV file directly to the hosting server, then use phpMyAdmin to load it into database. Otherwise use command line to load the file into database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
On Jun 13, 2005, at 7:06 AM, Peter wrote: do you have SSH access to the server ? No. :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
On Jun 13, 2005, at 7:10 AM, replies-lists- [EMAIL PROTECTED] wrote: do you have shell access to the server? I see that there is some talk about uploading myshell or phpshell to the server, so it appears that that is an option. I don't know the first thing about what that is or how it works though. if you do, then upload the data file to the server (via scp/ftp/whatever) and load it from the commandline. it will take maybe an hour or two to feel comfortable with the commandline (depends how long you've lived in a windoz-only world) and after that you've just gained back a whole bunch of time. Can it be uploaded zipped or gzipped to save upload time? What kind of file would I upload, CSV? Is there a handy FAQ or instructions anywhere for doing this? Thanks. :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to load a remote db with lots of data?
Brian, How about an FTP service on your remote server? Mikhail Berman -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 10:01 AM To: mysql@lists.mysql.com Subject: How to load a remote db with lots of data? I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or any other tool as long as I upload it. I'm not a command-line guy and don't have a clue about that.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to load a remote db with lots of data?
Hi, there is nothing simplier and faster than load data infile (LOCAL) since you can connect to the server Mathias Selon Berman, Mikhail [EMAIL PROTECTED]: Brian, How about an FTP service on your remote server? Mikhail Berman -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 10:01 AM To: mysql@lists.mysql.com Subject: How to load a remote db with lots of data? I have to load my remote MySQL db's with about a gig of data - phpMyAdmin only allows me to upload a 15MB CSV file, so I have to painstakingly separate my data into 15MB chunks and upload them one at a time. It's a huge pain and takes about two entire days. Is there a better solution?? (My ISP blocks remote access to MySQL, so I have to use phpMyAdmin or any other tool as long as I upload it. I'm not a command-line guy and don't have a clue about that.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote: How about an FTP service on your remote server? No - I actually don't have any remote access directly to the MySQL server. My ISP has separate machines for the database servers and the web servers - I can do a lot with my web server, but I don't have remote access to the MySQL server. I can telnet into the web server, and from there I may be able to access the MySQL server - but frankly when you mention telnet or shell I'm already in over my head. :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to load a remote db with lots of data?
Hi Brain, I have to believe that this task shapes to be more administrative than technical. There are number of ways to upload a file, but you need access to the MySQL server. Would it be possible for you to talk to your ISP to allow some type of remote access to MySQL server? You could explain to them your problem loading a huge file into the database. Maybe they are willing to grant you a temporarily access to their server Regards, Mikhail Berman -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 10:36 AM To: mysql@lists.mysql.com Subject: Re: How to load a remote db with lots of data? On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote: How about an FTP service on your remote server? No - I actually don't have any remote access directly to the MySQL server. My ISP has separate machines for the database servers and the web servers - I can do a lot with my web server, but I don't have remote access to the MySQL server. I can telnet into the web server, and from there I may be able to access the MySQL server - but frankly when you mention telnet or shell I'm already in over my head. :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to load a remote db with lots of data?
At 10:36 AM 6/13/05, Brian Dunning wrote: On Jun 13, 2005, at 7:18 AM, Berman, Mikhail wrote: How about an FTP service on your remote server? No - I actually don't have any remote access directly to the MySQL server. My ISP has separate machines for the database servers and the web servers - I can do a lot with my web server, but I don't have remote access to the MySQL server. I can telnet into the web server, and from there I may be able to access the MySQL server Once you telnet into the MySQL server you might be able to use FTP to pull the file from another server; unzip it; then load it into database. - but frankly when you mention telnet or shell I'm already in over my head. :( Good time to learn a few basics... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Easy way to copy record from local db and insert it into remote db?
Hi All, I have a local MySQL db (4.0.12) which I use for developing content for my web site, and my remote website MySQL db (3.23.56) which powers my site. I spend a fair amount of time synching individual records from my local db to my remote db (i.e. either inserting them into the remote db or updating them if they already exist and I have released changes to the record(s) in question) and I have written a fairly complex (for me) PHP script that handles this. But I'm wondering if I'm overlooking something simpler? I'm not really looking for replication, because I don't want all of the local content to be replicated to the remote db, only those records I release for actual publication. I'm wondering more along the lines of if there's a way to feed an insert statement run against my remote db in a window in SQLYog (3.11, the GUI I currently use) using data returned from a select statement run against my local db? Something conceptually like: INSERT INTO `remotedb`.`tbldata` SELECT * FROM `localdb`.`tbldata` WHERE recid= Any help appreciated! Much warmth, Murray http://www.planetthoughtful.org Building a thoughtful planet, one snide comment at a time... * Worried that you might have missed something amazingly amazing on PlanetThoughtful? * Join the newsletter and then you'll know for certain you haven't! * http://www.planetthoughtful.org/html/ptnewsletter.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Easy way to copy record from local db and insert it into remote db?
Murray Wells [EMAIL PROTECTED] wrote: I have a local MySQL db (4.0.12) which I use for developing content for my web site, and my remote website MySQL db (3.23.56) which powers my site. I spend a fair amount of time synching individual records from my local db to my remote db (i.e. either inserting them into the remote db or updating them if they already exist and I have released changes to the record(s) in question) and I have written a fairly complex (for me) PHP script that handles this. But I'm wondering if I'm overlooking something simpler? I'm not really looking for replication, because I don't want all of the local content to be replicated to the remote db, only those records I release for actual publication. I'm wondering more along the lines of if there's a way to feed an insert statement run against my remote db in a window in SQLYog (3.11, the GUI I currently use) using data returned from a select statement run against my local db? Something conceptually like: INSERT INTO `remotedb`.`tbldata` SELECT * FROM `localdb`.`tbldata` WHERE recid= You can use SELECT .. INTO OUTFILE and the LOAD DATA commands: http://www.mysql.com/doc/en/SELECT.html http://www.mysql.com/doc/en/LOAD_DATA.html You can also make a dump file with --where option of mysqldump: http://www.mysql.com/doc/en/mysqldump.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - 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
Re: mysql dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Well it looks like I have limited options. Yep. Hey, you could always host with me ;-) % % I'm guessing that the web host will let me have limited rights to the % server as it is - probably only basic FTP and other limited DB rights - % I do hve some control using phpmyadmin to manipulate data. OK. If I were you I'd just try a quick test. Whip up a php page that says ?php exec(du -h -d 1,$results,$exit) or die(Could not run du\n) ; print space is:br\npre\n ; print_r($results) ; print /prebr\n ; print exit code was '$exit'br\n ; ? and see what you get. If it works, whip up another about like ?php $stamp = date(Y-m-d) ; exec(mysqldump -uUSER -pPASS DATABASE,$results,$exit) or die(Could not run mysqldump\n) ; print results are:br\npre\n . print_r($results) . /prebr\n ; print exit code was '$exit'br\n ; ? with USER, PASS, and DATABASE set accordingly (and you should check the mysqldump grammar; this is all right off the top of my head) and if it doesn't try any of system, `` or popen. % % I'll almost bet that they won't let me run a task from the server. % What about running a script from an exe ? What script, what exe, and what machine? % % thanks Sure thing! % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+OEx9Gb7uCXufRwARAod+AKDaV3f6KSh2eT7zuvIy3gn/osAV6QCgv160 rlm+atsvuT22qIj4fZEKId4= =0Umb -END PGP SIGNATURE- - 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
mysql dump for remote db
Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. thanks MS sql, query - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 2:27 AM Subject: re: question about primary key On Monday 27 January 2003 10:27, Vicente Valero wrote: I want to create a table with a numeric primary key as index in my sql. I want this index will be automatic. I've tried an auto_increment column, but if insert a non-correlative value then all new entries continue from this non-correlative value (1,2,3,4,1026,1027,...). It is possible use the first value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)? No, you can't do this automatically. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 - 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
Re: mysql dump for remote db
The biggest problem is if you want to do this from a remote pc, that pc will need access to the server itself and the mysql client tools. It sounds as if this pc is not on your LAN and I doubt the hosting service will be willing to expose there database to the internet so you can do a backup. If you do have access to the db from your computer you should be able to schedule something as simple as: mysqldum -u user -ppass -h host database file to do your backup. Other then that I'm not sure how you could do this since you already stated your service wont schedule cron jobs. -Nick Mark Stringham said: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. thanks MS sql, query - 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
Re: mysql dump for remote db
On Tue, Jan 28, 2003 at 10:19:19AM -0700, Mark Stringham wrote: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. If you have access to a host that runs cron, run mysqldump with the -h option. i.e. mysqldump -hmysql.example.com -usomeuser -p database name Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stockholm, February 24-28, 2003 Visit http://mysql.com/training for more information Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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
Re: mysql dump for remote db
Please don't hijack threads. In the last episode (Jan 28), Mark Stringham said: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Just cron mysqldump -h webhostmachine from another machine. -- Dan Nelson [EMAIL PROTECTED] sql query - 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
Dumping remote DB
Hi all, I use MyCC 0.8.6 to work around remote data bases, and I need to dump the structures of all of them (also their contents). Can it be done? What SQL query should I use? Thanks in advance, Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina - 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
Re: Dumping remote DB
At 13:53 -0300 1/10/03, Cesar Aracena wrote: Hi all, I use MyCC 0.8.6 to work around remote data bases, and I need to dump the structures of all of them (also their contents). Can it be done? What SQL query should I use? Why not use mysqldump? That's what it's for? Thanks in advance, Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina sql, query - 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
Re: Dumping remote DB
On Fri, Jan 10, 2003 at 01:53:55PM -0300, Cesar Aracena wrote: Hi all, I use MyCC 0.8.6 to work around remote data bases, and I need to dump the structures of all of them (also their contents). Can it be done? What SQL query should I use? Hello Cesar, Use the mysqldump utility. % mysqldump --host mysql.example.com For more information, see: http://www.mysql.com/doc/en/mysqldump.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL User Conference and Expo April 10-12, 2003, San Jose, California Visit http://mysql.com/training for more information Public Service Announcement: Open Source Initiative (http://www.opensource.org) - 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
Re: using libmysqld - can't connect to remote DB as client.
Hi, I didn't get your code but I haven't read all mails received through the night... But I these days don't find the time to analyze it. I've only once experimented with libmysqld so far and didn't enjoy it very much since the INNO-tables storing the table-linking-information, the transactions etc. are at least 20 MB. Am I wrong? Is there a configuration option making libmysqld consuming less hard-disk-space? Bernhard - Original Message - From: Steven Webb [EMAIL PROTECTED] To: Bernhard_Döbler [EMAIL PROTECTED] Cc: Mysql list [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 8:09 PM Subject: Re: using libmysqld - can't connect to remote DB as client. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. - 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
Re: using libmysqld - can't connect to remote DB as client.
On that page, it says: You can't connect to the embedded server from an outside process with sockets or TCP/IP. ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? - Steve --- Paul DuBois [EMAIL PROTECTED] wrote: At 11:09 -0800 11/6/02, Steven Webb wrote: I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. Nothing there, perhaps. But the general description of the embedded server points out that it does no networking. You cannot use an embedded app to connect to remote servers, nor can external clients connect to the embedded server. (This is one reason the manual says embedded servers can't be used in replication.) So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve - 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 __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - 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
Re: using libmysqld - can't connect to remote DB as client.
At 11:14 -0800 11/7/02, Steven Webb wrote: On that page, it says: You can't connect to the embedded server from an outside process with sockets or TCP/IP. ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? The client library calls are replaced with (or mapped onto, if you will) calls that talk to the embedded server. - 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
Re: using libmysqld - can't connect to remote DB as client.
I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve --- Bernhard_Döbler [EMAIL PROTECTED] wrote: Have you looked thru the source to see if there are differences in the libmysql and libmysqld implementation of mysql_connect()? If mysql_connect does not work then you must see in the source why. Why do you link against libmysqld when you nee libmysql functionality? Bernhard - Original Message - From: Steven Webb [EMAIL PROTECTED] To: Mysql list [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 8:19 PM Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
RE: using libmysqld - can't connect to remote DB as client.
From the mysql docs on the website (URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect) The proto is: MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag); I'm calling it as: mysql_real_connect(db, host, user, passwd, dbname, 0, NULL, CLIENT_COMPRESS); That should work, yes? My code is almost the exact same as the libmysqld example source here (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example) except after making the local connection, I try a remote connection afterwards. I can send code to anyone if they want, but the mailing list bounced my attachment when I tried to send the code to the list. - Steve - Steve --- Luc Foisy [EMAIL PROTECTED] wrote: not sure if this applies here, its from the c++ api docs (but why switch it around) Do you have the parameters sent in the right order? // The full format for the Connection constructor is // Connection(cchar *db, cchar *host=, //cchar *user=, cchar *passwd=) I really know nothing about the c, c++ api's, just trying to help -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 3:58 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. I am. See the original post: // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: So use the C syntx instead. :) -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 12:21 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); - 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 __ Do you Yahoo!? HotJobs - Search new jobs
Re: using libmysqld - can't connect to remote DB as client.
At 11:09 -0800 11/6/02, Steven Webb wrote: I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. Nothing there, perhaps. But the general description of the embedded server points out that it does no networking. You cannot use an embedded app to connect to remote servers, nor can external clients connect to the embedded server. (This is one reason the manual says embedded servers can't be used in replication.) So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve - 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
Re: using libmysqld - can't connect to remote DB as client.
Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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
RE: using libmysqld - can't connect to remote DB as client.
I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 - 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
RE: using libmysqld - can't connect to remote DB as client.
Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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
RE: using libmysqld - can't connect to remote DB as client.
So use the C syntx instead. :) -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 12:21 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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
RE: using libmysqld - can't connect to remote DB as client.
I am. See the original post: // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: So use the C syntx instead. :) -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 12:21 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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 __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - 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
RE: using libmysqld - can't connect to remote DB as client.
not sure if this applies here, its from the c++ api docs (but why switch it around) Do you have the parameters sent in the right order? // The full format for the Connection constructor is // Connection(cchar *db, cchar *host=, //cchar *user=, cchar *passwd=) I really know nothing about the c, c++ api's, just trying to help -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 3:58 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. I am. See the original post: // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: So use the C syntx instead. :) -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 12:21 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); - 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
using libmysqld - can't connect to remote DB as client.
Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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
using libmysqld, can I still connect to a remote DB as a client in the same app?
I'm writing an application that maintains its own database using the mysqld lib. I can use mysql_real_connect to connect to the internal server fine, but I also want to be able to connect to an external (or remote) server as well. When using mysql_real_connect to try to connect to a remote server, I get database not found on server. I think that since it's returning faster than it does when just connecting using the main mysql client app, that it's probably checking the internel server although I'm specifying a host, user, password, ... when trying to connect to the remote machine. I'm using the 4.0.4 beta source. - Steve __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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
remote DB
Hello, Can anyone tell me if the MySQL database has a defualt user ID and password? I am trying to access a remote DB with my application, but am experiencing difficulties. This may be because I need correct user access details. Are there such details, and if so, what are they please? Thanks alot. Paul. Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
Re: remote DB
If your not the admin of the DB, you'll have to ask the DB's admin for your login and password. If you are the admin, you'll need to RTFM about DB security and the GRANT and REVOKE statements. And no, it's not a good idea to allow connections using the root user to perform anything else other than db administration. - Original Message - From: p w [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 04, 2001 14:40 Subject: remote DB Hello, Can anyone tell me if the MySQL database has a defualt user ID and password? I am trying to access a remote DB with my application, but am experiencing difficulties. This may be because I need correct user access details. Are there such details, and if so, what are they please? Thanks alot. Paul. - 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
Re: Accessing MySQL remote DB from VB5
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server? If so, what should I distribute with my software? I have done some things like that, and since VB unses standard ODBC connections the only thing you need to include in your dist is the MyODBC API /roger - 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
Accessing MySQL remote DB from VB5
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server? If so, what should I distribute with my software? Thanks Francisco
Re: Accessing MySQL remote DB from VB5
Runs like a charm here. Just need myodbc from the mysql website. - Original Message - From: "licita" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 18:53 Subject: Accessing MySQL remote DB from VB5 Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server? If so, what should I distribute with my software? Thanks Francisco - 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
accessing a remote DB
Hi, I want to have my application running on server A and have my MySQL DB installed on a another server B. Because I need to call MySQL programs on A I have installed the MySQL package on A and want simply to locate the DB on B. OK I can also install everything on B and start the deamons on both machines and connect with -hostname -user from A to B but it doesn't seem very nice to me. I have tried the parameter --datadir=\\B\MySQL\data on a shareable directory but the new inserted rows are only shown after restarting the daemon on A. Perhaps I should use such parameters as --flush or any others to avoid this problem ? But I think a such a solution can bring to poor performance which is not the goal. I have tried the parameters --bind-address with --port but I get the following error messages: can't start server: Bind on TCP/IP port: No error 010130 16:11:39 Do you already have another mysqld server running on port: 3306 ? 010130 16:11:39 Aborting whether or not a daemon is running on B Does someone have got a clue because I don't see any docus on this theme ? Thank you in advance Eric -- Sent through GMX FreeMail - http://www.gmx.net - 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