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]

Re: Any GUI to import/export MySQL?

Simon wrote:[color=blue]
> 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?[/color]

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


//Aho

[Greger]

Re: Any GUI to import/export MySQL?

J.O. Aho wrote:
[color=blue]
> Simon wrote:[color=green]
>> 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?[/color]
>
> Take a look at www.mysql.com, they do offer a couple of frontends that can
> be used with mysql.
>
>
> //Aho[/color]
hi
which one?hte migration toolkit?
--

https://www.gregerhaga.net

[Fabian Hore]

Re: Any GUI to import/export MySQL?

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" <spambucket@exa mple.com> wrote in message
news:46ihg9Fba0 apU1@individual .net...[color=blue]
> 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
>
>
>[/color]

[Simon]

Re: Any GUI to import/export MySQL?

>[color=blue]
> 1.
> You can always dump an OUTFILE and insert elsewere as an INFILE
> very fast. but both mysql users will require FILE privileges.[/color]

hum, how do you do that?
[color=blue]
>
> 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' `
>[/color]

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]

Re: Any GUI to import/export MySQL?


"Simon" <spambucket@exa mple.com> wrote in message
news:46ivd4Fbbp ndU1@individual .net...[color=blue][color=green]
> >
>> 1.
>> You can always dump an OUTFILE and insert elsewere as an INFILE
>> very fast. but both mysql users will require FILE privileges.[/color]
>
> hum, how do you do that?[/color]

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]

Re: Any GUI to import/export MySQL?

>> >[color=blue][color=green][color=darkred]
>>> 1.
>>> You can always dump an OUTFILE and insert elsewere as an INFILE
>>> very fast. but both mysql users will require FILE privileges.[/color]
>>
>> hum, how do you do that?[/color]
>
> 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
>
>[/color]

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

Simon

[Fabian Hore]

Re: Any GUI to import/export MySQL?

>> SELECT INTO OUTFILE '/tmp/whatever' ...[color=blue][color=green]
>> 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
>>
>>[/color]
>
> Yes, but then it will timeout after 30 sec, (I think).[/color]


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]

Re: Any GUI to import/export MySQL?

On Tue, 28 Feb 2006 08:56:30 +0000, Simon wrote:
[color=blue]
> 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?[/color]

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]

Re: Any GUI to import/export MySQL?

"Mladen Gogala" <gogala@sbcglob al.net> wrote:[color=blue]
> 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.[/color]

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]

Re: Any GUI to import/export MySQL?

Simon wrote:[color=blue]
>
> 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.[/color]

Another potential problem is that your Web hosting company may be
blocking remote access to MySQL...
[color=blue]
> Do you guys know anything I could use?[/color]

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.myremotes erver.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