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
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??
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
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
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
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]
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
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
:[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
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
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
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
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
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
-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
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
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
-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
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
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
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
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
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
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,
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.
%
, 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
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
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
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
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
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
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
: 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
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
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
:
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
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
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
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
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
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
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
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 quer
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
45 matches
Mail list logo