Fwd: Re: samba + mysql
entao esse arquivo vem junto ao samba
na pasta /pdb/mysql/mysql.dump junto com smb.conf de exemplo
# Put this in your MySQL database by running
# mysql -u<user> -p<password> -h<host> <database> < mysql.dump
CREATE TABLE user (
logon_time int(9),
logoff_time int(9),
kickoff_time int(9),
pass_last_set_time int(9),
pass_can_change_time int(9),
pass_must_change_time int(9),
username varchar(255),
domain varchar(255),
nt_username varchar(255),
nt_fullname varchar(255),
home_dir varchar(255),
dir_drive varchar(4),
logon_script varchar(255),
profile_path varchar(255),
acct_desc varchar(255),
workstations varchar(255),
unknown_str varchar(255),
munged_dial varchar(255),
uid int(9) NOT NULL DEFAULT "0" PRIMARY KEY auto_increment,
gid int(9),
user_sid varchar(255),
group_sid varchar(255),
lm_pw varchar(255),
nt_pw varchar(255),
acct_ctrl int(9),
unknown_3 int(9),
logon_divs int(9),
hours_len int(9),
unknown_5 int(9),
unknown_6 int(9) default "1260",
bad_password_count int(9),
logon_count int(9)
);
esse e mysql.dump falow
=D
maiquel wrote:
galera to tentando importa pro mysql.
o mysql.dump so que da esse erro
maniac:/usr/local/mysql/bin# ./mysql -uroot -pteste samba < mysql.dump
ERROR 1067 (42000) at line 4: Invalid default value for 'uid'
Se vc tentar rodar apenas
./mysql -uroot -pteste samba
funciona ok?
manda o comeco do arquivo mysql.dump - não dá pra adivinhar o que tem
nele! Ou dá? :)
Como vc gerou esse dump? veio de outra versão?
--
Marcos
Reply to: