export database

[Sebastian Ching]

Hi, i wanna export a database with my players and import in other database, but i dont know how to do.
Im using gesior account with xampp 1.7.3
Please help.
Thanks a lot.

 

[TGYoshi]

Export

mysqldump -u user_name -p database_name > export.sql

Import

mysql -u user_name -p database_name < export.sql

 

[Sebastian Ching]

thanks, i gonna test

- - - Updated - - -

im having this error

#1062 - Duplicate entry '1' for key 'PRIMARY'

 

[Cronox]

Duplicate entry
You have account 1 and try add same account made by is account: 1

 

[Dylanaw]

Just change in the database where u want to import, change the account id + pass and try to import it then. (or just remove account manager 1/1)

 

[Sebastian Ching]

Error

consulta SQL:

-- -- Volcar la base de datos para la tabla `accounts` -- INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES (1, '1', 'mamalo123', '', 7, 1348099772, '', '0', 0, 0, 1, 1348029834, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0), (2, 'seba', '7666719cea934dfba26ebacd59c0adc00243268f', '8AuLNSdz7Tr4IWKe9Yx-A4YKYJzDpA57m84I25F', 0, 0, '', '0', 0, 0, 1, 0, '', 0, 0, '', '', 3, '0', 0, 1500, 0, 0, '', 0), (3, 'lolazo', '0db8a7658eeadbc003e4389109df4ce07ad4f4be', 'O7hqJCINAP8KN95vu27-S5M28zWKOMXEf975KTk', 7, 1348099772, '', '0', 0, 0, 1, 0, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, '', 0), (191346, 'sosnel', 'fb7825d55c9d4097981b9eaf86c401f913e47833', '', 7, 1348099772, '[email protected]', '0', 0, 0, 1, 0, '', 0, 1348012[...]

MySQL ha dicho: Documentación
#1054 - Unknown column 'vip_time' in 'field list'

 

[TGYoshi]

You attempt to insert a row with account data, containing a field 'vip_time'. The table you try to import it in, does not have that column.