about MySQL migration etc

[Stephen Liu]

Hi all

1)
OS Ubuntu 12.04 desktop 64bit
2)
OS Fedora 18 desktop 64bit

migrating MySQL from 1) to 2) same version

I found many suggestions on Internet re migrating database and unable to ascertain the easiest way on its migration. Please advise. TIA

Besides on running following commands;

mysql> SHOW databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| aaa |
| bbb etc |
+--------------------+

mysql> USE aaa;

mysql> SHOW tables;
+-----------------------+
| Tables_in_aaa |
+-----------------------+
| 111 |
| 222 |
| 333 |
| 444 etc |
+-----------------------+

mysql> SELECT * FROM aaa;
+----+-------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------------+-------------+----------------+-------------+---------------+------------------

Whether above indicates that there is no data/entry on the database?

mysql> SHOW columns from 222;
+-----------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------------------+----------------+
| ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| xxx | bigint(20) unsigned | NO | MUL | 0 | |
| yyy | datetime | NO | | 0000-00-00 00:00:00 | |
| zzz etc | datetime | NO | | 0000-00-00 00:00:00 | |
+-----------------------+---------------------+------+-----+---------------------+----------------+

What command shall I run to display the columns and their content in readable form?

Thanks

SL