The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Confiration MySQL

Discussion in 'General Discussion' started by Aldweb, Jul 17, 2005.

  1. Aldweb

    Aldweb Well-Known Member

    Joined:
    Feb 18, 2004
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    When I export Bd MySql of my old server for a file .SQL, would be + / - like this:

    CREATE TABLE user (
    LOGIN VARCHAR(50) NOT NULL DEFAULT '',
    PASSWORD VARCHAR(20) NOT NULL DEFAULT '',
    PRIMARY KEY (LOGIN)
    ) ENGINE=MYISAM DEFAULT CHARSET=LATIN1;

    But when I will recuperate that BD in my new server of the mistake in the creation of BD. Then would like to know where I configure the mysql in the new server to be "DEFAULT CHARSET=LATIN1;", because like this, when I will recuperate BD in my new Server, would not give mistake.


    Thanks
     
  2. Aldweb

    Aldweb Well-Known Member

    Joined:
    Feb 18, 2004
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    I already solved. The version of the old server was 4.1 and the one of the new was 4.0. Then I also updated the version of the new server for 4.1.
     
Loading...

Share This Page