Any GUI to import/export MySQL?

Simon

unread,

Feb 28, 2006, 3:55:48 AM2/28/06

to

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

Jerry Stuckle

unread,

Feb 28, 2006, 7:06:50 AM2/28/06

to

Is MySQL on the remote system set up to accept connections from remote
systems? If so, you can run the mysql command line on your system to
dump and restore your databases.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

Simon

unread,

Feb 28, 2006, 7:13:55 AM2/28/06

to

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

> Is MySQL on the remote system set up to accept connections from remote
> systems? If so, you can run the mysql command line on your system to dump
> and restore your databases.
>

I don't have command line access to the server.

Simon

Giuseppe Maxia

unread,

Feb 28, 2006, 8:57:29 AM2/28/06

to

He meant command line on your machine

$ mysqldump -h remote_host_IP -u USER -pPASSWORD db_name > file.sql

see the manual: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.blogspot.com/

Jerry Stuckle

unread,

Feb 28, 2006, 12:17:38 PM2/28/06

to

No, if you have remote access to the server, you can run the commands on
your command line.

You don't need command line access at the server. See the mysql
command. See
http://dev.mysql.com/doc/refman/5.1/en/using-mysql-programs.html

Bill Karwin

unread,

Feb 28, 2006, 12:53:11 PM2/28/06

to

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

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

You could use SELECT ... INTO OUTFILE and create a CSV-formatted dump of
each table. You have to do this one table at a time.

Then move these dump files to your destination server and use LOAD DATA
INFILE to import each table.

See http://dev.mysql.com/doc/refman/5.0/en/load-data.html

You'll probably want to export the database structure (sans data) with
phpMyAdmin and use that to restore the empty structure on the destination
server before loading data.

Regards,
Bill K.

Message has been deleted

Martijn Tonies

unread,

Mar 1, 2006, 2:33:04 AM3/1/06

to

Our tool Database Workbench has a nice DataPump tool for this,
perhaps it could help.

Download a copy at http://www.upscene.com

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Mike Lischke

unread,

Mar 1, 2006, 3:16:30 AM3/1/06

to

Simon wrote

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

Provided you have remote access from your desktop you can use MySQL
Administrator to backup your database and later restore it. The nice thing
with MA is that you can selectively restore elements as it analyzes the
backup file and provides you with a list of found objects.

MA works with version 4.x and newer (not 5.1 yet).

Downloaded: http://dev.mysql.com/downloads/administrator/1.1.html.
Product info: http://www.mysql.com/products/tools/administrator/
Online docs: http://dev.mysql.com/doc/administrator/en/index.html

Mike
--
Mike Lischke, Software Engineer GUI
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification