Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    63

    Unanswered: Question on MySQL migration and etc

    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;
    Code:
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    | test               |
    | aaa	             |
    | bbb etc            |
    +--------------------+
    mysql> USE aaa;

    mysql> SHOW tables;
    Code:
    +-----------------------+
    | Tables_in_aaa         |
    +-----------------------+
    | 111		        |
    | 222	                |
    | 333		        |
    | 444 etc	        |
    +-----------------------+
    mysql> SELECT * FROM aaa;
    Code:
    +----+-------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+--------------+-------------+----------------+-------------+---------------+------------------
    Whether above indicates that there is no data/entry on the database?

    mysql> SHOW columns from 222;
    Code:
    +-----------------------+---------------------+------+-----+---------------------+----------------+
    | 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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you are migrating from one server to another then consider using MySQLDump
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2006
    Posts
    63
    Quote Originally Posted by healdem View Post
    if you are migrating from one server to another then consider using MySQLDump
    Thanks for your advice.

    mysqldump is NOT on Ubuntu 12.04 repo. mydumper is on its repo. Is there any difference btw them?

    rgds
    satimis

  4. #4
    Join Date
    Apr 2013
    Posts
    1
    Quote Originally Posted by satimis View Post
    Thanks for your advice.

    mysqldump is NOT on Ubuntu 12.04 repo. mydumper is on its repo. Is there any difference btw them?

    rgds
    satimis
    PHPmyadmin is, and it includes mysqldump - it comes under the export tab

  5. #5
    Join Date
    Jun 2006
    Posts
    63
    Quote Originally Posted by Hwalker1 View Post
    PHPmyadmin is, and it includes mysqldump - it comes under the export tab
    I got it. Thanks

    satimis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •