ZeroBr

Gostaria de reagir a esta mensagem? Crie uma conta em poucos cliques ou inicie sessão para continuar.

o Seu Forum de Conquer Online 5095


    Limpar Database

    ZeroBr
    ZeroBr
    Admin
    Admin


    Mensagens : 46
    Pontos : 103
    Reputação : 0
    Data de inscrição : 25/07/2012
    Idade : 36

    Limpar Database Empty Limpar Database

    Mensagem  ZeroBr Qua Jul 25, 2012 5:36 pm

    Só usar quando você estiver começando o seu servidor e pegar uma database cheia de accounts e dados de outro servidor

    Abrir navicat depois selecione a database zf > Query > New query e executa a query


    Código:
    DELETE FROM account;
    DELETE FROM ad_log;
    DELETE FROM cq_dyna_rank_rec;
    DELETE FROM cq_deluser;
    DELETE FROM cq_enemy;
    DELETE FROM cq_friend;
    DELETE FROM cq_item;
    DELETE FROM cq_log;
    DELETE FROM cq_magic;
    DELETE FROM cq_pet;
    DELETE FROM cq_pk_bonus;
    DELETE FROM cq_pk_item;
    DELETE FROM cq_statistic;
    DELETE FROM cq_status;
    DELETE FROM cq_superman;
    DELETE FROM cq_synattr;
    DELETE FROM cq_syndicate;
    DELETE FROM cq_tutor;
    DELETE FROM cq_tutor_access;
    DELETE FROM cq_tutor_contributions;
    DELETE FROM cq_tutor_contributions2;
    DELETE FROM cq_user;
    DELETE FROM cq_wanted;
    DELETE FROM cq_weapon_skill;
    DELETE FROM dyna_rank_rec;
    DELETE FROM flower;
    DELETE FROM ghostcontract;
    DELETE FROM item_log;
    DELETE FROM login_rcd;
    DELETE FROM secure;

    Creditos a Junior Ferraz

      Data/hora atual: Dom maio 19, 2024 6:57 pm