[plug] moving MySQL

[James Devenish]

In message <sf44072b.094 at mmtnetworks.com.au>
on Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon  Miller wrote:
> We've run out of disk space and would like to move either the entire
> MySQL system or if possible move the databases.  Can this be done
> without any difficulties?

This is funny. You asked this question in March! Here are the answers
from that time:

In message <20030302112908.GA3247 at gulag.guild.uwa.edu.au>
on Sun, Mar 02, 2003 at 07:29:09PM +0800, James Devenish wrote:
> If you have the same MySQL version on the same hardware, it is
> possible
> to simply copy the files over (e.g. it's like making a backup).
> Otherwise, an export/import process. A quick glance at the docs
> (RTFM) revealed:
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#mysqldump
> http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#mysqlimport
> http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Moving
>
> Anecdotally, these things work as documented.

In message <00fe01c2e0ae$d3498fa0$0200a8c0 at Goldfinger>
on Sun, Mar 02, 2003 at 07:26:45PM +0800, Daniel Pearson wrote:
> If I remember correctly from when I used to use MySQL you could dump
> to a .sql file, then import it on the new server.. but I could be
> wrong.

In message <20030302033105.A21352 at linmagau.org>
on Sun, Mar 02, 2003 at 03:31:05AM -0800, Kimberly Shelt wrote:
> try msqldump whatever db.. then ssh it to where it needs to go :)
> and pipe it in to the new space.. mysql.com has a searchable docs
> space.. usually pretty helpful :)

In message <200303021939.26916.derekfountain at yahoo.co.uk>
on Sun, Mar 02, 2003 at 07:39:26PM +0800, Derek Fountain wrote:
> MySQL uses the file system to manage its underlying database
> structure.  Creating a database actually boils down to a simple
> "mkdir" in the right place, etc. So you can just copy the files over.

In message
<Pine.LNX.4.44.0303022029510.13025-100000 at mail.nathanalberti.com>
on Sun, Mar 02, 2003 at 08:34:05PM +0800, Nathan Alberti wrote:
> mysqldump [OPTIONS] database [tables]
> mysqlimport [OPTIONS] database textfile