Hi Prabhat,
FYI
On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna wrote:
> If the hardware on master and slave, version of mysql server, configuration
> and memory allocations are same then you can do a clean shutdown of mysql on
> slave and copy the files to master. Check if any memories needs to b
If the hardware on master and slave, version of mysql server, configuration
and memory allocations are same then you can do a clean shutdown of mysql on
slave and copy the files to master. Check if any memories needs to be
adjusted and start mysql adding the innodb_file_per_table option on master
s
Am 14.09.2011 22:06, schrieb Prabhat Kumar:
> Hi,
>
> I have 2 machine. Master and a slave replication.
>
> few days back I have switched slave machine (innodb_file_per_table) from
> single
> innodb file to one per file table.
>
> Now I want to do for Master.
>
> Now question,
>
> Is it rec
Hi,
I have 2 machine. Master and a slave replication.
few days back I have switched slave machine (innodb_file_per_table) from single
innodb file to one per file table.
Now I want to do for Master.
Now question,
Is it recommendable this method, stop MYSQL services on both and copy mysql
file's
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
Sent: Fri 7/6/2007 6:27 PM
To: mysql@lists.mysql.com
Subject: moving database to new server
Hello, list --
Quick (and simple?) question:
I've been backing my databases up with a perl tool mysqlhotcopy. It seems
to leave me a bunch of files in a folder I specified.
What is the best w
Hello, list --
Quick (and simple?) question:
I've been backing my databases up with a perl tool mysqlhotcopy. It seems
to leave me a bunch of files in a folder I specified.
What is the best way to move this database function to a different machine?
There are no constraints. I can take it a
OK, now I get it. I'll give that a try. Thanks for the tip about the OmniWeb
browser, too.
- Original Message
From: Chris Sansom <[EMAIL PROTECTED]>
To: David Blomstrom <[EMAIL PROTECTED]>; mysql@lists.mysql.com
Sent: Sunday, October 8, 2006 1:51:33 AM
Subject: Re: Mov
At 15:01 -0700 7/10/06, David Blomstrom wrote:
Thanks. Is this something I can do through phpMyAdmin?
Yes! Easy:
First, create the database - just the database, no tables or anything
- on the Mac.
Next, go to the database on the PC in phpMyAdmin and without
selecting a table in the sidebar
t: Saturday, October 7, 2006 3:33:59 PM
Subject: Re: Moving Database from PC to Apple
Hi David
mysqldump is a command-line program which you can run through the
terminal window. The "Terminal" application is in the "Utilities"
directory under the "Applications" direct
inal Message
From: mos <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Saturday, October 7, 2006 2:26:19 PM
Subject: Re: Moving Database from PC to Apple
At 04:00 PM 10/7/2006, you wrote:
I recently purchased a MacBook Pro laptop and hired someone to
help me set
up Apache, PHP
sql@lists.mysql.com
Sent: Saturday, October 7, 2006 2:26:19 PM
Subject: Re: Moving Database from PC to Apple
At 04:00 PM 10/7/2006, you wrote:
>I recently purchased a MacBook Pro laptop and hired someone to help me set
>up Apache, PHP and MySQL on it. Now I want to import my database tables
>
At 04:00 PM 10/7/2006, you wrote:
I recently purchased a MacBook Pro laptop and hired someone to help me set
up Apache, PHP and MySQL on it. Now I want to import my database tables
from my PC. So my main question is this: Is there a quick, simple of
importing an entire database? If not, I figur
I recently purchased a MacBook Pro laptop and hired someone to help me set up
Apache, PHP and MySQL on it. Now I want to import my database tables from my
PC. So my main question is this:
Is there a quick, simple of importing an entire database?
If not, I figured I'd simply export each database
PROTECTED]
Sent: Tuesday, September 12, 2006 4:27 AM
To: mysql@lists.mysql.com
Subject: Re: Moving database to another machine
Chris wrote:
>
> An additional note - you can only do this while mysql is completely
> shut down. You cannot do this while mysql is running on either server.
>
> wrote:
Hi,
Try,
Compress - [Mac A]
shell> mysqldump -all -databases |gzip >dbfilename.sql.gz
UnCompress [Mac B]
shell> gunzip
Thanks
ViSolve DB Team.
- Original Message -
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 12, 2006 12:13 PM
Su
Chris wrote:
An additional note - you can only do this while mysql is completely
shut down. You cannot do this while mysql is running on either server.
why is it that I received this mail 3 times? I can understand 2 (one to
my and one to the list), but 3 ...
--
Email.it, the profess
Nico Sabbi wrote:
Ratheesh K J wrote:
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both
the machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole th
Ratheesh K J wrote:
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on M
Hi,
Try,
Compress - [Mac A]
shell> mysqldump -all -databases |gzip >dbfilename.sql.gz
UnCompress [Mac B]
shell> gunzip
Thanks
ViSolve DB Team.
- Original Message -
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 12, 2006 12:13 PM
Su
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
On 6/5/06, Jay Paulson <[EMAIL PROTECTED]> wrote:
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file. I'm trying to find out if I change the "basedir" from:
Basedir=/var/lib
To
Basedir=/other/path
Will that move the actual data files that have all my datab
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file. I'm trying to find out if I change the "basedir" from:
Basedir=/var/lib
To
Basedir=/other/path
Will that move the actual data files that have all my databases? Do I need
to move any of the things that are
Windows does not preserve the case sensitivity of the table names.
-Original Message-
From: Bert Beaudin
To: [EMAIL PROTECTED]
Sent: 7/29/04 11:02 AM
Subject: Moving database from windows 3.x to unix 4.x
Hello all
Can any one give some advise on moving mysql databases from
Hello all
Can any one give some advise on moving mysql databases from
windows 3.x to unix 4.x
I have created dump files using:
Mysqldump --user=myuser --password=mypassword --opt database
>database.dump
Are there any issues I shoud be looking out for?
Thanks,
Bert
--
MySQL General Mail
On 12-Apr-2004 Riaan Oberholzer wrote:
> I'm, using mysqldump to dump a complete database on a
> server in The Netherlands and want to load the
> generated SQL onto a server in the USA to make an
> exact copy of the database.
>
> However, I have Timestamp(14) fields that are dumped
> as e.g. "200
I'm, using mysqldump to dump a complete database on a
server in The Netherlands and want to load the
generated SQL onto a server in the USA to make an
exact copy of the database.
However, I have Timestamp(14) fields that are dumped
as e.g. "2004101015" local time and is read as
local time too
Adam Clauss wrote:
I am going to possibly have to transfer a MySQL database that is currently
running on Windows to a Linux/Unix box (not sure exactly what version it is
running yet). Any pitfalls to avoid here?
Thanks
Adam Clauss
[EMAIL PROTECTED]
I would use 'mysqldump' to backup the databas
I am going to possibly have to transfer a MySQL database that is currently
running on Windows to a Linux/Unix box (not sure exactly what version it is
running yet). Any pitfalls to avoid here?
Thanks
Adam Clauss
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.my
Hi, I am moving a myself database from one hosting company to another for a website.
I have statements like:
INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( '22022002', '79');
But MySQL comes back with:
INSERT INTO mpn_shopping_4nstats_datecnt VALUES ( \'22022002\', \'79\');
MySQL said:
Y
iling List
Subject: RE: Problem with moving database using mysqldump
Hi,
Some of the old mysqldump apps have a bug where they're missing quotes on
long rows. Try the dump the other way - i.e. use the mysqldump client on
the new machine and pipe it from the old machine back to the new machine
(ma
Hi Mike,
I hope you are on linux machine, What are versions on
old and new machines, is there any difference?.
just tar the data dir /var/lib/mysql (in most of the
cases) and untar on the new machines by moving the
existing mysql directory by this old data.
I don't think this will fail, I have
d one...).
With something like:
> mysqldump -h oldmachine -u username olddatabase | mysql newdatabasename
Cheers,
Andrew
Sql,query
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Friday, 04 October 2002 01:25
To: MySQL Mailing List
Subject: Problem with moving
Hello All;
I am having a problem using the mysqldump application. I have an old server
that I am trying to move to a faster machine. No matter what I do, about 90
queries in the connection ceases and the old meachine gets a server has gone
away error. I have tries runnig mysql dump piped to the m
Although I wouldn't suggest doing this, it seems to work fine for me. I
suggest in moving the directory, do not make ANY changes to the permissions -
any. Just do this as root:
(Assuming you have redhat'ish directory structure)
cd /var/lib/mysql
mv dbname /home/user/database
ln -s /home/user/d
Hello All,
Hoping someone can point where I may have gone wrong on setting our client's
databases within their own respective home directories. Here is one of the
setups dir tree and settings:
The database 'tracers' is symbolically linked from the datadir to the client's
home directory. But for
Jeremy Falcon writes:
> To be honest, I'm not sure if you can just transport the db files. I'm sure
> it won't work it you're using different versions of MySQL on the machines.
>
> What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
> statements to recreate the table. I
orked.
Cheers
M;)
-Original Message-
FROM: George Pitcher
TO: [EMAIL PROTECTED]
DATE: Fri 8/24/01 7:56
SUBJECT: Moving database from NT > Linux
Hi all,
I'm getting closer and closer to having MySQL/PHP/Apache set up on my
LinuxPPC box.
Now, I haven't been sitting twiddling my
-u{username} -p<{databasename}.sql
Gerald Jensen
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 8:42 AM
Subject: Moving database from NT > Linux
Hi all,
I'm getting closer and clos
ns.
Jeremy
- Original Message -
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 8:42 AM
Subject: Moving database from NT > Linux
> Hi all,
>
> I'm getting closer and closer to having MySQL/PHP/Apache set up
Hi all,
I'm getting closer and closer to having MySQL/PHP/Apache set up on my
LinuxPPC box.
Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead
I was building a database on MySQL on NT.
I would like to move this to Linux asap. There are 6 tables with between 8
and 40 fi
It may be a solution for you...i simply copied the Mysql databases from
windows to suse 7.1 and it worked just fine!
David.
Glyn Davies wrote:
> Good day,I have created a database using MySQL under Windoze and am
> trying to move the data to MySQL running on Linux. I have exported the
> data to
+49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Glyn Davies
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 8:00 AM
Subject: Moving database from windoze to Linux
Good day,
I have created a database using MySQL under Windoze and am trying to move t
try to use
mysqlfront ( http://www.mysqlfront.de ), a windows GUI for mysql i've tried
it and it works like a charm
you can export table structure in a .sql format and then dump data into a
csv file and use the same utlity to import the files into your linux machine;
regards;
At 08:00 27/07/0
Good
day,
I have created a
database using MySQL under Windoze and am trying to move the data to MySQL
running on Linux. I have exported the data to a res file - can't see how to do a
mysqldump in Windoze. I then try and import the file on the Linux machine using
LOAD DATA, but end up with
I've created the databases on the new server, but when I do:
mysqldump --quick --add-drop-table --add-locks --extended-insert
--lock-tables TestDatabase | mysql -h newserver TestDatabase
I get the error message:
ERROR 1063 at line 30: Incorrect column specifier for column 'ID'
The originating
Ming Hsu ([EMAIL PROTECTED]) writes:
> Hi, I've been working with mysql for a couple of months now for my
> website. Now I have to move to a different server, and would like to move
> the database as well. Problem is I have no idea what this entails and how
> to do it. Can someone help me? Tha
On Mon, Feb 19, 2001 at 04:34:05AM -0700, Ming Hsu wrote:
> Hi, I've been working with mysql for a couple of months now for my
> website. Now I have to move to a different server, and would like to move
> the database as well. Problem is I have no idea what this entails and how
> to do it. Can s
Hi, I've been working with mysql for a couple of months now for my
website. Now I have to move to a different server, and would like to move
the database as well. Problem is I have no idea what this entails and how
to do it. Can someone help me? Thanks.
Ming Hsu
-
55 matches
Mail list logo