Any GUI to import/export MySQL?

[Simon]

Hi,

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.

Do you guys know anything I could use?

Many thanks

Simon

[J.O. Aho]

Simon wrote:

Hi,

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.

Do you guys know anything I could use?

Take a look at www.mysql.com, they do offer a couple of frontends that can be
used with mysql.
//Aho

[Greger]

J.O. Aho wrote:

Simon wrote:

Hi,

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.

Do you guys know anything I could use?

Take a look at www.mysql.com, they do offer a couple of frontends that can
be used with mysql.
//Aho

hi
which one?hte migration toolkit?
--
www.gregerhaga.net

[Fabian Hore]

still using PHP:

1.
You can always dump an OUTFILE and insert elsewere as an INFILE
very fast. but both mysql users will require FILE privileges.

2.
Plus if you can access shell programs via PHP, so you can use the
`mysqldump` and `mysqladmin` programs. without needing command line access.
off the top of my head ... execute a shell command like:
`mysqldump -uxxx -pxxx -hlocalhost mydb > './tmpfile' &&
mysqldump -uzzz -pzzz -hremotehost newdb < './tmpfile' `


"Simon" <sp********@example.com> wrote in message
news:46************@individual.net...

Hi,

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.

Do you guys know anything I could use?

Many thanks

Simon

[Simon]

>

1.
You can always dump an OUTFILE and insert elsewere as an INFILE
very fast. but both mysql users will require FILE privileges.
hum, how do you do that?

2.
Plus if you can access shell programs via PHP, so you can use the
`mysqldump` and `mysqladmin` programs. without needing command line
access.
off the top of my head ... execute a shell command like:
`mysqldump -uxxx -pxxx -hlocalhost mydb > './tmpfile' &&
mysqldump -uzzz -pzzz -hremotehost newdb < './tmpfile' `

Yes, I guess I could always do that.
I also found the MySQL administrator on www.mysql.com.

Both domains seem to have remote access, so I should be ok, (I hope).

A script would have been great, because the problem is that phpmyadmin
timeout after 30s, so a JavaScript type of script would have been nice.

Simon

[Fabian Hore]

"Simon" <sp********@example.com> wrote in message
news:46************@individual.net...

1.
You can always dump an OUTFILE and insert elsewere as an INFILE
very fast. but both mysql users will require FILE privileges.

hum, how do you do that?

SELECT INTO OUTFILE '/tmp/whatever' ...
see http://dev.mysql.com/doc/refman/4.1/en/select.html
- and -
LOAD DATA INFILE ....
see http://dev.mysql.com/doc/refman/4.1/en/load-data.html

[Simon]

>> >

1.
You can always dump an OUTFILE and insert elsewere as an INFILE
very fast. but both mysql users will require FILE privileges.

hum, how do you do that?

SELECT INTO OUTFILE '/tmp/whatever' ...
see http://dev.mysql.com/doc/refman/4.1/en/select.html
- and -
LOAD DATA INFILE ....
see http://dev.mysql.com/doc/refman/4.1/en/load-data.html

Yes, but then it will timeout after 30 sec, (I think).

Simon

[Fabian Hore]

>> SELECT INTO OUTFILE '/tmp/whatever' ...

see http://dev.mysql.com/doc/refman/4.1/en/select.html
- and -
LOAD DATA INFILE ....
see http://dev.mysql.com/doc/refman/4.1/en/load-data.html

Yes, but then it will timeout after 30 sec, (I think).

trust me its fast! you can dump thousands of rows in milliseconds.
and even if it did timeout, you can extend the PHP execution time with
set_time_limit()
see http://uk2.php.net/manual/en/functio...time-limit.php

[Mladen Gogala]

On Tue, 28 Feb 2006 08:56:30 +0000, Simon wrote:

Hi,

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.

Do you guys know anything I could use?

Tora works with MySQL as well (http://tora.sourceforge.net). It's a
Linux GUI tool, based on KDE and QT (there is also a Win32 version)
which is extremely handy for another variety of databases (tora stands
for "Tool for Oracle Applications developer" where Oracle Corp. is the
company that owns Innodb and makes that beautiful, fast kernel for MySQL.
Once again, this is not a joke: tora really does work with MySQL as well
as with Oracle.

--
http://www.mgogala.com

[Jim Carlock]

"Mladen Gogala" <go****@sbcglobal.net> wrote:

Tora works with MySQL as well (http://tora.sourceforge.net). It's a
Linux GUI tool, based on KDE and QT (there is also a Win32
version) which is extremely handy for another variety of databases
(tora stands for "Tool for Oracle Applications developer" where
Oracle Corp. is the company that owns Innodb and makes that
beautiful, fast kernel for MySQL.

Once again, this is not a joke: tora really does work with MySQL
as well as with Oracle.

Hello, Mladen.

This particular tool requires an oci.dll file. Would you know where
to pick up such?

Jim Carlock
Post replies to the group.

[NC]

Simon wrote:

I need to export a 200MB database from one domain to another.
phpMyAdmin timeout after a while and is not ideal.

I don't mind spending money if I have to but this is rather urgent.

I only work on win32 machines but the servers are Unix machines.
I don't have command line access to the servers.
Another potential problem is that your Web hosting company may be
blocking remote access to MySQL...
Do you guys know anything I could use?

Start with the obvious -- the command-line MySQL client tools. You can
install mysql client and related utilities on your Windows machine and
use it to access your remote servers. Just start MySQL client with a
-h key to access a remote server, something like this:

mysql -h mysql.myremoteserver.com -u myusername -p

There are also plenty of third-party tools to access and manage remote
MySQL servers. My personal favorite is MySQLmanager:

http://www.sqlmanager.net/en/products/mysql/manager

You can download a fully-functional 30-day trial version and actually
migrate your data before you buy...

Cheers,
NC