Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    156
    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:
    156
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice