[Help]MySql Problem (Sql File Error)

Results 1 to 12 of 12
  1. #1
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    config [Help]MySql Problem (Sql File Error)

    ok well i was planning to do some shit with a repack i have and i decided to play around with a server i have.
    well i was running the sql file and i came across this:

    anyone know how to fix it? if you could, it would be much of an assistance to a noob :D. anyways, thanks for reading.

    -btw i searched this up to see if this was already posted, but i couldnt find anything so yea. if this was already posted then fml.
    -i just figured out this is the wrong section :( mods please move.
    Last edited by DatGuy; 31-08-11 at 02:21 AM.


  2. #2
    Account Upgraded | Title Enabled! dennytan91 is offline
    MemberRank
    Aug 2011 Join Date
    Kota KinabaluLocation
    287Posts

    Re: [Help]MySql Problem (Sql File Error)

    Wrong selection ,

    Try this

    ENGINE=InnoDB Auto_INCREMENT=6 DEFAULT CHARSET=lantin1 ROW_FORAT=DYNAMIC;

  3. #3
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    Quote Originally Posted by dennytan91 View Post
    Wrong selection ,

    Try this

    ENGINE=InnoDB Auto_INCREMENT=6 DEFAULT CHARSET=lantin1 ROW_FORAT=DYNAMIC;
    sorry if its the wrong section. and how is that supposed to help? its the problem with the sql.

  4. #4
    Account Upgraded | Title Enabled! dennytan91 is offline
    MemberRank
    Aug 2011 Join Date
    Kota KinabaluLocation
    287Posts

    Re: [Help]MySql Problem (Sql File Error)

    Show me drop_data_global SQL

  5. #5
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    here

    and what are u talking about? all the crap is all in one sql

  6. #6
    Account Upgraded | Title Enabled! dennytan91 is offline
    MemberRank
    Aug 2011 Join Date
    Kota KinabaluLocation
    287Posts

    Re: [Help]MySql Problem (Sql File Error)

    Try this , Not sure work .

    Code:
    --
    -- Definition of table `drop_data_global`
    --
    
    DROP TABLE IF EXISTS `drop_data_global`;
    CREATE TABLE `drop_data_global` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `continent` int(11) NOT NULL,
      `dropType` tinyint(1) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `minimum_quantity` int(11) NOT NULL DEFAULT '1',
      `maximum_quantity` int(11) NOT NULL DEFAULT '1',
      `questid` int(11) NOT NULL DEFAULT '0',
      `chance` int(11) NOT NULL DEFAULT '0',
      `comments` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `mobid` (`continent`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

  7. #7
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    doesnt work ... thanks for trying

  8. #8
    Account Upgraded | Title Enabled! dennytan91 is offline
    MemberRank
    Aug 2011 Join Date
    Kota KinabaluLocation
    287Posts

    Re: [Help]MySql Problem (Sql File Error)

    What Source Are You Using ?

  9. #9
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    polaris?

  10. #10
    Account Upgraded | Title Enabled! dennytan91 is offline
    MemberRank
    Aug 2011 Join Date
    Kota KinabaluLocation
    287Posts

    Re: [Help]MySql Problem (Sql File Error)

    Erm .

  11. #11
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    which mysql version are u using?
    cuz it isnt working.
    same basically same image again.

  12. #12
    Apprentice DatGuy is offline
    MemberRank
    Jul 2011 Join Date
    In The FutureLocation
    8Posts

    Re: [Help]MySql Problem (Sql File Error)

    bump. please help.



Advertisement