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 configurati
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 -
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
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
al 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 al
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
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 wor
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]
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 da
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 s
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 hug
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??
"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
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
-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 b
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
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
-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
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
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
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 yo
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 PROTECT
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.
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
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
Argenti
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 usi
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 anyth
>
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
> attachme
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 r
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
>
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 PR
asswd="")
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 -
quot;);
> > 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
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
he 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:
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]> w
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
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
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
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
&g
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
>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
--
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 progr
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
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 bo
45 matches
Mail list logo
