[opensuse] migrating mysql data from 10.2 to 10.3?
Hi All, The subject line says it all. I've just installed 10.3 and need to transfer my localhost-only mysql databases, etc., to the new setup. What's the fastest easiest 'no-frills' commandline solution? (assume prior '/' is mounted under '/mnt/') :-) TIA & regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Carl Hartung wrote:
Hi All,
The subject line says it all. I've just installed 10.3 and need to transfer my localhost-only mysql databases, etc., to the new setup.
What's the fastest easiest 'no-frills' commandline solution? (assume prior '/' is mounted under '/mnt/') :-)
mysqldump => mysqlimport start at http://dev.mysql.com/doc Cheers, Dave -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Dave Howorth wrote:
Carl Hartung wrote:
Hi All,
The subject line says it all. I've just installed 10.3 and need to transfer my localhost-only mysql databases, etc., to the new setup.
What's the fastest easiest 'no-frills' commandline solution? (assume prior '/' is mounted under '/mnt/') :-)
mysqldump => mysqlimport start at http://dev.mysql.com/doc
Cheers, Dave
Even quicker cp -a /mnt/var/lib/mysql /var/lib/ Cheers, David -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thu December 13 2007 11:12:38 am David C. Rankin wrote:
Even quicker
cp -a /mnt/var/lib/mysql /var/lib/
Cheers, David
Thanks Dave and David, I opted for mysqldump -> mysqlimport and it seems to be running fine. :-) regards, Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thursday 13 December 2007 08:12, David C. Rankin wrote:
Dave Howorth wrote:
Carl Hartung wrote:
...
What's the fastest easiest 'no-frills' commandline solution? (assume prior '/' is mounted under '/mnt/') :-)
mysqldump => mysqlimport start at http://dev.mysql.com/doc
Cheers, Dave
Even quicker
cp -a /mnt/var/lib/mysql /var/lib/
This is not generally a good idea. If you're using the older MySQL file format (called MyISAM), it might work. If you're using the newer InnoDB file format (the only one that supports all of MySQL's features, by the way), then simply copying files is susceptible to failure. Dump and import is the right way, even if it's not as fast.
Cheers, David
Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Randall R Schulz wrote:
On Thursday 13 December 2007 08:12, David C. Rankin wrote:
Dave Howorth wrote:
Carl Hartung wrote:
...
What's the fastest easiest 'no-frills' commandline solution? (assume prior '/' is mounted under '/mnt/') :-) mysqldump => mysqlimport start at http://dev.mysql.com/doc
Cheers, Dave Even quicker
cp -a /mnt/var/lib/mysql /var/lib/
This is not generally a good idea. If you're using the older MySQL file format (called MyISAM), it might work. If you're using the newer InnoDB file format (the only one that supports all of MySQL's features, by the way), then simply copying files is susceptible to failure.
Dump and import is the right way, even if it's not as fast.
Cheers, David
Ah, true, but 10.2 - 10.3, both with mysql 5.x should be OK with both MyISAM and InnoDB files. I wouldn't recommend a straight copy of something as far apart as 10.0 -> 10.3. Good point Randall -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Thursday 13 December 2007 11:56, David C. Rankin wrote:
Randall R Schulz wrote:
On Thursday 13 December 2007 08:12, David C. Rankin wrote:
...
Even quicker
cp -a /mnt/var/lib/mysql /var/lib/
This is not generally a good idea. If you're using the older MySQL file format (called MyISAM), it might work. If you're using the newer InnoDB file format (the only one that supports all of MySQL's features, by the way), then simply copying files is susceptible to failure.
Dump and import is the right way, even if it's not as fast.
Cheers, David
Ah, true, but 10.2 - 10.3, both with mysql 5.x should be OK with both MyISAM and InnoDB files. I wouldn't recommend a straight copy of something as far apart as 10.0 -> 10.3.
The point is that InnoDB files per se are intrinsically non-portable in the way MyISAM files are. It has less to do with versions than it does to do with the way InnoDB integrates multiple tables and databases into a single file (or set of files).
... David C. Rankin
Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (4)
-
Carl Hartung
-
Dave Howorth
-
David C. Rankin
-
Randall R Schulz