Aaron
Aaron Blew さんは書きました:
> mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u
> root -h localhost DATABASE
perfect answer..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I would suggest running something like this from your new linux server:
mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u
root -h localhost DATABASE
This will pump the ouptut directly from mysqldump into mysql running
on the linux machine, so you don't need another transfer mechan
See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of
a User
Because of the fundamental difference between binary data files under Windows
and under Linux.
In Response To:
At 07:09 PM 6/26/2008, you wrote:
>See Thread at: http://www.techienuggets.com/Detail?tx=42035
I move 1giga size of 'JPetstore' record(sql text) from RH4.6 to RH5.2.
mysqldump&mysql commands are no problem.
pg_dump&psql commands are same result.
It takes about 10 minutes of my Celeron 1G.hz note.
First I gziped sql text to small size, then ftp, unpacked on Target(Linux).
I forgot any of dat
At 07:09 PM 6/26/2008, you wrote:
See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on
behalf of a User
Hi,
I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized
database that I'd like to move from a Windows 2000 based server to a Linux
server. What's th
See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf of
a User
Hi,
I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte sized
database that I'd like to move from a Windows 2000 based server to a Linux
server. What's the best way to do this? I normally ta
scene
mrtg.grunn.org Dutch mirror of MRTG
-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Seena Blace
Verzonden: dinsdag 10 februari 2004 20:24
Aan: [EMAIL PROTECTED]
Onderwerp: [Mysql-discussions] Migration from windows to linux red hat
Hi,
I have 10 tables wh
windows to linux red hat
Hi,
I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red
hat mysql(V3.23.54).How to do that pl? Some tables are having real data
also.
thx -seena
-
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
Hi,
I have 10 tables which I want to migrate from windows mysql(V4.0.17) to red hat
mysql(V3.23.54).How to do that pl? Some tables are having real data also.
thx -seena
-
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
I do this all the time at my work for really large tables. Just scp,
ftp the entire data directory over to the linux box and restart the
MySQL service. The only addition thing you might want to do is compress
the file before sending them just so you have some way to check them and
tables usually
Well, he could do that but being inexperienced with Linux, I figured it
would be more beneficial to use a familiar WYSIWYG so he doesn't blow
and hour playing the with CLI like I did :)
On Tue, 2003-11-04 at 16:58, Big Brother wrote:
> err why not do a mysqldump then just import that?
>
> ---
>
day, November 03, 2003 6:51 PM
To: [EMAIL PROTECTED]
Subject: Windows to Linux
Hi there,
I have taken the plunge and dropped windows in favour of linux. My
question is what is the best way to get the data from my windows mysql
databases into linux? Can I just copy some files from one partition to
Check out SQLYog, could can connect and copy databases...pretty much
like MSSQL Enterprise manager. They have a trial version on their site:
http://www.webyog.com/sqlyog
On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote:
> Hi there,
> I have taken the plunge and dropped windows in favour of linux
Hi there,
I have taken the plunge and dropped windows in favour of linux. My
question is what is the best way to get the data from my windows mysql
databases into linux? Can I just copy some files from one partition to
another or what?
Thanks,
Matt
--
MySQL General Mailing List
For list archi
ps--I don't normally connect to MySQL through ODBC.
-Rob
-Original Message-
From: Aric Cheah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:36 AM
To: [EMAIL PROTECTED]
Subject: Connection problem!!! Windows to Linux
Hi there:
I need URGENT help about this ..
I wrote a
If you manually updated the tables, use flush privileges to inform the
DB server of your changes.
Cheers
/rudy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:23
To: [EMAIL PROTECTED]
Subject: Re: Connection problem!!! Windows to Linux
Aric
Aric Cheah <[EMAIL PROTECTED]> wrote:
>
> I wrote a program application for windows which can add and delete data
> from this application, it working fine with my own MySQL install on the
> same windows OS.. Now I try to change the connection this dayabase to
> the server whihc runnign under l
Hi there:
I need URGENT help about this ..
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux
Linux
Hi,
Yes.
1.You must shutdown mysqld from Windows and from Linux.
2.Copy files from Windows to Linux.
...optional shutdown Windows ... for ever.(Ha,ha,ha...just a joke)
3.Change owner of the files to "mysql".
4.Check access permision to files and directory.
Anyway, is recomen
Hi,
Yes.
1.You must shutdown mysqld from Windows and from Linux.
2.Copy files from Windows to Linux.
...optional shutdown Windows ... for ever.(Ha,ha,ha...just a joke)
3.Change owner of the files to "mysql".
4.Check access permision to files and directory.
Anyway, is recomended to
Hi everybody.
If I start a database using MySQL for Windows, can I later transfer it to
MySQL for Linux by just copying the database directory. Or will I have redo
it from scratch. What about my odcb connections will they continue to work
without modification on the client side.
TIA
---
>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 5:00 AM
Subject: Migration from windows to linux
> Hello list,
>
> I`m a newbie to mysql and linux and have at the moment a necessity
> concerning to both that I`m not able to handle due to my lack of
> knowle
* Sonia
> I`m a newbie to mysql and linux and have at the moment a necessity
> concerning to both that I`m not able to handle due to my lack of
> knowledge in these fields. The fact is that I need to migrate a mysql
> database and its tables from windows to linux and haven`t fo
Hello list,
I`m a newbie to mysql and linux and have at the moment a necessity
concerning to both that I`m not able to handle due to my lack of
knowledge in these fields. The fact is that I need to migrate a mysql
database and its tables from windows to linux and haven`t found
After having search in all the doc i see that I have a mysql 4.01 version
...
It was so simple a mysqld restart and all was ok.
Surely mysql have fil descriptor in memorry.
Aie aie aie.
a+.
_
Do You Yahoo!?
Get your free @yahoo.com
see : http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
If you are using MySQL Version 3.23, you can copy the .frm, .MYI, and .MYD
files between different architectures that support the same floating-point
format. (MySQL takes care of any byte swapping issues.)
2 pcs x86 1under windows xp the
:22 PM
To: [EMAIL PROTECTED]
Subject: mysql from windows to linux
Hi all,
I developp a site with some mysql table which are files myd myi n frm under
windows x86 arch.
I copy my table into a liinux box x86 arch too.
Bu when trying to modidy tables I get an Error: 1036 - Table country is read
Stange I make a ps :
mysql 6337 0.0 5.4 27588 15608 ? S23:22 0:00
/usr/sbin/mysqld
--basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/
www.
sassandra-conseil.com.pid --skip-locking
mysql server is reunnig with mysql user.
I make a su mysql :
this works
Hi all,
I developp a site with some mysql table which are files myd myi n frm under
windows x86 arch.
I copy my table into a liinux box x86 arch too.
Bu when trying to modidy tables I get an Error: 1036 - Table country is read
only
I manage the rigth of new created tables.
I get things like tha
http://www.linux-mag.com/2001-03/mysql_01.html
There ya go, you can't have it better explained, as for the user access
part.
For the data transfer, that I don't know
Etienne
Curtis Gordon wrote:
>
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
> am gearing up t
At 2:46 PM -0500 12/6/01, Erik Price wrote:
>On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
>>2) can somebody, anybody offer up some links to a quicky tutorial
>>on loading a database with existing data, and backing up an
>>existing database. I don't mean the ones in the mysql
Thank you Eric and Mike, I really appreciate the help!
>From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "Curtis Gordon" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: just moved from windows to lin
Just to add a few side notes.
We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very
stable and very reliable. :)
We have approx., 30+ clients that use the one of the MySQL servers, and we set
up each client with a .my.cnf in each of the respective root directories:
/home
On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
> Hi, I have just setup a dedicated linux/php/mysql dev box in my office
> and I am gearing up to move my databases from a windows box to the
> linux box. There are a couple of things I would like to be clear on
> before I start
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
am gearing up to move my databases from a windows box to the linux box.
There are a couple of things I would like to be clear on before I start.
1) when I am logged into linux as "user1" and I create a database, does t
On Tue, May 08, 2001 at 07:09:24PM -0400, Thalis A. Kalfigopoulos wrote:
>
> Yes, true. But is it safe to ftp them in ASCII mode as mentioned?
> I'd go for binary mode instead.
No, use BINARY.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax:
On Tue, 8 May 2001, Jeremy Zawodny wrote:
> On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote:
>
> > I have a question on moving a MySQL database from a Windows Me
> > machine to a Linux machine. Most of our tables have over 22 million
> > rows. I suppose the slow but safe way is to
On Tue, May 08, 2001 at 03:15:31PM -0700, David Potter wrote:
> I have a question on moving a MySQL database from a Windows Me
> machine to a Linux machine. Most of our tables have over 22 million
> rows. I suppose the slow but safe way is to dump the whole database
> on the Windows machine usi
Hello,
I have a question on moving a MySQL database from a Windows Me machine to a Linux
machine. Most of our tables have over 22 million rows. I suppose the slow but safe
way is to dump the whole database on the Windows machine using mysqldump and then ftp
the dump file over to the Linux box
39 matches
Mail list logo
