Re: Moving DB to another System

: Subject: Moving DB to another System From: Ow Mun Heng [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Fri, 13 Oct 2006 12:11:24 +0800 X-Mailer: Evolution 2.6.2 Hi All, Wondering if it's possible for me to just tar up the DB (eg: TEST_DB) and then move it AS IS to another system

Re: Moving DB to another System

, Oct 13, 2006 at 12:11:24PM +0800, Ow Mun Heng wrote: Subject: Moving DB to another System From: Ow Mun Heng [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Fri, 13 Oct 2006 12:11:24 +0800 X-Mailer: Evolution 2.6.2 Hi All

Re: Moving DB to another System

copy and attach the DB from A - B system On Fri, Oct 13, 2006 at 12:11:24PM +0800, Ow Mun Heng wrote: Subject: Moving DB to another System From: Ow Mun Heng [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Fri, 13 Oct 2006 12:11:24 +0800 X-Mailer: Evolution 2.6.2 Hi All

Moving DB to another System

Hi All, Wondering if it's possible for me to just tar up the DB (eg: TEST_DB) and then move it AS IS to another system? Is this possible or will I have to do a mysqldump (inclusive of create tables / data etc)?? It would be good if I can just copy (tar) the DB to another system and then

Re: moving DB from one box to another.

Ian Sales said: Randy Paries wrote: The problem is I get this wonderfully verbose :-( error message :::ERROR at line 362701 - MySQL can't parse something on line 362701 of your dump file. One possibility is an index named with a keyword, which 3.23.x appears to allow but 4.0.x doedsn't.

RE: (FIXED...)moving DB from one box to another.

Thanks for all your help FYI, I had to add this to the my.cfg set-variable= max_allowed_packet=16M Randy -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Re: moving DB from one box

Re: moving DB from one box to another.

Randy Paries wrote: The problem is I get this wonderfully verbose :-( error message :::ERROR at line 362701 - MySQL can't parse something on line 362701 of your dump file. One possibility is an index named with a keyword, which 3.23.x appears to allow but 4.0.x doedsn't. Edit the dump file

RE: moving DB from one box to another.

: Re: moving DB from one box to another. At 23:21 -0600 12/15/04, Randy Paries wrote: hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data

moving DB from one box to another.

hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox oldbox.sql then

Re: moving DB from one box to another.

At 23:21 -0600 12/15/04, Randy Paries wrote: hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a

Re: Moving DB

.: datadir = E:/mysql/data/ 6. In DOS, start the MySQL server (NET START MYSQL) G. Jensen - Original Message - From: Sparky Kopetzky [EMAIL PROTECTED] To: My Sql List [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 12:24 AM Subject: Moving DB I have a database that is getting too big

Moving DB

I have a database that is getting too big for the drive it's on. How do change my.ini to make it see everything after I move the mysql/data folder?? or is there more to it than that?? BTW - I'm running on Windows NT 4.0 SP6 w/ gig of ram... Robin E. Kopetzky Black Mesa Computers/Internet